I am involved in converting Word Documents to XML and need to create macros and code to help me do that. I hope to find some help here
I am involved in converting Word Documents to XML and need to create macros and code to help me do that. I hope to find some help here
Welcome to the forum.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Greetings Everyone,
I'm known as EWBJ (EW BEE JAY). It seems we have a lot in common already, in that VBA is a challenge to our productivity. It is hoped that I will be able to get an answer to my challenges.
Toda,
---EWBJ
=============
It’s been about 20 years since retiring. Prior to that I programmed different flavors of Cobol, Clist, Assembler, Focus, dBase (I-III) and several dialects of Basic (Quick, Extended, TI-Basic, etc.), but I must say Visual Basic (VBA) is a new and confusing “animal” to and for me. Maybe it’s because I’ve aged a bit . With the previous in mind, here are my challenges and needs:
1. I have already built an Inventory workbook currently consisting of 4-tabs
a. Warehousing Keeps a running list of what I have on-hand
b. OrderBy Keeps a running list of who actually orders my product(s)
c. Ordering Keeps a running list of who my customers are, what they purchase, etc.
d. Pick-Pack-Fields is created from certain fields within each of the above worksheets so that a Word 2007 mail merge can be used to create print shipping labels for the ordered product on any given day
2. So I’d like to be able to…
a. Automatically create a new Pick-Pack-Fields (shipping label) worksheet .xlsx external file by automatically populating fields, row-by-row in the shipping label worksheet populated from the Inventory Workbook, which is made up of: the Warehousing, OrderedBy and Ordering worksheets.
b. Automatically create each shipping label .xlsx file with a unique identifier such as:
Pick-Pack-Fields(yymmdd) – e.g. Pick-Pack-Fields(130814) while the next day’s output file would be Pick-Pack-Fields(130815), and so on…
c. Automatically run the Word 2007 Mail Merge from within Excel 2007 using the shipping form I’ve already created in Word and using only the Pick-Pack-Fields(yymmdd) file I choose to run, to prevent redundant shipping label prints, wasted time, toner and paper.
Since 8/1/2013 or so, I have tried several techniques no avail. Only manual intervention works for creation of the Pick-Pack-Fields (shipping labels) in Excel 2007 to be passed to the Word 2007 mail merge process. The mail merge using the Pick-Pack-Fields works fine. It’s just tedium ad infinitum.
Kindly help my understanding!
---Thanking You In Advance, EWBJ
Welcome to the forum
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks