I hope all is well.
I'm looking to open e-mail with an option button from my CustomMenu within excel. Can anyone please help with the correct code. The code below worked well with office 2000, but not XP.
Thank you so much
Sub email()
StrEmail = "mailto:yourema iladdress.com"
ActiveWorkbook. FollowHyperlink Address:=StrEma il
CustomMenu1.Hid e
End Sub
User Profile
Collapse
-
open e-mail from with an option button
-
Thank you so much for your reply. Not sure if it is exactly what i'm looking for.
What I'm trying to do is open a specific powerpoint file from an option button, then close the powerpoint file and have my CustomMenu reappear. My CustomMenu would be the toolbox and i want to be able to pull either excel or powerpoint files up, make revisions, save and close. After closing any file, i want the CustomMenu to reappear. I have the excel... -
Open Powerpoint from Excel
Hi Everyone - I am running XP (VB 6.3) and am having a problem opening Powerpoint from an option button that is located in a Userform.
The code I'm trying worked with windows 2000, but not XP.
MyAppID = Shell("C:\Progr am Files\Microsoft Office\OFFICE11 \POWERPNT.EXE ""
Can anyone please point me in the right direction.
Thank you so much
No activity results to display
Show More
Leave a comment: