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




Reply With Quote