Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
#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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.word.vba.general
|
|||
|
|||
#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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.word.vba.general
|
|||
|
|||
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#2: VBA to Pick Range and letter | Excel Discussion (Misc queries) | |||
#2: VBA to Pick Range and letter | Excel Worksheet Functions | |||
loop through cells in a range and pick up corresponding cell values in another range | Excel Programming | |||
can I pick start point in a range? | Excel Discussion (Misc queries) | |||
how to pick from a range of table values | Excel Worksheet Functions |