Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Posts
    142
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there a way to run an Excell macro - in the PERSONAL folder - when the file resides on the server bu the macro resides on a specific workstation?

    Thanks in advance for your time.

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts
    [quote name='Nucthat1' post='792280' date='05-Sep-2009 15:10']Is there a way to run an Excell macro - in the PERSONAL folder - when the file resides on the server bu the macro resides on a specific workstation?

    Thanks in advance for your time.[/quote]
    Macros in your Personal.xls workbook are by default available whenever Excel is running; so you should be able to run the macro against any other workbook, no matter where the workbook is stored.

    Can you provide a little more detail as to what you're trying to do, and what is the problem you're encountering?

    Gary

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Posts
    142
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry for not getting back to you sooner.
    The Personal.xls file resides on a computer networked to the server. The file resides on the server and is accessed by another computer also networked to the server. So, there really is no link to the Personal.xls stored macro. One of the local guru's said to store the macro in the worksheet and put the file wherever you want. I have not tried this yet.

  4. #4
    New Lounger
    Join Date
    Dec 2009
    Location
    Central Texas, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes, put the macro in the worksheet or workbook of the file on the server. Otherwise, the alternative is for everyone to have a copy of Personal.xls with the same macro, which can result in issues with some people having older (buggy) versions of the macro.

    --Scott.

Posting Permissions

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