ExcelBanter - Copy excel table to Word, loss information in memory

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy excel table to Word, loss information in memory (https://www.excelbanter.com/excel-programming/384129-copy-excel-table-word-loss-information-memory.html)

Alex St-Pierre

Copy excel table to Word, loss information in memory

Hi,
When I copy an excel table to Word, sometime (1 time on 10), the program
stop at the line #2 and say there's nothing in memory. If I return to line
#1, and click F8, the program continue and work fine. Any idea?
Thanks!
Alex
oXlRng.Copy
oRange.PasteExcelTable LinkedToExcel:=False, WordFormatting:=False,
RTF:=False 'oRange is a Paragraph Range in Word.
--
Alex St-Pierre

All times are GMT +1. The time now is 10:58 AM.