I am attempting to write a VB app which opens Excel spread sheets.
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
does sort of work. The issue is that we have both version 5 and 97 on our PCs. Version 5 is required by PeopleSoft (only) and everything else uses 97.
The issue is that the code opens up version 5.0. All of the playing around that I've tried (such as trying to hard code paths) gives syntax errors.
How do I make it start up 97 not 5.0?