[Resolved] favor needed - XL App wont become visible
I have an app that isnt working on a client's box (he is using W98 and Excel 98). One part of the app opens an existing XL spreadsheet. It works fine on my XP system, but the spreadsheet never becomes visible on his W98/XL98 box.
Can someone please test the following on a W/98/XP98 machine and tell me if the spreadsheet opens and becomes visible (I have no idea why it wouldnt). All you need is a ref to excel09.olb and an existing dummy spreadsheet to test.
Thanks in advance.
VB Code:
Private Sub Command1_Click()
Dim objXL As New Excel.Application
Dim objWB As Excel.Workbook
Set objWB = objXL.Workbooks.Open("c:\tst.xls")
objXL.Visible = True
Set objXL = Nothing
Set objWB = Nothing
End Sub