Create a seperate read only instance of a workbook already opened

[bradyboyy88]

I am at a standstill and hoping to get some help. I am trying to create a subroutine that opens up a separate instance of a workbook that is already open. I can create the excel object to start the second instance but I am not sure the best way create the clone instance of the workbook that is open. Basically the file is located on a extremely slow network drive so using workbook open with the file path is far to slow in my mind. Is there a way to create a clone without having to fetch the original file but instead just pull from the file that is open in memory?

Thanks

 

[NdNoviceHlp]

Maybe something like this...

Dim Ofsobj as Object
Set Ofsobj = CreateObject("Scripting.FilesystemObject")
Ofsobj.CopyFile ThisWorkbook.FullName, _
     ThisWorkbook.Path & "\" & "CLONE" & ThisWorkbook.Name, True
Set Ofsobj = Nothing

This copies the open wb that you're currently using to a new "CLONE" wb in the same directory... which is not what U want but U can use the copyfile method to copy the open wb that your after into a new wb at whatever directory U specify. So, just adjust the code to specify the file paths U want and it seems like it should work. HTH. Dave

 

[bradyboyy88]

I do not want to save the second instance just open in memory for using it independently of the first instance. Wouldnt copyfile() be saving to the slow network drive hence almost similar performance issues as just reopening the second instance from the network. Thank you for the solution but I do not think it would solve the problem

 

[bradyboyy88]

Any other solutions that might solve the problem?