Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Personal.xls in networksituation

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi,

    i have the following (network) situation;

    3 computers with Excel on their own harddisc - each user is saving files to the network drive so all users can
    commonly use these files.

    I have some macro's in 'personal.xls' which need to be available on each of the 3 machines

    My idea is that the 'personal.xls' needs to be installed on each machine .

    My question is; is it possible to make 'personal.xls' available from the networkdrive ? (which would have numerous advantages like for updates on 'personal.xls')

    Any thoughts or help would be appreciated

    Rudi

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Save it as a template file.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 04:31, Mr Nick wrote:
    Save it as a template file.
    Yes that will copy the macro's in the workbook to a template on the networkdrive

    But how can I direct those macro's in 'persnlk.xls' (usually found in C:windowsapplicationdataexcelxlstart)to the networkdrive.



  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A bit of a stab in the dark, but have you tried creating a shortcut in XLstart that will open the network persoanl.xls ?

  5. #5
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Specify the network location as an alternate startup location. You can do this via Tools|Options and select the General tab.

    Hope this helps you out

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you want these personal macros to be available in this network sheet, why not just copy them to the actual sheet?

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 05:56, Mr Nick wrote:
    If you want these personal macros to be available in this network sheet, why not just copy them to the actual sheet?
    The reason to use 'persnlks.xls' is that all workbooks you generate through a template will be able to use those original macro's.

    If all your macro's are in your template Excel will create copies of those macro's with every new workbook your template generates.

  8. #8
    New Member
    Join Date
    Apr 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 05:49, Iain Lewis wrote:
    A bit of a stab in the dark, but have you tried creating a shortcut in XLstart that will open the network persoanl.xls ?
    I was thinking of something like this or finding a way to direct excel to that 'persnlk.xls' file - should try this one!

  9. #9
    New Member
    Join Date
    Apr 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 05:50, Barrie Davidson wrote:
    Specify the network location as an alternate startup location. You can do this via Tools|Options and select the General tab.

    Hope this helps you out

    Regards,
    Will this also direct Excel to this alternate startup location for the Xlstartfile (which usually features persnlk.xls) ?

  10. #10
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 06:27, Rudi wrote:
    On 2002-05-03 05:50, Barrie Davidson wrote:
    Specify the network location as an alternate startup location. You can do this via Tools|Options and select the General tab.

    Hope this helps you out

    Regards,
    Will this also direct Excel to this alternate startup location for the Xlstartfile (which usually features persnlk.xls) ?
    Rudi, not sure what you mean. The alternate startup location is used in addition to Excel's startup folder (XLSTART). So Excel will still open the files in that folder.

    You should note that Excel will try to open every file in the alternate startup folder. You should ensure you specify a folder that contains only files that Microsoft Excel can open.

    Does this help you out?

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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