• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Password Mask for Inputbox VBA crashing Excel 2016

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

    Password Mask for Inputbox VBA crashing Excel 2016

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

    Excel CustomUI Ribbon - Retrieve variable value to use in another Sub()

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

    Excel CustomUI Ribbon - Retrieve variable value to use in another Sub()

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

    Open Excel File Unknow Extension

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

    Open Excel File Unknow Extension

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

    Open Excel File Unknow Extension

    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)...
  8. M

    Gmail With Excel File as Attachment

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

    Gmail With Excel File as Attachment

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

    VBA Instr Function Capture Exact Match

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

    VBA Instr Function Capture Exact Match

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

    VBA Instr Function Capture Exact Match

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

    VBA Instr Function Capture Exact Match

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

    VBA Unzip Files

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

    VBA Unzip Files

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

    VBA Unzip Files

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

    VBA Unzip Files

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

    VBA Unzip Files

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

    VBA Unzip Files

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

    VBA Unzip Files

    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()...
  21. M

    VBA Unzip Files

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

    VBA run a Loop into another Loop [SOLVED]

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

    VBA run a Loop into another Loop [SOLVED]

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

    VBA run a Loop into another Loop [SOLVED]

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

    Splitting a rows of comma separated values into multiple lines

    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
Back
Top