E S 14.Oct.05 02:36 PM a Web browser Domino Designer 6.0.2 Windows 2000
In my notes document, I want to open an Excel application from the harddrive. But I want to put the text contents of a field into a cell in Excel, then call an Excel macros to perform some operations and refresh before saving the Excel file.
Is there a way to call/perform an Excel macros from Lotusscript?
This is the code I have right now:
Dim xlApp As Variant
Dim xlWorkbook As Variant
Dim xlSheet As Variant
Set xlApp = CreateObject( "Excel.Application" )
xlApp.Workbooks.Open strExcelPath 'excel file saved on harddrive
xlApp.Visible = False
'insert rawdata into Excel
Dim strRawData As String
strRawData = "testing this"
xlApp.Workbooks(1).Worksheets(1).Cells(1, A).Value = strRawData