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?

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)

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

PaulW wrote:
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/Prog..._21761150.html

or

http://tinyurl.com/qq33g

if that link is broken