Hello ,
I have a strange problem with GetExcelRange( cFile)
This works GetExcelRange( "C:\test\test.xlsx)
If cFile is in another PC in net doesn't work GetExcelRange( "\pc\test\test.xlsx)
Regards
Maurizio
oExcel := ExcelObj()
oBook := oExcel:WorkBooks:Open( "\\pc\test\test.xlsx" )
? oBook:FullNameThank Rao,
This does'n work
cFile := "\pc\test\test.xlsx"
oRange := GetExcelRange( cFile )
The Excel Message is : the file was not found. It may have been moved, renamed or deleted .
This works
cFile := "\pc\test\test.xlsx"
oExcel := ExcelObj()
oBook := oExcel:WorkBooks:Open( cFile )
? oBook:FullName
TRY
oSheet := oBook:ActiveSheet
oRange := oSheet:UsedRange
CATCH
END
Regards Maurizio
Thanks for the feedback.
That means we need to recheck our function.
We shall do that and I may request you help to check it, when I come back to you.