Converting excel data in Word with formats

[rdaboy]

Hi everyone,

I am relatively new to VBA. I am trying to create a macro in excel such that starting from an excel file creates a word file. I get stuck because, after copying the data from excel to word, I cannot include in the macro the "convert to text" command.
Can you please help? How do I use Word macros within a Macro launched from Excel?
Thank you

Please Login or Register  to view this content.

[snb]

This suffices.
Adapt the file-fullname and the range you want to be put into the Worddocument

Please Login or Register  to view this content.

[rdaboy]

Hi

#
Thanks for this tip, However, I still struggle to make it work.
Using the code you have posted, I get the "object required" alert message.

I think that the issue is that I am trying to use Word macro syntax in an excel macro file.
Also, I need to select the tab from which I am coping the file from, that why in my code I have the commands "basebook.Activate and baseSheet.Select"

Why does the "recorded macro" from word does not work here?

Thanks
R.