- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am trying to develop a program to load data into an EXCEL workbook using the EXCEL97A module as used in the AUTODICE example project. I have successfully run and modified the AUTODICE example and I think I understand what it is doing. I would like to achieve something more complicated, writing data and functions to a number of different sheets and producing a chart from each. I therefore need to use some of the other routines from EXCEL97A - is there any documentation for them anywhere? Specifically, at the moment, I am struggling to select a specific sheet from the workbook - any suggestions?
Joe
Joe
Link Copied
3 Replies
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I dont know about any documentation specific to EXCEL97A.
The workaround I have found is to go in to the XL-VBA help or the VBA Object model documentation, find the methods that are related to what I want to do and then search for similar names in EXCEL97A.
For instance, if you are looking to insert a range in a worksheet, the VBA command would be:
Worksheets("Sheet1").Range("A1:C5").Insert Shift:=xlShiftDown
In EXCEL97A, the corresponding function is:
FUNCTION Range_Insert($OBJECT, Shift, $STATUS)
Usually, the arguments of the Fortran function correspond to the arguments in the VBA method, so you can figure out what's going on.
In the above example, $OBJECT would be a handle to the range you want to insert and Shift is the XLShiftDown constant (-4121).
From what I have been able to figure out, EXCEL97A supports all (or nearly all) the methods related to the following Excel classes:
Application, Global, OleObject, Workbook, Workbooks, Worksheet, Worksheets, Range.
The workaround I have found is to go in to the XL-VBA help or the VBA Object model documentation, find the methods that are related to what I want to do and then search for similar names in EXCEL97A.
For instance, if you are looking to insert a range in a worksheet, the VBA command would be:
Worksheets("Sheet1").Range("A1:C5").Insert Shift:=xlShiftDown
In EXCEL97A, the corresponding function is:
FUNCTION Range_Insert($OBJECT, Shift, $STATUS)
Usually, the arguments of the Fortran function correspond to the arguments in the VBA method, so you can figure out what's going on.
In the above example, $OBJECT would be a handle to the range you want to insert and Shift is the XLShiftDown constant (-4121).
From what I have been able to figure out, EXCEL97A supports all (or nearly all) the methods related to the following Excel classes:
Application, Global, OleObject, Workbook, Workbooks, Worksheet, Worksheets, Range.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please let me also know if you sorted out your problem to select specific sheet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
> Please let me also know if you sorted out your
> problem to select specific sheet.
No. A start was made (by someone else) to write a main routine in VB but the project is on ice at the moment.
> problem to select specific sheet.
No. A start was made (by someone else) to write a main routine in VB but the project is on ice at the moment.
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page