Macro that will run from Excel but act on Excel, Word & Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone!

I am looking to create a macro that will automate a process involving Excel,
Word and Access and would appreciate it if someone could help me to do this.

The process I am trying to automate is basically:

Open Word Document
Copy Word Document into Excel Workbook
Edit Excel Workbook (Remove Certain Columns etc.)
Copy Data from Excel
Paste into Access

If anyone knows how to do this kind of thing please speak up.

Thanks!!
Dave
 
Hi Everyone!

I am looking to create a macro that will automate a process involving Excel,
Word and Access and would appreciate it if someone could help me to do this.

The process I am trying to automate is basically:

Open Word Document
Copy Word Document into Excel Workbook
Edit Excel Workbook (Remove Certain Columns etc.)
Copy Data from Excel
Paste into Access

If anyone knows how to do this kind of thing please speak up.

Thanks!!
Dave
Click to expand...

You might want to look at adding references to the other programs
(from Excel macro editor, tools -> references and then find Microsoft
Access and Microsoft Word object libraries) Then you can create an
instance of the other application from your macro and you should be
able to do the things that you want to do.

There are probably better ways (using queries) to put the data into
Access than just pasting from the clipboard.

Peter
 
Hi Peter,

First of all thanks for the reply.

With regards to the Access section -

When the Data is pasted into Access it is pasted into a tool that is built
in Access. No queries are required.

If you would not mind I would like to speak to someone about this, possibly
through MSN.

If so I can be contacted at davehoonter @ hotmail.com

Thanks!
Dave
 
Hi Peter,

First of all thanks for the reply.

With regards to the Access section -

When the Data is pasted into Access it is pasted into a tool that is built
in Access. No queries are required.

If you would not mind I would like to speak to someone about this, possibly
through MSN.

If so I can be contacted at davehoonter @ hotmail.com

Thanks!
Dave








- Show quoted text -
Click to expand...

I don't have IM installed at work. I will see if I can get on tonight.
 
Back
Top