Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
General Macro/Automation Question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
General Macro/Automation Question
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. "Dave" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
General Question | Excel Discussion (Misc queries) | |||
Automation 2-Part Question... | Excel Discussion (Misc queries) | |||
general macro question | Excel Discussion (Misc queries) | |||
General Question | Excel Worksheet Functions | |||
Macro - - Automation | Excel Discussion (Misc queries) |