General Macro/Automation Question

[Dave]

Hi Guys!

I have a general question regarding macros / automation.

Basically I'm looking to automate a process that my colleagues perform
regularly so as to save some time. Obviously if this was an 'excel-only'
process I could use a macro.

However the process involves MS Word, Access and Excel.

Basically the process is:

Open Word
Copy to Excel
Edit / Remove some Cells
Copy Correct Cells
Paste into Access


Can anyone advise me a way of writing a macro/program to automate this sort
of thing.

Thanks!!
Dave

 

[Barb Reinhardt]

You could probably still use a macro, but you'd have to integrate WORD,
EXCEL and ACCESS. You may want to ask in the PROGRAMMING group for more
information.