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
|