How to make 2007 talk to 2003

[jitblass]

I have a very unique situation here...

I have a utility at work that generates a spreadsheet. It is an excel 2003 spreadsheet, which is "Book1" and unsaved. The user needs to run my code to grab some data from this spreadsheet and not have to save the excel 2003 workbook to their machine.

I have an excel 2007 workbook which runs VBA code to grab the data it needs from the generated workbook. The issue is, if the generated workbook is not saved and opened in 2007, I can't move to that as the active workbook. If I target Workbook("Book1").Activate or Window("Book1"). Activate it does not see that the 2003 version "Book1" exists.

Is there a way to tell excel "I'm about to go look into a 2003 version workbook"? Having the user save the workbook and reopen in 2007 is not an option, so I'm really limited to finding a way to pull data from a 2003 version of excel from vba code written in the 2007 version workbook. Both files are open when I need this code to run.

Is there some way I could use the GetExcelVersion and then use this information to have the ability to see that excel 2003 workbook? It's as if my VBA code written in 2007 doesn't see any workbooks open that are not 2007 versions. It only realizes the 2007 versions as open workbooks

Thoughts? Really stuck in a dead end here and need a solution. There has to be a way.

Thanks in advance

 

[jitblass]

New information: I think the problem is different than what I suspected.

It appears the issue is not 2003 vs excel, but more that the 2003 version is running off of a company server, and not on my machine. I made the mistake of assuming 03 won't communicate with 07, but in actuallity, I can' communicate with instances of excel running off of a server.

Any work arounds?

 

[Andrew Poulsom]

You mean it's running on the server console? I doubt that there's any way of accessing that.