Import Word Table Macro running very slow
On Aug 4, 9:00*pm, "Jim Cone" wrote:
*"Change .Paste to .PasteSpecial"
* * * "I changed the code as per your instructions.
* * * *The macro runs for 4-5 mins now and puts the Word Tables as Embedded
* * * *Object (nearly 500 Objects)
* * * *Have I done something wrong."
'--
Well that is very interesting. *
PasteSpecial has an option that should fix the situation...
Change..
.PasteSpecial
To...
.PasteSpecial xlPasteValues
'--
Jim Cone
Hi Jim,
Thanks for revised code.
It works (just under 2 minutes) but now many date values have changed
eg 01/06/2010 changed to 06/01/2010 (I am using dd/mm/yyyy) format.
Pls note that some date are shown properly...only some have changed.
Can you see about this problem please?
|