Results 1 to 2 of 2

Thread: Saving and Running Macro For Multiple Files / Users

  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    7
    Rep Power
    0

    Saving and Running Macro For Multiple Files / Users

    Hello,

    I have a macros I need to run on a file of variable name and was hoping to get some ideas from you on what would be the easiest way to do so for a non technical end user. I have a .txt file I need to copy and paste into excel and then run the code.

    I was wondering if I could make it so that I can open a pre-coded spreadsheet that would then allow the user to browse for the file, find it and then run the code automatically. If this is possible, could you please provide a sample code? Also, please advise where would the macros need to be saved?

    Like always, thanks in advance for your help!!

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    One way to do this is to put your macro in an add-in file, which will create a simple button on the menu bar (Excel 2003 or earlier), or on the Ribbon (Excel 2007 or later) that will call your macro. For an idea of an add-in, you can use any of the add-ins in this forum, or search for add-ins on the internet.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Macro To Close All CSV Files
    By Howardc in forum Excel Help
    Replies: 5
    Last Post: 03-15-2014, 05:24 PM
  2. Macro stops running if date is not in past...
    By Carlos Arruda in forum Excel Help
    Replies: 4
    Last Post: 03-10-2013, 04:33 PM
  3. Running a VBA in all excel files
    By msiyab in forum Excel Help
    Replies: 3
    Last Post: 12-26-2012, 01:35 PM
  4. Macro to copy data from a set of excel files
    By Sreejesh Menon in forum Excel Help
    Replies: 5
    Last Post: 11-15-2012, 11:17 AM
  5. Macro to create files as per the contents in a column
    By Praveen Bj in forum Excel Help
    Replies: 1
    Last Post: 07-05-2012, 09:07 PM

Posting Permissions

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