MrAutomate
asked on
Excel VBA help
I need an experts help. I have two files. SCOUT.XLSM and a TOOL file. The tool files creates a DEALDESKHISTORY.XLSX file.
In SCOUT, are numerious XL files listed in column A.
I need the TOOL to open each file listed in SCOUT, copy the values ( Sub PopulateData() ) from each file in SCOUT to a row in DEALDESKHISTORY file. It involves looping, and is way above my head. An expert lent some assistance, but I was not getting it and need additional help. FOrmer case was https://www.experts-exchange.com/questions/28914245/Help-with-Excel-VBA.html,
I have attached SCOUT.XLSM and the Tool file. The MODULE in TOOL is called Mod_Review, and I have made comments there.
The overall goal of the tool is to take numerous excel form values and and create a history in the DEALDESKHISTORY file.
Please provide the corrected module(s) and I can copy / paste and test.
Thanks a Million!
Tool_01252016.xlsb
Scout.xlsm
In SCOUT, are numerious XL files listed in column A.
I need the TOOL to open each file listed in SCOUT, copy the values ( Sub PopulateData() ) from each file in SCOUT to a row in DEALDESKHISTORY file. It involves looping, and is way above my head. An expert lent some assistance, but I was not getting it and need additional help. FOrmer case was https://www.experts-exchange.com/questions/28914245/Help-with-Excel-VBA.html,
I have attached SCOUT.XLSM and the Tool file. The MODULE in TOOL is called Mod_Review, and I have made comments there.
The overall goal of the tool is to take numerous excel form values and and create a history in the DEALDESKHISTORY file.
Please provide the corrected module(s) and I can copy / paste and test.
Thanks a Million!
Tool_01252016.xlsb
Scout.xlsm
You didn't pass the name of the workbook into the PopulateData() routine as I showed you in my comment.
ASKER
aikimark - If you would, please specify exactly what workbook needs to be placed in what location in what module? I tried in a few different locations, but not able to guess the right location.
Would you be able to update the vba in the XL files attached, and paste the modified Code here? it seems like you know exactly where I made the error. Thanks!
Would you be able to update the vba in the XL files attached, and paste the modified Code here? it seems like you know exactly where I made the error. Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This was solved outside of Experts-Exchange.