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

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

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

On Jun 28, 8:46 am, Dave wrote:
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

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

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

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

" wrote:

On Jun 28, 8:46 am, Dave wrote:
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

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

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

On Jun 28, 9:46 am, Dave wrote:
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



" wrote:
On Jun 28, 8:46 am, Dave wrote:
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

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- Hide quoted text -

- Show quoted text -

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