Tomorrowsman
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 3 articles for 0.302 sec
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     

Group: microsoft.public.excel.misc · Group Profile · Search for Tomorrowsman in microsoft.public.excel.misc
Author: TomorrowsMan
Date: Nov 17, 2006 11:57

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
Show full article (1.89Kb) · Show article thread
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     

Group: microsoft.public.excel.misc · Group Profile · Search for Tomorrowsman in microsoft.public.excel.misc
Author: Duke Carey
Date: Nov 17, 2006 11:45

Show full article (1.43Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Tomorrowsman in microsoft.public.excel.misc
Author: TomorrowsMan
Date: Nov 17, 2006 11:15

Show full article (1.10Kb)