Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calling macro from MS Excel (MS Word works fine)
- Thread starter dyreborg
- Start date
- Thread starter
- #2
Hi
I don't know what makes the command "PRINT 27 "&f#x#Y" " in Word, but if you don't find in Excel you need make a public sub/function that makes the work:
1.- Go to the VBA editor (Alt+F11)
2.- Whit the contextual menu "Insert" a "Module"
3.-Write a sub/function that makes all you want (called as you whant and with the parameters it need).
4.- In the Excel cells try to add a call to your new "Macro":
=
"More functions..."
"User functions..."
(Here you should see the name of the function you writed)
This is the base of Macro creation...
I helped?
I don't know what makes the command "PRINT 27 "&f#x#Y" " in Word, but if you don't find in Excel you need make a public sub/function that makes the work:
1.- Go to the VBA editor (Alt+F11)
2.- Whit the contextual menu "Insert" a "Module"
3.-Write a sub/function that makes all you want (called as you whant and with the parameters it need).
4.- In the Excel cells try to add a call to your new "Macro":
=
"More functions..."
"User functions..."
(Here you should see the name of the function you writed)
This is the base of Macro creation...
I helped?
- Status
