I am looking to add a validation by comparing the total of key columns imported with the below macro. I have the formula created, however as you can image the link (ie filename) is required. to reference the file name and path of the imported file?
Is there a way to add line in the marco to reference the file set by the VBA code "Set wb = Workbooks.Open(sWb)"?
I think it would be something like:
Here is the Macro VBA Code:Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks