Excel to Word Macro

[janeml]

Hi,
I have a file in Excel, and I'm trying to create a macro that will open up Word and export everything to a Word document and save the word doc into a specific directory on my computer.

Can anyone help w/ this?

Thanks,
Jane

[patel45]

Please Login or Register  to view this content.

[janeml]

thanks! It works but I get an error that says "Run-Time error '438': object doesn't support this property or method."

[patel45]

I'm sorry, there are 2 wrong lines

Please Login or Register  to view this content.

[janeml]

works beautifully! Thank you!