Exporting multiple sheets to to Word based on User Input

Hi All,

I am working on a macro that exports Worksheets as Pictures to a Bookmark location in a MS Word Document. There are a couple of issues I would appreciate some help with:

Firstly, I would like the user to enter the number of worksheets to be exported. I would appreciate some code for this.

Secondly, if the target Word Document is already open then my macro goes into an endless loop 'Waiting for another program to respond' type error. Any suggestions on how I could improve my msoFileDialogFilePicker code to prevent this would be appreciated.

Please Login or Register  to view this content.