Forum Discussion
Macros/VBA not working
Hi, I have created macro in attached "sample.xlsm" file with name "start_import". The function of macro is to import file and paste into "sample" file with a predefined format. It works fine unless...
Alternatively, it would be great help if you can create VBA/Macro that works for importing data from different directories.
Dharmendra_BharwadHere is an Excel Workbook, in a Zip File, that Contains a UserFrom. You will need to Unzip the file first. The UserForm will run when you open the Workbook.
The UserForm contains an Example of how to use the FileDialog to find a folder, or a CSV File.
Hope that helps.
Thanks for posing the code. FYI - when you post code, it makes sense to have it heavily commented, indented properly, and only post the portion of the code that is not working or where you need help.