tommy1234
04-14-2007, 01:39 AM
Hi
i have a folder which contain 20 excel files, each file has the same format (different data).
i created another excel file which i use as a template and i open each on the files (one by one) in the folder and run a macro that changes cells according to what in written in the template file.
i want to know if there is an option to create a macro that will run for the entire folder - it will open each of the excel files and will update then according to the macro file automatically.
1.as i understand i need only the macro for opening the each file in the folder the macro for the update is already in my personal, it it correct ?
2. can the file be schedule by the windows scheduled tasks ?
thank a lot.
i have a folder which contain 20 excel files, each file has the same format (different data).
i created another excel file which i use as a template and i open each on the files (one by one) in the folder and run a macro that changes cells according to what in written in the template file.
i want to know if there is an option to create a macro that will run for the entire folder - it will open each of the excel files and will update then according to the macro file automatically.
1.as i understand i need only the macro for opening the each file in the folder the macro for the update is already in my personal, it it correct ?
2. can the file be schedule by the windows scheduled tasks ?
thank a lot.