Programming Outside of Excel Not Recognizing Excel.Visible

[ShannonLarson]

Working with a VBScript that uses the GetObject method to open a specific workbook:

Please Login or Register  to view this content.

I am not able to set objExcel.Visible = True I receive an unable to select range error when I try to select the range I want in the sheet. The other folks that use this same sheet in a shared network folder, shared workbook get confused with the VBScript error when they forget to open the file first and run the script. Building an event that detects if the file is open and CreateObject if it isn't would be a better solution, but I have not been able to get my script to do that successfully yet.

Is there something that I can add to the GetObject method to force it to become visible as the file opens if it wasn't already?

[Leith Ross]

Hello ShannonLarson,

In your code GetObject may is not returning an object instance of Excel, but an instance of the workbook. The workbook has no visible property. That's why setting objExcel.Visible fails.

Are you trying to open the workbook minimized on the task bar?

Sincerely,
Leith Ross

[ShannonLarson]

What I need it to do is come into maximized view when the script opens the workbook and fully visible.

In the case of the workbook, there is a userform that executes upon opening that displays a listbox of user names to be selected and apply to the sheet. Could that be what's preventing the workbook's visibility from occurring? Can that be executed independently of the workbook so as not to interfere with my external script?

[Leith Ross]

Hello ShannonLarson,

To open the workbook, simply use this code...

Please Login or Register  to view this content.

Sincerely,
Leith Ross