Hello,
I have developed the stand alone application which interacts
with Excel spreadsheet.
It works fine on most Windows and computers, but from time to time I have
message from the user that my app cannot 'find' any opened spreadsheets, but
they are opened.
I wonder, what can cause that? What should I advise user to do?
Reinstalling Excel does not help.
I am using vbasic and Excel automation.
Your comments appreciated,
Jack

You might want to post the relevant portion of the code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 14 Oct 2008 16:00:13 -0400, "Jack" <replyto@it> wrote:

>Hello,
> I have developed the stand alone application which interacts
>with Excel spreadsheet.
>It works fine on most Windows and computers, but from time to time I have
>message from the user that my app cannot 'find' any opened spreadsheets, but
>they are opened.
>I wonder, what can cause that? What should I advise user to do?
>Reinstalling Excel does not help.
>I am using vbasic and Excel automation.
>Your comments appreciated,
>Jack
>

I do not believe it is my code related.
As I said it works 99% times.
I need to know what causes that 1% failure.
Please see below:
===============
Public WithEvents moExcelApp As Excel.Application


Set moExcelApp = GetObject(, "Excel.Application")
If moExcelApp Is Nothing Then 'when not sheet is opened
Set moExcelApp = CreateObject("Excel.Application")
If moExcelApp Is Nothing Then
Debug.Print "Excel app NOT found!"
ExcelApp = 1: Exit Sub
Else
moExcelApp.EnableEvents = True
End If
End If



"Chip Pearson" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
> You might want to post the relevant portion of the code.
>
> Cordially,
> Chip Pearson
> Microsoft Most Valuable Professional
> Excel Product Group
> Pearson Software Consulting, LLC
> www.cpearson.com
> (email on web site)
>
>
> On Tue, 14 Oct 2008 16:00:13 -0400, "Jack" <replyto@it> wrote:
>
>>Hello,
>> I have developed the stand alone application which interacts
>>with Excel spreadsheet.
>>It works fine on most Windows and computers, but from time to time I have
>>message from the user that my app cannot 'find' any opened spreadsheets,
>>but
>>they are opened.
>>I wonder, what can cause that? What should I advise user to do?
>>Reinstalling Excel does not help.
>>I am using vbasic and Excel automation.
>>Your comments appreciated,
>>Jack
>>

Cordially you are, but what about my question?
Anything more to add, Chip?
Jack

"Chip Pearson" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
> You might want to post the relevant portion of the code.
>
> Cordially,
> Chip Pearson
> Microsoft Most Valuable Professional
> Excel Product Group
> Pearson Software Consulting, LLC
> www.cpearson.com
> (email on web site)
>
>
> On Tue, 14 Oct 2008 16:00:13 -0400, "Jack" <replyto@it> wrote:
>
>>Hello,
>> I have developed the stand alone application which interacts
>>with Excel spreadsheet.
>>It works fine on most Windows and computers, but from time to time I have
>>message from the user that my app cannot 'find' any opened spreadsheets,
>>but
>>they are opened.
>>I wonder, what can cause that? What should I advise user to do?
>>Reinstalling Excel does not help.
>>I am using vbasic and Excel automation.
>>Your comments appreciated,
>>Jack
>>

Anyone else to pitch on that subject?
Anybody had that problem before?
I cannot believe it.
In the last 5 years, I encountered at least about 50 computers where Excel
automation did not work!
Jack

"Jack" <replyto@it> wrote in message
news:%(E-Mail Removed)...
> Hello,
> I have developed the stand alone application which interacts
> with Excel spreadsheet.
> It works fine on most Windows and computers, but from time to time I have
> message from the user that my app cannot 'find' any opened spreadsheets,
> but they are opened.
> I wonder, what can cause that? What should I advise user to do?
> Reinstalling Excel does not help.
> I am using vbasic and Excel automation.
> Your comments appreciated,
> Jack
>

Without code it's hard to speculate. Was it always consistent on each
"problem" computer ?
Antivirus SW ? Hidden open instance of Excel ?

Tim

"Jack" <replyto@it> wrote in message
news:(E-Mail Removed)...
> Anyone else to pitch on that subject?
> Anybody had that problem before?
> I cannot believe it.
> In the last 5 years, I encountered at least about 50 computers where Excel
> automation did not work!
> Jack
>
> "Jack" <replyto@it> wrote in message
> news:%(E-Mail Removed)...
>> Hello,
>> I have developed the stand alone application which interacts
>> with Excel spreadsheet.
>> It works fine on most Windows and computers, but from time to time I have
>> message from the user that my app cannot 'find' any opened spreadsheets,
>> but they are opened.
>> I wonder, what can cause that? What should I advise user to do?
>> Reinstalling Excel does not help.
>> I am using vbasic and Excel automation.
>> Your comments appreciated,
>> Jack
>>
>
>

On Oct 15, 8:16*pm, "Tim Williams" <timjwilliams at gmail dot com>
wrote:
> Without code it's hard to speculate. *Was it always consistent on each
> "problem" computer ?
> Antivirus SW ? *Hidden open instance of Excel ?
>
> Tim

To elaborate: if there are >1 instances of Excel open then getobject
returns a reference to a random instance. If your expected
spreadsheet isn't open in that instance then your code may fail.

Tim


>
> "Jack" <replyto@it> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > Anyone else to pitch on that subject?
> > Anybody had that problem before?
> > I cannot believe it.
> > In the last 5 years, I encountered at least about 50 computers where Excel
> > automation did not work!
> > Jack
>
> > "Jack" <replyto@it> wrote in message
> >news:%(E-Mail Removed)...
> >> Hello,
> >> * * * * * * I have developed the stand alone application which interacts
> >> with Excel spreadsheet.
> >> It works fine on most Windows and computers, but from time to time I have
> >> message from the user that my app cannot 'find' any opened spreadsheets,
> >> but they are opened.
> >> I wonder, what can cause that? What should I advise user to do?
> >> Reinstalling Excel does not help.
> >> I am using vbasic and Excel automation.
> >> Your comments appreciated,
> >> Jack- Hide quoted text -
>
> - Show quoted text -