#2: VBA to Pick Range and letter
Thanks for your help yesterday; today, it seems to complicate way past
my VBA abilities. We now have 7 letters (1A-7G). What they'd like to do is: 1. Auto-filter a column in Excel to the rows that would get a specific letter. (done) 2. Click a commandbutton that would: 3. Open the Word merge document that pertains to the letter filtered in the spreadsheet. Somehow this seems like it should be easy, but then it is hard in chunks. I've got it through to the filtering, and all of the letters are built and associated, and I'm pretty sure I can code the merge letters to run the merge as soon as the document loads (via VBA). But, How do I tell the macro in Excel to pick just the filtered range? And, How do I tell it in the code which merge document to open? I could probably just use the Case member to select the letter based on the criteria in the Excel column that contains the name of the letter, but I'm stumped before I even get this far..... Thanks a ton -- I learn so much in here every day, but as George Harrison said, "the more I learn the less I know..." TomorrowsMan |
#2: VBA to Pick Range and letter
In your shoes I'd give some serious thought to using Word as the VBA platform
while treating the Excel file as a database. The next step would be to use ADO to query the Excel data, based on the desired letter, and return just that data to Word. "TomorrowsMan" wrote: Thanks for your help yesterday; today, it seems to complicate way past my VBA abilities. We now have 7 letters (1A-7G). What they'd like to do is: 1. Auto-filter a column in Excel to the rows that would get a specific letter. (done) 2. Click a commandbutton that would: 3. Open the Word merge document that pertains to the letter filtered in the spreadsheet. Somehow this seems like it should be easy, but then it is hard in chunks. I've got it through to the filtering, and all of the letters are built and associated, and I'm pretty sure I can code the merge letters to run the merge as soon as the document loads (via VBA). But, How do I tell the macro in Excel to pick just the filtered range? And, How do I tell it in the code which merge document to open? I could probably just use the Case member to select the letter based on the criteria in the Excel column that contains the name of the letter, but I'm stumped before I even get this far..... Thanks a ton -- I learn so much in here every day, but as George Harrison said, "the more I learn the less I know..." TomorrowsMan |
#2: VBA to Pick Range and letter
Duke,
I had thought of that, but the process the data entry people ar eusing is to put everything in the Excel spreadsheet first; I was then hoping they wouldn't have to think about opening the Word docs at all, but instead just trigger them from Excel. Unless I'm missing an easier point you're making; I'm pretty new at integrating the two applications.... Chris Duke Carey wrote: In your shoes I'd give some serious thought to using Word as the VBA platform while treating the Excel file as a database. The next step would be to use ADO to query the Excel data, based on the desired letter, and return just that data to Word. "TomorrowsMan" wrote: Thanks for your help yesterday; today, it seems to complicate way past my VBA abilities. We now have 7 letters (1A-7G). What they'd like to do is: 1. Auto-filter a column in Excel to the rows that would get a specific letter. (done) 2. Click a commandbutton that would: 3. Open the Word merge document that pertains to the letter filtered in the spreadsheet. Somehow this seems like it should be easy, but then it is hard in chunks. I've got it through to the filtering, and all of the letters are built and associated, and I'm pretty sure I can code the merge letters to run the merge as soon as the document loads (via VBA). But, How do I tell the macro in Excel to pick just the filtered range? And, How do I tell it in the code which merge document to open? I could probably just use the Case member to select the letter based on the criteria in the Excel column that contains the name of the letter, but I'm stumped before I even get this far..... Thanks a ton -- I learn so much in here every day, but as George Harrison said, "the more I learn the less I know..." TomorrowsMan |
All times are GMT +1. The time now is 06:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com