VBA between programmes

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" <PaulW@discussions.microsoft.com> wrote in message
news:9E87DBB2-120D-4EDA-AB18-57058D5B02EA@microsoft.com...
> 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