Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Macro Problem (http://www.outlookbanter.com/outlook-vba/14820-macro-problem.html)

Guy May 16th 06 04:56 AM

Macro Problem
 
I have developed a module by inserting it in to my project in the VBA editor. I can't open the Macro for editing from the Tools | Macro menu, nor can I successfully launch it from a button. I can run it successfully from within the VBA editor and it is set as a public sub. I have renamed the project, exported the module and imported it back in. I've deleted and recreated the module (pasting the code back in) and I still can't get it to work as a macro. Any ideas?

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com



Sue Mosher [MVP-Outlook] May 16th 06 04:39 PM

Macro Problem
 
Do you see it in the TOols | Macro dialog?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Guy" wrote in message news:Hbbag.16588$Qq.7411@clgrps12...
I have developed a module by inserting it in to my project in the VBA editor. I can't open the Macro for editing from the Tools | Macro menu, nor can I successfully launch it from a button. I can run it successfully from within the VBA editor and it is set as a public sub. I have renamed the project, exported the module and imported it back in. I've deleted and recreated the module (pasting the code back in) and I still can't get it to work as a macro. Any ideas?

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com



Guy May 16th 06 11:26 PM

Macro Problem
 
Yes it does. I've since renamed the module and it began working. Does it
matter if the module and the sub have the same name?

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com


"Sue Mosher [MVP-Outlook]" wrote in message
...
Do you see it in the TOols | Macro dialog?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Guy" wrote in message
news:Hbbag.16588$Qq.7411@clgrps12...
I have developed a module by inserting it in to my project in the VBA
editor. I can't open the Macro for editing from the Tools | Macro menu, nor
can I successfully launch it from a button. I can run it successfully from
within the VBA editor and it is set as a public sub. I have renamed the
project, exported the module and imported it back in. I've deleted and
recreated the module (pasting the code back in) and I still can't get it to
work as a macro. Any ideas?

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com





Sue Mosher [MVP-Outlook] May 16th 06 11:35 PM

Macro Problem
 
I don't know. What's your experience with that?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Guy" wrote in message news:Trrag.23425$Fl1.22110@edtnps89...
Yes it does. I've since renamed the module and it began working. Does it
matter if the module and the sub have the same name?



"Sue Mosher [MVP-Outlook]" wrote in message
...
Do you see it in the TOols | Macro dialog?



"Guy" wrote in message
news:Hbbag.16588$Qq.7411@clgrps12...
I have developed a module by inserting it in to my project in the VBA
editor. I can't open the Macro for editing from the Tools | Macro menu, nor
can I successfully launch it from a button. I can run it successfully from
within the VBA editor and it is set as a public sub. I have renamed the
project, exported the module and imported it back in. I've deleted and
recreated the module (pasting the code back in) and I still can't get it to
work as a macro. Any ideas?

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com





Guy May 18th 06 05:08 AM

Macro Problem
 
Not much. I usually don't do it but this one did have them the same. I'm not
sure if it had anything to do with it or not. Anyway, it works now
so..........

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com


"Sue Mosher [MVP-Outlook]" wrote in message
...
I don't know. What's your experience with that?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Guy" wrote in message
news:Trrag.23425$Fl1.22110@edtnps89...
Yes it does. I've since renamed the module and it began working. Does it
matter if the module and the sub have the same name?



"Sue Mosher [MVP-Outlook]" wrote in message
...
Do you see it in the TOols | Macro dialog?



"Guy" wrote in message
news:Hbbag.16588$Qq.7411@clgrps12...
I have developed a module by inserting it in to my project in the VBA
editor. I can't open the Macro for editing from the Tools | Macro menu,
nor
can I successfully launch it from a button. I can run it successfully from
within the VBA editor and it is set as a public sub. I have renamed the
project, exported the module and imported it back in. I've deleted and
recreated the module (pasting the code back in) and I still can't get it
to
work as a macro. Any ideas?

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com








All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com