Open Excel file with TOleAuto() - parameters

Open Excel file with TOleAuto() - parameters

Postby hidroxid » Sat Mar 06, 2021 10:18 pm

Hi All,

How to send parameters to Open() method of Excel:Workbooks?

The sintaxis for the command is:

:Open (FileName, UpdateLinks, ReadOnly, Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMru, Local, CorruptLoad)

I need send UpdateLinks with .F. and ReadOnly with .T.

Thanks in advance
hidroxid
 
Posts: 30
Joined: Sun Apr 24, 2011 12:50 am

Re: Open Excel file with TOleAuto() - parameters

Postby Enrico Maria Giordano » Sun Mar 07, 2021 10:50 am

Try

Code: Select all  Expand view
oExcel:WorkBooks:Open( cFileName, .F., .T. )


EMG
User avatar
Enrico Maria Giordano
 
Posts: 8710
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot], Jimmy and 59 guests