Access to another excel instance?
 

Hi,

I am running an excel-vba which requires the user at a certain point to
manually export an excel file from a different software. The problem is
that this exported file opens up (automatically - which is how it is
supposed to be) in a new excel instance meaning it is not part of
workbooks and I can not access it with e.g. 'for each wb in
Workbooks'... Is there still some way to work with the exported file?

Thx

Robin

Access to another excel instance?
 

There is no easy access to other instances fo Excel. For one thing you could
have 3 or more instances of Excel going and then which instance were you
looking for? You are best off to save the export and then open it in the
original instance of Excel...
--
HTH...

Jim Thomlinson


"derobin" wrote:

Hi,

I am running an excel-vba which requires the user at a certain point to
manually export an excel file from a different software. The problem is
that this exported file opens up (automatically - which is how it is
supposed to be) in a new excel instance meaning it is not part of
workbooks and I can not access it with e.g. 'for each wb in
Workbooks'... Is there still some way to work with the exported file?

Thx

Robin

Access to another excel instance?
 

Hi Robin,

If you know the wb's path and name try somthing like this

sFullname = "c:\temp" & "\" & "test.xls"
On Error Resume Next
Set wb = GetObject(sFullname)
If Not wb Is Nothing Then
'etc

Regards,
Peter T

"derobin" wrote in message
oups.com...
Hi,

I am running an excel-vba which requires the user at a certain point to
manually export an excel file from a different software. The problem is
that this exported file opens up (automatically - which is how it is
supposed to be) in a new excel instance meaning it is not part of
workbooks and I can not access it with e.g. 'for each wb in
Workbooks'... Is there still some way to work with the exported file?

Thx

Robin