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 |
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 |
All times are GMT +1. The time now is 04:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com