Recent content by motabrasil

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...

Thank you Hui for your feedback I really apologize for my cross-post. I missed this rule. Kind regards

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

I replaced and I could see the code captured the file but stop in the loop For (For f = 1 To UBound(fn)) with "Run-time error '13': Type mismatch