antonio.manoj.derose
Registered User.
- Local time
- Today, 22:31
- Joined
- Jul 4, 2013
- Messages
- 62
Hi Folks,
Good evening, I am able to get the output as onefile, after being fetching all the necessary data from the access table to the excel sheet I wanted.
Bottomline : My requirement had been working fine.
But, suddenly I have been asked to save the outcome as 2 files depending on the worksheets.
This would always have 4 worksheets, I have been asked to save 3 of the worksheets into 1 file, and the remaining last 1 worksheet as another excel file.
Am using the following to save it as one file
xlbook.SaveAs sFile
Any help much appreciated.
Antonio
Good evening, I am able to get the output as onefile, after being fetching all the necessary data from the access table to the excel sheet I wanted.
Bottomline : My requirement had been working fine.
But, suddenly I have been asked to save the outcome as 2 files depending on the worksheets.
This would always have 4 worksheets, I have been asked to save 3 of the worksheets into 1 file, and the remaining last 1 worksheet as another excel file.
Am using the following to save it as one file
xlbook.SaveAs sFile
Any help much appreciated.
Antonio