Home |
Search |
Today's Posts |
#1
|
|||
|
|||
User Form Problem ???
Hi
In Excel I have a customer list showing information in numerous columns e.g. Name/ Address / Contact info etc. In Word I have created a Label Template using the information in Excel. I have inserted a Command Button on the User Form in Excel is it feasible to just Click on the Command Button to open the Label Template in Word. If its possible what code would I need in the Excel VBA ???? Any help would be much appreciated. Cheers------ Mully |
#2
|
|||
|
|||
Hi Mully
My logic tells me you should do this from Word "mully" wrote: Hi In Excel I have a customer list showing information in numerous columns e.g. Name/ Address / Contact info etc. In Word I have created a Label Template using the information in Excel. I have inserted a Command Button on the User Form in Excel is it feasible to just Click on the Command Button to open the Label Template in Word. If its possible what code would I need in the Excel VBA ???? Any help would be much appreciated. Cheers------ Mully |
#3
|
|||
|
|||
Hi Kassie
Thanks I'll go on the Word New Users and see if somebody can help. Thanks again Cheers Mully "Kassie" wrote: Hi Mully My logic tells me you should do this from Word "mully" wrote: Hi In Excel I have a customer list showing information in numerous columns e.g. Name/ Address / Contact info etc. In Word I have created a Label Template using the information in Excel. I have inserted a Command Button on the User Form in Excel is it feasible to just Click on the Command Button to open the Label Template in Word. If its possible what code would I need in the Excel VBA ???? Any help would be much appreciated. Cheers------ Mully |
#4
|
|||
|
|||
You are on the right track. Keep the data in XL and the template in
Word. Then use Word's Mail Merge capability. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... Hi In Excel I have a customer list showing information in numerous columns e.g. Name/ Address / Contact info etc. In Word I have created a Label Template using the information in Excel. I have inserted a Command Button on the User Form in Excel is it feasible to just Click on the Command Button to open the Label Template in Word. If its possible what code would I need in the Excel VBA ???? Any help would be much appreciated. Cheers------ Mully |
#5
|
|||
|
|||
Hi All
Thanks for the help - I understand and I can handle it that way - what I was trying to do was make it user friendly for everybody to use - by just clicking on say a Labels Command Button in the Excel User Form and then it would auto to the Labels Template in Word and they can just click print in Word and - voila 250 Labels up and printed. Thanks again Cheers ----- Mully "Tushar Mehta" wrote: You are on the right track. Keep the data in XL and the template in Word. Then use Word's Mail Merge capability. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... Hi In Excel I have a customer list showing information in numerous columns e.g. Name/ Address / Contact info etc. In Word I have created a Label Template using the information in Excel. I have inserted a Command Button on the User Form in Excel is it feasible to just Click on the Command Button to open the Label Template in Word. If its possible what code would I need in the Excel VBA ???? Any help would be much appreciated. Cheers------ Mully |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
User Form Problem ???
I am interested in doing a similar thing...from a button in XL I intend to
open a form template and populate most fields with named fields that have the data in the workbook. I will let you know when I get it worked out. "mully" wrote: Hi All Thanks for the help - I understand and I can handle it that way - what I was trying to do was make it user friendly for everybody to use - by just clicking on say a Labels Command Button in the Excel User Form and then it would auto to the Labels Template in Word and they can just click print in Word and - voila 250 Labels up and printed. Thanks again Cheers ----- Mully "Tushar Mehta" wrote: You are on the right track. Keep the data in XL and the template in Word. Then use Word's Mail Merge capability. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , says... Hi In Excel I have a customer list showing information in numerous columns e.g. Name/ Address / Contact info etc. In Word I have created a Label Template using the information in Excel. I have inserted a Command Button on the User Form in Excel is it feasible to just Click on the Command Button to open the Label Template in Word. If its possible what code would I need in the Excel VBA ???? Any help would be much appreciated. Cheers------ Mully |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Picture | New Users to Excel | |||
user form | Excel Discussion (Misc queries) | |||
Data Entry Alert in User Form | Excel Discussion (Misc queries) | |||
File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |