Hi!
I have made a userform in word.
It has one textbox(going to be filled with numbers) and one commandbutton.
When i press the commandbutton in my userform i want i to do the following.
1. Start up an excel file.
2. Take the data in the textbox and place it in the excel file´s cell b2.
3. Run the macro "fetchdata" in the excel file(already created) that fetches the data connected to the number.
-- When run cells c2,d2,e2 will be filled with data.
4. Take the data from the cell and place them in the bookmarks created in word.
Done!
Ive been told to use mailmerge? Can I do that?
Is there a tuturial for opening and running macros i other files? We are using medium macro security.
Happy for any thoughts about this..
//Carl
I have made a userform in word.
It has one textbox(going to be filled with numbers) and one commandbutton.
When i press the commandbutton in my userform i want i to do the following.
1. Start up an excel file.
2. Take the data in the textbox and place it in the excel file´s cell b2.
3. Run the macro "fetchdata" in the excel file(already created) that fetches the data connected to the number.
-- When run cells c2,d2,e2 will be filled with data.
4. Take the data from the cell and place them in the bookmarks created in word.
Done!
Ive been told to use mailmerge? Can I do that?
Is there a tuturial for opening and running macros i other files? We are using medium macro security.
Happy for any thoughts about this..
//Carl
