addIn functions in automation
 

Hi everyone,

I have an addIn for excel which get data from a server and put it in
excel sheet for a report.

Each day, a person must :
- open excel and the report file
- press F9 to refresh the data
- print the file

I want to automate this.

I did some work with automation and 'EXCEL9.OLB'.
I'm able to open excel, open the template report and refresh cell tha
contains standard excel function [such as rand() or now()]

But it seams that all the functions that are part of my addIn are no
loaded. In fact I think my addIn is not loaded because I don't hav
the menuItem related to it.

Any Idea to solve my problem?

thanks

Ni

--
nicgendro
-----------------------------------------------------------------------
nicgendron's Profile: http://www.excelforum.com/member.php...fo&userid=2515
View this thread: http://www.excelforum.com/showthread.php?threadid=38690

addIn functions in automation
 

Hi,
how about this kb:

Add-Ins Don't Load When Using the CreateObject Command
http://support.microsoft.com/default...b;en-us;213489

How to install an Excel Add-in (XLA or XLL) with Automation
http://support.microsoft.com/default...b;en-us;280290

-- HTH
okaizawa

nicgendron wrote:
Hi everyone,

I have an addIn for excel which get data from a server and put it in a
excel sheet for a report.

Each day, a person must :
- open excel and the report file
- press F9 to refresh the data
- print the file

I want to automate this.

I did some work with automation and 'EXCEL9.OLB'.
I'm able to open excel, open the template report and refresh cell that
contains standard excel function [such as rand() or now()]

But it seams that all the functions that are part of my addIn are not
loaded. In fact I think my addIn is not loaded because I don't have
the menuItem related to it.

Any Idea to solve my problem?

thanks

Nic