Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoking a workbook from a Fortran Program!
Hello all!
A quick question. I have a workbook (Vtec.xls) that has macro buttons and custom create menus and stuff performing different tasks. I would like to invoke/call 'vtec.xls' from a Fortran code. Is there any way we could do this? Any alternatives? I would really appreciate any help in this matter. Thanks a bunch. regds, Arun. Vt Corp -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invoking a workbook from a Fortran Program!
Hello,
for me (i m not specialist) it is possible to read in your sheet xl, but not write... I have a problem with Reflection to readin xl and this is the superbe reponse from Bill Manville: I don't know anything about Reflection, but I would try using automation. Create a Reference from your Reflection's VBproject to Microsoft Excel N Object Library. Dim oXL As Excel.Application Dim V Dim I As Integer Set oXL = New Excel.Application oXL.Workbooks.Open "C:\Mybook.xls" For I=1 To 50 V = oXL.Sheets("Sheet1").Cells(I, 1).Value ' do what you will with that value V in Reflection Next oXL.ActiveWorkbook.Close False oXL.Quit Set oXL = Nothing If you can deal with the data being in an array you could replace the For loop with V = oXL.Sheets("Sheet1").Range("A1:A50").Value Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup "aiyer " a écrit dans le message de ... Hello all! A quick question. I have a workbook (Vtec.xls) that has macro buttons and custom created menus and stuff performing different tasks. I would like to invoke/call 'vtec.xls' from a Fortran code. Is there any way we could do this? Any alternatives? I would really appreciate any help in this matter. Thanks a bunch. regds, Arun. Vt Corp. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Program shutsdown when I close workbook | Excel Discussion (Misc queries) | |||
Why open more than one Excel program to see more than one workbook | Excel Discussion (Misc queries) | |||
is there a maximum size of parameter for a (Fortran)DLL call from VBA | Excel Programming | |||
Calling a Fortran dll from Excel | Excel Programming | |||
Link to fortran | Excel Programming |