Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add In Newbie (Excel VBA)

    A couple times a week I download a different excel spreadsheet and do a few steps like sort, copy and paste, and save as. I can write the macro to do the steps but I would like to place a button in the menu to run the code. Do I need to create an add in so that I can run that code from different files.

    Thanks

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add In Newbie (Excel VBA)

    Place the code and toolbar button in your Personal.xls template.
    Regards
    Don

  3. #3
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add In Newbie (Excel VBA)

    I have done a search I can't find this file (excel 2000). Where might it be?

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add In Newbie (Excel VBA)

    This post should help you <post#=282262>post 282262</post#> . Thanks to the all knowing Hans!
    Regards
    Don

  5. #5
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add In Newbie (Excel VBA)

    You may not have a personal.xls file. For a tutorial on the subject see <post#=118382>post 118382</post#>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •