Posts by John Hebert • 151 points
11 posts
-
1
votes0
answers403
viewsQ: 0 the left power query
I’m having some problems, what is the command to add 0 to the left in the M language? I’m using the power query excel, I have data starting with 0 but it does not consider this value and brings me…
excelasked John Hebert 151 -
0
votes1
answer95
viewsQ: Year/Month/Day... how to do
but I need him to manage me a portfolio of year, month and day Can someone help me? follow... ' informacoes Public cDay, cMonth, cMonthName, cPath Function identificarData() ' Identificar o caminho…
vbaasked John Hebert 151 -
1
votes1
answer500
viewsQ: Several filters with VBA
Guys good afternoon I need to perform a filter on a worksheet column, collect a certain value and delete the rest of the same column. I have this code but it only works for 1 tab. I need a Cod for…
vbaasked John Hebert 151 -
1
votes1
answer128
viewsQ: Copy, Filter paste vba
Guys good afternoon, I need to filter the data in column B containing "Cell 01" And delete the other data from this column.( in VBA ) I have some observations to be made in the project. 1- I need to…
vbaasked John Hebert 151 -
2
votes1
answer8769
viewsQ: Calling a macro in different modules
Guys good morning, I created several macros, but I want to unify everything, the same are in different modules. how do I put them together and run everything at once? follows the Cod I found but did…
vbaasked John Hebert 151 -
1
votes1
answer130
viewsQ: Delete unwanted VBA values
Guys good morning, I have the following macro to run a filter inside a column and bring me a determined value. however, within that same column there are other values, I would like to exclude the…
vbaasked John Hebert 151 -
2
votes1
answer2174
viewsQ: attach file and send vba email
Good morning guys, I need some help.. I have this macro she’s working perfectly but I need to add 1 things to it. When she run and generate the new file with the tabs I selected, I need you to open…
vbaasked John Hebert 151 -
1
votes1
answer1985
viewsQ: Auto VBA Filter - excel
I need to make a filter with a certain value in a spreadsheet tab,after the filter is done, I need to copy, open a new document, and paste this statement. I developed the code below but it’s not…
vbaasked John Hebert 151 -
1
votes1
answer955
viewsQ: Generate a file and attach in the email with vba
I did a macro where she opens the outlook, until then beauty. now I need to complement her with the following items. I need to take 4 tabs of my spreadsheet, generate a new file and then attach in…
vbaasked John Hebert 151 -
2
votes1
answer66
viewsQ: Saving file automatically VBA
Guys I made this macro to create folders and subfolders automatically, but I need to save the file I’m editing inside the created folder... someone can help me? Follows the script ' MACRO PARA CRIAR…
vbaasked John Hebert 151 -
1
votes1
answer266
viewsQ: Error at runtime '13'
I am creating a macro to erase the values of the cell that contains #N/D, but it gives me presents (Error at runtime '13') When I put #N/A the code works. Someone can help me solve the problem?…
vbaasked John Hebert 151