Board index » delphi » Late binding Excel displaying Formula Bar

2004-01-08 07:35:19 PM
delphi55
I am using Excel to display a dynamically created spreadsheet
within a browser window.
I create, format and save the spreadsheet using early binding
and ensure that the formula bar is not displayed as follows:
intlcid:= GetUserDefaultLCID;
vExcel:= TExcelApplication.Create(nil);
vExcel.DisplayFormulaBar[intlcid]:= False;
When required, the spreadsheet is displayed in a browser window
within my application using late binding.
I need to ensure that when my application closes, Excel will
default to showing the formula bar next time it is opened.
Can someone please give me the equivalent code to below, when
using late binding, as the following does not work:
intlcid:= GetUserDefaultLCID
XLApp := CreateOLEObject('Excel.Application');
XLApp.DisplayFormulaBar[intlcid]:= True;
Thanks in advance
 

<<Jay Sylvester:
Can someone please give me the equivalent code to below,
when using late binding
XLApp.DisplayFormulaBar := True;
Locale identifiers are strictly for early binding - you
just omit them in late binding.
--
Deborah Pate (TeamB) delphi-jedi.org
TeamB don't see posts sent via Google or ISPs
Use the real Borland server: newsgroups.borland.com
www.borland.com/newsgroups/genl_faqs.html