I have several Excel files that I call up individually, then trigger a series of sub routines, then save & close. Using "call" or "application.run" I haven't been successful in linking them to run one after the other when trying to call the procedure from File2.xls. From File1.xls I've entered the proper file names in column A for the series of *.xls files I'm tring to link together - and using a For/Next statement I am able to load the next desired file into Excel, but cannot run a desired sub routine that resides in a module within the 2nd file.
Example: Workbooks.Open ("E:" & Variable1) will open a file titled in cell A1 and assigned to Vairable1...then
Application.Run ("'E:' & PairName!Procedure2) will not run Procedure2 from the called-up file. I expect my syntax is incorrect. Can anyone help?
Thank you - Joel