Quote:
Originally Posted by Hdata
Using paste in my VBA code depends on how much I am pasting. If the amount of text you are pasting is relatively small, this approach works well and does not apply the normal formatting. However, when I paste a large amount of text, the answer seems to be yes. Seems this approach works to protect against crashing the system with too much formatting.
Best always
|
I'm copying from the web page output of a system that's being developed for my company. The amount of text can vary. Worst case, so far, is copying ~1600 lines of data from three web pages of output - total about 5,000 lines. That's worst case. Most are only a few hundred lines. And I need the formatting to evaluate the output.
They've just upgraded idea to Office 2013. Pasting directly into Excel has become so painfully slow, but I discovered that pasting into Word, cutting, then pasting into Excel is rather quick. And there are these annoying notifications.
I've not had any problem with system crashes while doing this. And this is a stop-gap measure during the evaluation. Eventually it will email us reports, but until this is enabled, I'm doing the copy / paste bit.
So, if there's any way to automate pasting in Word
with formatting, that would be great.
Thanks,
Frank