I am running Erel's sample program from
Here
The program creates the excel file but fails to print a PDF file, if I go into the file I can print it
I have Bullzip printer installed and PDF Viewer Plus. I saw another post that mentioned Java and Office not getting along unless they are both 32 or 64 bit. I have checked and both are 64 bit
The error message in B4J logs is as follows
Waiting for debugger to connect...
Program started.
Call B4XPages.GetManager.LogEvents = True to enable logging B4XPages events.
Unable to index into an object of type System.__ComObject.
At line:1 char:149
+ ; & {$objExcel = New-Object -ComObject excel.application;$workbook = $objE
xcel.workbooks.open('C:\Users\xxxxxxx\Desktop\test.xlsx', 3);$workbook.Sheets[ <<<<
1].ExportAsFixedFormat($xlFixedFormat::xlTypePDF, 'C:\Users\xxxxxx\Desktop\test.p
df');$objExcel.Workbooks.close();$objExcel.Quit()}
+ CategoryInfo : InvalidOperation: (1:Int32) [], RuntimeException
+ FullyQualifiedErrorId : CannotIndex
I haven't seen any other posts with this thread so it may be my system config. Can anyone advise of a possible solution
Cheers