Home > Archive > Visual Basic > August 2005 > Creating instance of Excel object (xlapp) - visible property
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Creating instance of Excel object (xlapp) - visible property
|
|
|
| I am creating an object of excel to create the data to populate an MSchart
graph. After creating the instance I set the object.visible property to
false, but on some machines that the application is distributed to are still
seeing Excel open and load the spreadsheet. Is there any reason why this
would happen on some machines and not others?
--
KSH
| |
|
|
"KSH" <KSH@discussions.microsoft.com> wrote in message
news:CC8CF918-DAB9-432F-9D60-A5FDD8CC334E@microsoft.com...
>I am creating an object of excel to create the data to populate an MSchart
> graph. After creating the instance I set the object.visible property to
> false, but on some machines that the application is distributed to are
> still
> seeing Excel open and load the spreadsheet. Is there any reason why this
> would happen on some machines and not others?
It could depend on the version of Excel that's installed. For example, with
Excel 2000 and later (and maybe earlier versions too), when you create a new
instance of the Excel.Application object, it's Visible property is False by
default. Do you know what version of Excel is installed on all these other
PCs? It would also help if you posted your code (copy and paste it) so we
could see exactly what you're doing.
--
Mike
Microsoft MVP Visual Basic
|
|
|
|
|