User Profile

Collapse

Profile Sidebar

Collapse
TKrc
TKrc
Last Activity: Sep 19 '06, 02:48 PM
Joined: Sep 12 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • TKrc
    started a topic open e-mail from with an option button

    open e-mail from with an option button

    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
    See more | Go to post

  • TKrc
    replied to Open Powerpoint from Excel
    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...
    See more | Go to post

    Leave a comment:


  • TKrc
    started a topic Open Powerpoint from 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
    See more | Go to post
No activity results to display
Show More
Working...