topic-40071

Board index FiveWin for Harbour/xHarbour Open Excel file with TOleAuto() - parameters

hidroxid

Posts: 30

Joined: Sun Apr 24, 2011 12:50 AM

Open Excel file with TOleAuto() - parameters

Posted: 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

Enrico Maria Giordano

Posts: 9022

Joined: Thu Oct 06, 2005 08:17 PM

Re: Open Excel file with TOleAuto() - parameters

Posted: Sun Mar 07, 2021 10:50 AM

Try

Code (fw): Select all Collapse

oExcel:WorkBooks:Open( cFileName, .F., .T. )

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

FiveTech Support Forums

Open Excel file with TOleAuto() - parameters

Re: Open Excel file with TOleAuto() - parameters

Continue the discussion