Code to Copy Excel to Word stopped working in 365 but still works on 2010

[JimmyA]

Hello All

I have put together some code (Attached) that was outputing different paragraphs and tables into word documents. It was working fine but has suddenly stopped working. I still have access to Excel 2010 and it works fine in that.

Is anyone able to have a look at the code and see if there is a reason this no longer works in 365?

It is falling over at the "PasteExcelTable" line with Error 4198 Command Failed.

Any thoughts or advice would be great.

Cheers

James

[mjr veverka]

Maybe try it this way:

Please Login or Register  to view this content.

In total, I didn't change too much. What will be the result ?

[JimmyA]

Hi porucha vevrku

Thanks very much for taking the time to reply to my post. I was trying to keep the "PasteExcelTable" line as it seemed to be the only way I could get the Autofit part to work. Simply pasting seems to then ignore the autofit line. It doesn't fall over but the formatting of tables remains the same.

I have now decided to use "Paste" but then to add a few lines of code at the end of producing the word document to adjust all tables in one go.

Please Login or Register  to view this content.

Thanks again for your reply

Best Regards

James