PDA

View Full Version : Open each excel file and then close it.



uktous
02-07-2012, 07:25 AM
Hi,

Could you please write me the following macro?
Want to learn the code.


Open each Excel file in a folder and then close it.

For example, there are 2 Excel files in a folder.
Step1: Open excel file 1.
Step2: Close excel file 1.
Step3: Open excel file 2.
Step4: Close excel file 2.

Thanks

Bob Phillips
02-07-2012, 07:39 AM
VBA help - open, close