Problem in opening template through intranet.

A

Ajit

I have a template with forms...data in the forms is fed from the excel sheet....in workbook open event i have the "form.show". I put this template on the intranet and almost 100 people tested it opening through browser...it worked fine for 90% but just handful of systems have the problem. All have windows XP.

Problem : when user opens the template from the browser...instead of showing the formit shows the excel sheet...but the form is open. To get to the form you have to alt+tab......

does someone have any idea/hint what could it be...and what to try to find out the bug....

Suggestions will be appreciated.

Thanks,
 
G

Gjones

Hi Ajit;

Try setting the focus for the form programatically instead
or relying on thier OS to implicitly do it.

Thanks,

Greg

-----Original Message-----
I have a template with forms...data in the forms is fed
Click to expand...
from the excel sheet....in workbook open event i have
the "form.show". I put this template on the intranet and
almost 100 people tested it opening through browser...it
worked fine for 90% but just handful of systems have the
problem. All have windows XP.
Problem : when user opens the template from the
Click to expand...
browser...instead of showing the formit shows the excel
sheet...but the form is open. To get to the form you have
to alt+tab......
does someone have any idea/hint what could it be...and
Click to expand...
what to try to find out the bug....
 
A

Ajit

Greg, Thanks for your reply...but unfortunately that didn't work...and i digged some deep and it looks that none of the excel functionality is working...for example i tried doing [msgbox range("A1").value] on worksheet open...and it gave me error "Runtime error 1004" Method "Range of object" failed......I have no idea why it happens and i also tried the same thing in somany other systems and it is perfect......
--
Ajit


Gjones said:
Hi Ajit;

Try setting the focus for the form programatically instead
or relying on thier OS to implicitly do it.

Thanks,

Greg

-----Original Message-----
I have a template with forms...data in the forms is fed
Click to expand...
from the excel sheet....in workbook open event i have
the "form.show". I put this template on the intranet and
almost 100 people tested it opening through browser...it
worked fine for 90% but just handful of systems have the
problem. All have windows XP.
Problem : when user opens the template from the
Click to expand...
browser...instead of showing the formit shows the excel
sheet...but the form is open. To get to the form you have
to alt+tab......
does someone have any idea/hint what could it be...and
Click to expand...
what to try to find out the bug....
Click to expand...
 
Top