I’m trying to do the following:
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Set xlApp = CreateObject("Excel.Application")

Set xlBook = xlApp.Workbooks.Open("WorkBookName")

Set xlSheet = xlBook.Worksheets("WorkSheetName")

xlSheet.Visible = xlSheetVisible

But, I cannot make the spreadsheet visible (to open and
see it).

Can anybody help me with it?

Thanks

Replace:
xlSheet.Visible = xlSheetVisible
With
xlApp.Visible=true

Dave
>-----Original Message-----
>I'm trying to do the following:
>Dim xlApp As Excel.Application
>Dim xlBook As Excel.Workbook
>Dim xlSheet As Excel.Worksheet
>
>Set xlApp = CreateObject("Excel.Application")
>
> Set xlBook = xlApp.Workbooks.Open("WorkBookName")
>
>Set xlSheet = xlBook.Worksheets("WorkSheetName")
>
>xlSheet.Visible = xlSheetVisible
>
>But, I cannot make the spreadsheet visible (to open and
>see it).
>
>Can anybody help me with it?
>
>Thanks
>
>.
>

Thanks a lot, Dave.
>-----Original Message-----
>Replace:
>xlSheet.Visible = xlSheetVisible
>With
>xlApp.Visible=true
>
>Dave
>>-----Original Message-----
>>I'm trying to do the following:
>>Dim xlApp As Excel.Application
>>Dim xlBook As Excel.Workbook
>>Dim xlSheet As Excel.Worksheet
>>
>>Set xlApp = CreateObject("Excel.Application")
>>
>> Set xlBook = xlApp.Workbooks.Open("WorkBookName")
>>
>>Set xlSheet = xlBook.Worksheets("WorkSheetName")
>>
>>xlSheet.Visible = xlSheetVisible
>>
>>But, I cannot make the spreadsheet visible (to open and
>>see it).
>>
>>Can anybody help me with it?
>>
>>Thanks
>>
>>.
>>
>.
>

You haven't made >Excel< visible!

Try: xlApp.visible = true

HTH,
TC


"AlexD" <(E-Mail Removed)> wrote in message
news:1d28701c42327$2a5affc0$(E-Mail Removed)...
> I’m trying to do the following:
> Dim xlApp As Excel.Application
> Dim xlBook As Excel.Workbook
> Dim xlSheet As Excel.Worksheet
>
> Set xlApp = CreateObject("Excel.Application")
>
> Set xlBook = xlApp.Workbooks.Open("WorkBookName")
>
> Set xlSheet = xlBook.Worksheets("WorkSheetName")
>
> xlSheet.Visible = xlSheetVisible
>
> But, I cannot make the spreadsheet visible (to open and
> see it).
>
> Can anybody help me with it?
>
> Thanks
>