Opening a workbook from Fortran!

[aiyer]

Hello all!

A quick question.
I have a workbook (Vtec.xls) that has many command buttons in it tha
are assigned to specific macros, performing specific tasks. How can
invoke/call vtec.xls from a Fortran code? Is there anyway, we coul
create a *.exe file of the 'vtec.xls' workbook using VB? I understan
that the VBA does'nt provide this feature, but we could create th
*.exe file for the workbook using VB right?
I am not sure how to implement this task.(calling/opening a specifi
workbook from Fortran).
I would really appreciate any help in this matter.
Thanks a bunch.
regds,
Arun.

Vt Cor

 

[Guest]

Arun

I am not at all sure here because its been a very long time since I used Fortran, I don't even think Excel was about then
But most Excel files open in Windows and indeed DOS without much cohersion, for example you can open a workbook from the command line in Window (windows+R, command) simply by making sure your in the right directory and typing in the file name with return. In your case Vtec.xls
I seem to recall (now this is where I may be mistaking Fortran for Pascal) that you use to be able to use a DOS SHELL command to invoke DOS, now assuming your file associations are set up normally in Windows, you should be able to open the excel file from the Dos shell. I simply can not rememeber how you get to the shell (was it Run \Command.com)?

Nem

----- aiyer > wrote: ----

Hello all

A quick question
I have a workbook (Vtec.xls) that has many command buttons in it tha
are assigned to specific macros, performing specific tasks. How can
invoke/call vtec.xls from a Fortran code? Is there anyway, we coul
create a *.exe file of the 'vtec.xls' workbook using VB? I understan
that the VBA does'nt provide this feature, but we could create th
*.exe file for the workbook using VB right
I am not sure how to implement this task.(calling/opening a specifi
workbook from Fortran)
I would really appreciate any help in this matter
Thanks a bunch
regds
Arun

Vt Cor