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

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

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

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" wrote in message
...
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

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

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


"Chip Pearson" schrieb im Newsbeitrag
...
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" wrote in message
...
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