• 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 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...
  2. 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...
  3. 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)...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. M

    Hello everybody

    I'm from Phoenix-AZ and have been watching the way people post solution here. It's simply fantastic!!! Congratulations!
  9. M

    Copy and Paste a Range based on the variable value

    I have a spreadsheet with many columns. However, 2 of them may have multiple values that need to be split in different rows. What I want to do is, when I find the cells with multiple value {Chr (10)}, I need to split them in the following rows (below) and keep all the others information from...
Back
Top