Send Excel Information to Word

[clapforthewolfman]

Hi all looking for some help with my code. This works but the parameters are too constricting for my needs. I would like this code to send the selection to a Word file. It would be better if it created a new Word file and inserted the bookmark "InsertHere" but that might be better explored in another thread. Bookmarks seem to be the best way to go for moving content between the programs. I have tried using dotm files so that the user has to save as. The idea is that you would use this function for report generating. Right now I am having a problem dealing with errors. If I don't select a Word file there is a bug in the code. I need help closing this code against that error.

I would also be interested to know if you can format tables sent from excel to word with excel vba.

Thanks!

Wolfman

Please Login or Register  to view this content.

[clapforthewolfman]

Also when I press the 'X' button or cancel in the open folder dialogue I get an error.

[AlphaFrog]

Also when I press the 'X' button or cancel in the open folder dialogue I get an error.

Please Login or Register  to view this content.

[clapforthewolfman]

This works for that line but now I am getting an error here:

Please Login or Register  to view this content.