HELP - Retrieving cells from another workbook
Is they any way to copy an entire worksheet automatically overnight to a
different excel sheet? The reason being is i am trying to produce crystal reports from this particular sheet but the reports wont run because the user has the excel sheet open daily. |
HELP - Retrieving cells from another workbook
In Control Panel (Start - control Panel - Sechedule Task) there is a
scheduled event that you can setup. Put in a workbook open event the sheet to copy. Then schedule the event to run the workbook. "Neil Holden" wrote: Is they any way to copy an entire worksheet automatically overnight to a different excel sheet? The reason being is i am trying to produce crystal reports from this particular sheet but the reports wont run because the user has the excel sheet open daily. |
All times are GMT +1. The time now is 04:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com