start excel (excel2003) via OLE-connection - no personal.xls???

[M.Erlinger]

hello

i have the problem, when i start the excel-application via OLE-Connection
(from PowerBuilder)
-------------------------
ll_Rc = inv_EXCEL.ConnectToObject('',"Excel.application" )
if ll_Rc < 0 then
ll_Rc = inv_EXCEL.ConnectToNewObject( 'Excel.Application' )
end if
------------------------

the personal.xls is not loaded and i have no access to my macros......?? if
start excel normal in windows - my personal.xls is loaded and all my macros
are available.

have anyone a clue for my problem
many thank's in advance
Michael

 

[Chip Pearson]

When Excel is opened via automation, it doesn't perform its
standard startup procedures, such as loading workbooks in the
XLStart folder. This is by design, in order to make Excel start
faster. You have to open the workbooks yourself. E.g.,

inv_EXCEL.Workbooks.Open(inv_EXCEL.Path &
"\XLStart\Personal.xls")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[M.Erlinger]

o.k. --> thank's for your clue!!!!
Michael

When Excel is opened via automation, it doesn't perform its standard
startup procedures, such as loading workbooks in the XLStart folder. This
is by design, in order to make Excel start faster. You have to open the
workbooks yourself. E.g.,

inv_EXCEL.Workbooks.Open(inv_EXCEL.Path & "\XLStart\Personal.xls")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com