VBA between programmes

[Guest]

I am using excel to run the majority of things with VBA but our server also
has VBA which i use to pull daily reports from in the morning then open in
excel.

Is there a way to get this to interact with Excels VBA so i only need to run
one macro to pull the reports off, then activate the macro to inport the
files rather than running the two, and could this be done from Excel?

 

[Bob Phillips]

Why don't you just add code to your Personal.xls that pulls the reports in
when you start Excel up, or maybe create an add-in that does it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Paul Lautman]

I am using excel to run the majority of things with VBA but our
server also has VBA which i use to pull daily reports from in the
morning then open in excel.

Is there a way to get this to interact with Excels VBA so i only need
to run one macro to pull the reports off, then activate the macro to
inport the files rather than running the two, and could this be done
from Excel?

Take a look at:
http://www.experts-exchange.com/Pro...ges/Visual_Basic/VB_Databases/Q_21761150.html

or

http://tinyurl.com/qq33g

if that link is broken