View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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