macros

[Guest]

My objective is to use a command button in ms-access 2000 to run a macro in
Exel 2000 then import the worksheet into ms-access. I have this working fine
but it takes 2 operations. ie. open exel run macro to transpose data to suite
ms-access, then open ms-access and import using a command button
(transferspreadsheet)
I would appreciate your input
Thanks in Advance

 

[Guest]

Eric
Thanks again for your reply unfortunatley had a major system crash and have
just got back on line.

I have tried using RunApp but keep getting error "Microsoft Access can't
invoke the application using RunApp action" MS Access help states "You can't
run the RunApp action in Visual Basic. Use the Visual Basic Shell function
instead".

I have been trying this method since getting back on line but cannot get it
to work. I have had some success using Hyperlink but I don't think it's the
way to go.

Thanks again
Davo78