Saving problem
 

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

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

Saving problem
 

Off course sorry my brain is'n so fast

Many many thanks

From Alvin


"Norman Jones" skrev:

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