Results 1 to 15 of 15

Thread: [Resolved] favor needed - XL App wont become visible

Threaded View

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Feb 2001
    Location
    Crossroads
    Posts
    3,046

    [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:
    1. Private Sub Command1_Click()
    2.     Dim objXL As New Excel.Application
    3.     Dim objWB As Excel.Workbook
    4.     Set objWB = objXL.Workbooks.Open("c:\tst.xls")
    5.     objXL.Visible = True
    6.     Set objXL = Nothing
    7.     Set objWB = Nothing
    8. End Sub
    Last edited by Muddy; May 13th, 2003 at 12:23 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width