35
I have several Excel books which contain 7000 serial numbers to be received on one POP.
Is there a way to import these serial numbers directly from the Excel book? Copy / paste keystrokes will have us crippled!
*This post is locked for comments
In order to double the speed of the macro, use the Advanced Macro Menu >Status and select the checkbox next to 'No User Interface Flash'. If you don't have the Advanced Macro Menu, add the switch
ShowAdvancedMacroMenu=TRUE
to your Dex.ini file. As Tim suggested, I would also definitely break it down into smaller batches. I've been told the macro will fail if you try to do it all at once. I also think 1000 at a time is a good number to use.
Kind regards,
Leslie
Sorry I didn't see that you had replied.
I'm thinking you could use a GP macro to do it.
Paste all the serial numbers into one sheet so you can see what you are doing. Then record a macro for one serial number, and mail merge the rest in.
Search on web for GP mail merge macros for you tube and website general tutorials.
I would have thought it will work for what you are trying to do.
<<Edit>>
Just tested it with 7k serial numbers, takes long time for word to mail merge and a fair while to chug through the entry of the serial numbers, but does work.
I would be tempted to break it down into 1000 at a time and run it seven times to make it all a bit more responsive.
Tim.
Are they all for the same pop line?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
