Save worksheets to files automatically
I posted this question two days ago and had a response except the hyper-link
led to a dead end! I have 200 invoices all on seperate worksheets. I want to save them as and when to specific file which cioincidentally have the same 'title' (number) as the the invoice. Is there a common command I can integrate on to the worksheet which will assist me instead of always using 'save as' and looking for one of the two thousand files I currwently have? Thanks in advance -- Bev |
Save worksheets to files automatically
Hi Bev
Maybe this will help http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bev" <Bev trucking wrote in message ... I posted this question two days ago and had a response except the hyper-link led to a dead end! I have 200 invoices all on seperate worksheets. I want to save them as and when to specific file which cioincidentally have the same 'title' (number) as the the invoice. Is there a common command I can integrate on to the worksheet which will assist me instead of always using 'save as' and looking for one of the two thousand files I currwently have? Thanks in advance -- Bev |
All times are GMT +1. The time now is 03:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com