INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I don't think testimonials would have enticed me to become a member, or even use the site for that matter. I use the site for a learning experience..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft: FoxPro (old versions 1 to 2.6) Forum

running excel 2003 from FPW26

Read More Threads Like This One

frenchpeter (IS/IT--Management)

19 Jun 12 10:28

I am trying to run Excel 2003 from within an FPW26 program using 'run /N {batch file that runs Excel}'. It does actually work but, each time that Excel opens, Windows install runs (very slowly) to install Excel Components - it appears to install two Excel features. It does not say what they are. After installer has finished the spreadsheet does everything expected of it.

Does anyone have any thoughts as to what these features might be and whether it is possible to permanently install the features so that they do not have to install each time?

frenchpeter (IS/IT--Management)

19 Jun 12 10:49

Sorry, I should have added that, if I immediately cancel the Windows Installer before it does anything, the spreadsheet still works! However, it is not really a solution because it takes a while after hitting the cancel button to for the cancellation to take effect.

OlafDoschke (Programmer)

20 Jun 12 2:26

Do you have the same behaviour, if double clicking on the same excel file? Because Foxpro's Run does not trigger much different than ShellExecute of a file. Run rather is for EXEs, but the problem you see would rather be related to Office itself missing something it wants to (re)install for that (old?) file type, perhaps.

If you once go through this, you may be through with it.

Bye, Olaf.

frenchpeter (IS/IT--Management)

20 Jun 12 3:20

Thanks for the response. The spreadsheet works without the installer intervention if I run the file normally or via a batch file. The installer only comes up when I run it out of FPW26. My initial thought was, exactly as yours, that, once the components were installed, subsequent use of the spreadsheet would not involve any further installation but this is not the case. It happens every time I run the spreadsheet out of Foxpro.

DSummZZZ (Programmer)

20 Jun 12 12:14

Since Foxpro's "!" command creates a new instance of command or cmd.exe, you may need to check file paths and such to verify all the Office components can be "seen" from a DOS window.
Also, check your file associations for .XLS or whatever your spreadsheet types are. You may need to include some other command line parameters in your RUN command.

-Dave Summers-
cheers
Even more Fox stuff at:
http://www.davesummers.net/foxprolinks.htm