Ho do I insert a field based on a VB Macro?

[Brian Ferguson]

Hi All,
I need to calculate the current week's ending date (Friday in my case). I
have written a VBA macro that will return the correct value, but how to I
call the macro from a word document?

Thanks
Brian

 

[Jonathan West]

Hi All,
I need to calculate the current week's ending date (Friday in my case). I
have written a VBA macro that will return the correct value, but how to I
call the macro from a word document?

Thanks
Brian

Word doesn't offer a field that automatically inserts the return value of a
VBA function.
You can create a keyboard shortcut or a toolbar button that will call a
macro. Take a look at the Customize dialog on the Tools menu.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Brian Ferguson]

Jonathan,
Thanks for your rapid response. I'll try your suggestion.

Thanks
Brian