HELP - Retrieving cells from another workbook

N

Neil Holden

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.
 
J

Joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying cells and formula from closed workbook to all sheets in open workbook 0
Help with copying a sheet from One workbook to another workbook 1
Merge Multiple workbook sheets into one workbook 0
Script to refresh data and save and close 3
Excel, assign cells in multiple worksheets from one sheet 1
Auto copy cell data from source sheet to another wrkbook sheet 2
Gathering data from all xl files in a folder 5
copying sheet1 from different workbooks contained in a folder to myone and only destination workbook 3

Top