asked on

Open copy of excel workbook

Dear experts,

I am trying to open a new instance of an excel workbook i.e. i want to open a copy of an excel file change some data in that file, copy it, paste it in my workbook and then delete the copy of the file. Is this possible? i already made the part where i copy from a workbook and paste it in mine. But because i change some things that i don't want to save, i want to use a copy of the workbook.

thanks in advance:)

Rory Archibald

You would need to use a template file, or open another instance of excel, open the file read-only, make changes and copy to the current instance.

MarkVrenken

ASKER

i won't be using a template file. Is this solution also possible if the workbook where i will copy from is already opened? i.e you can't open the file twice right?

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MarkVrenken

ASKER

Thanks, It works fine:)

MarkVrenken

ASKER

Hope i can ask a quick question again. How do i reference the copied workbook. I don't copy the active workbook but a other one and it doesn't fully work yet:(

thanks in advance!

Rory Archibald

change

Filename:=activeworkbook.fullname

Open in new window

Filename:=workbooks("someworkbook.xls").fullname

Open in new window

MarkVrenken

ASKER

What does this code actualy do because i need to do some operations and don't really understand if i open a copy of my file or just open the file...?

thanks