Hi Deepak
Thank you for your prompt support but this is exactly the code I'm using here.
It works fine for Excel 32 bits but keep crashing with 64 bits.
Thanks
Hi everyone
It's very nice to be back to this forum. Need your priceless support one more time.
Here is my history:
I got a situation after update my Office pack from 2010 to 2016. Several of my macros stopped working and was necessary make them work with 32 and 64 bits. But now, I got one issue...
Hi There
I have a macro that use a CustomUI Ribbon with dynamic Dropdown menu (see described below).
Based on selection, the user should click in a button and run another macro that would open another workbook.
The value from the dropdown is captured by "returnedVal1" but when I try to use it...
Hi SirJB7
Sorry for my latest reply. I was in a international business travel.
I tested your suggestion and worked perfect.
Thank you very much for your support.
Regards
A Mota
Hi SirJB7
See described below the portion that check the files. We have the same loop to check 30 different files every day, based on drop down menu.
It works fine if those files are saved as .xlsx
However, when any file is saved as .xls the code stop with the message "...was not found".
Someone...
Hi,
I have a code that capture several files saved in a specific folder by users. However, even asking the users to save as .xlsx files, some files were saved as .xls and the macro cannot find them.
Is there a way to prevent this error, making the code open any extension saved (.xls or .xlsx)...
Dear all
After some arrangements, I'm using the code described below which is working fine.
The only issue I found is: the first gmail is released with its own attachment (one).
However the gmail keep accumulating the attachments from the second on.
I mean, at the end, the fourteenth gmail has...
Hello VBA Masters
I have a big challenge today. I need to send a group of emails using GMail once a week.
I have a list of names, email address, cc and email body are on my master file. And, each email from my list needs to attach a file that has the same Name from master file. All files are...
Simple like that!? You rock!!! Again! It works perfect!
Just for curiosity, which other best way I could use considering that the list of names can vary very often and I don't want to change my code every time I got a change?
By the way. Nice name for your code.
Thanks once again
Is there any other Function to replace this "INSTR" that can capture the exact match?
This Function works great when you have different strings. But when they are similar..
doesn't.
I got the same mistake. Considering the same example of Group of Customers Name as:
Gr1 = Nissan
Gr2 = Nissancsv, Nissancou
Gr3 = Nissanrv
The total of GR1 is correct but the Gr2 and Gr3 is wrong, the code is giving me for Gr2 the total of Gr1 + Gr2 and for Gr3, the total of Gr1 + Gr3.
It...
Hi there
Masters of Excel, I need your help once again. I have a code that it's working almost perfect. However, I just note something is going wrong and I didn't figure out how to fix that. I'm using INSTR Function to search a name inside a group of names and execute some calculation if the...
Hi Ninja
Won't be necessary to use your "Carioca" or "Paulista" at that time. I got you.
The code is working great now.
You rock once again!!!
Thanks
MotaBrasil
Yes. Just one ZIP file per folder. The Initial name (in bold) is the same and the numeric portion
vary (i.e: detailReports_113_9_3_8_34_0)
PS.: Nice beaches over there.
Hi Ninja
Vc entendeu muito bem!!!! (You got it!!!) Your Portuguese is perfect!
My problem is, I have a huge code running with several reports and one of them comes as ZIP.
The report that comes as ZIP has a different name every time I run it but it resides in the same folder
as resides the...
Hi Ninja
The Code is working fine but still Pop-up the browse to select the zip file instead of open it automatically
(See attached).
How to force the code to select and open the zip file automatically?
The Macro and the ZIP file will be always in the same.
Thanks once again
Motabrasil
Hi Ninja,
Actually "directory" is the path from the workbook where I save my Macro and "detailReports" is the Initial Name from my ZIP file. The ZIP file name changed every time I run the report from SAP but the initial name doesn't change.
I was trying to address my code to capture this ZIP...
I have the code described below which is working almost perfect. The only thing I want to change is
the code ask me to browse the file instead of open it automatically.
What should I change in my code to have it opening my Zip file automatically?
Thanks in advance
*****
Sub UnzipFiles()...
Hi There
I have a challenge today and this is related to:
How can we UNZIP csv. files and convert them into an Excel files in the same folder?
I have a Folder with several files. One of them resides my macro and another one is a ZIP file with around ten CSV.files inside. My need is: when I run...
I created the "helper" column and concatenated one sheet as suggested.
It worked great!!!!! Reduced thousand of loops doing this.
Thanks Guys!!!
You saved my day.
Great observation Luke. Thanks!
Save a lot of time. But the code is still taking long time to cover whole sheet. Any other idea will be very welcome.
Thanks
***
lRow = Sheet2.Range("A" & Rows.Count).End(xlUp).Row
nRow = Sheet1.Range("B" & Rows.Count).End(xlUp).Row
For n = 2...
Dear friends,
I have a macro that seems to work perfectly when testing. However it stuck when I move it to a real word (more than thousand row data). The purpose of this code is to compare to different sheets and make some calculation when the search match. The problem is each sheet has more...
Hi Sir,
I figured out how to have this working for my needs.
I adjusted my file to use the macro above and it works fine now.
Thanks for all support.
Mota