Macro Coding Help

[LactoseO.D.'d]

Hey all,

I have a project that I am working on where I need to create two macros on an excel sheet with VBA.

1) Create a button that will add a new worksheet to the workbook with a lot of filled in information. How do I store this information and reference it?

2) Create a button that will populate data from multiple fields of the worksheet in to a Word template and print. I want this to be a single process. Hit button, word document pops up with information, and printing begins. To do this, will I have to embed a word template into the spreadsheet? How do I do that or reference it?

 

[bensonsearch]

Hey all,

I have a project that I am working on where I need to create two macros on an excel sheet with VBA.

1) Create a button that will add a new worksheet to the workbook with a lot of filled in information. How do I store this information and reference it?

2) Create a button that will populate data from multiple fields of the worksheet in to a Word template and print. I want this to be a single process. Hit button, word document pops up with information, and printing begins. To do this, will I have to embed a word template into the spreadsheet? How do I do that or reference it?

Hi and welcome

1) new worksheet is easy enough, with the data filled in is it constant? never changing data? does it come from a worksheet?

2) I wouldnt embed the template. can referance word vba from excel and tell it what to pull up. ie the template and paste info from here to there then print.

I would need more info to help more. Do you know vba or are you new? I would suggest recording a macro and looking