Thread: Saving problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Saving problem

Hi Alvin,

Try using SaveCopyAs.

From Help:
Saves a copy of the workbook to a file but doesn't modify the open workbook
in memory.



---
Regards,
Norman



"Alvin Hansen" wrote in message
...
Hi!!

I use this code:
ActiveWorkbook.SaveAs ("h:\city breaks\priser\usa\ordrer\" & filnavn)
It's working allright - but my ActiveWorkbook is now the new file.
Can't i in some way save the file in a new file and still be in the
original
file

Like if my file name is first.xls and i save it at second.xls then i still
want to
be in first.xls so i can make some more in this file.

Now i close the file and open my old file again.

Best regards alvin