Opening a file [SOLVED]

  • I need to open & display a spreadsheet that is located on a different computer. The path goes through several layers of sub folders to arrive at the final sheet. How do I go about this?

  • The full path is:
    \\Server Name\One California Retail\ONE CALIFORNIA RETAIL TRACKING APRIL 2003\DIRECTOR DODD- RETAIL\RMS BATARSEH - RETAIL\store 66836 Daily Report_VISION.xls


    I'm not sure what you mean by "Share workbook."

  • OK your path is on a network, do you know the drive letter say P:\


    teh \\ means go look for it to the network routers and servers, if multi box solutions used.


    The issue of SHARE is you can not run VBA on shared work, you need to :


    Non / un share
    Run code
    Save
    Re open
    Re share


    Hope that helps a little


    Kindest possable reagrds


    Jack in the UK

  • iwilli02,


    Hi willi,


    I'm going to assume from your post that you have little or no VBA code skills and give a very simple solution.


    Jack UK has assumed you want a number of people to use the file at once but the way I read your enquiry is that you want a simple way to access the file without trying to remember wher it is everytime ?


    Try this:


    1. Launch Windows Explorer.


    2. Locate the file in question.


    3. Right mouse click on the file and a list of commands appears. There should be one that reads - Send_To > Desktop (create shortcut). Click this command.



    This will place and Icon that represents the file on you Desktop (main screen). You can then jump straight to that file from your Desktop without going through the explorer window and trying to remember the path.


    Alternatively if you want to access this file from within Excel you can create what is called a hyperlink.


    Do this:


    1. Select a cell within you worksheet where you would like the Hyperlink placed. Click on the create hyperlink icon (within Excel as per image below).


    2. A new window appears called Edit Hyperlink. Use the link to file option and click on the browse button. This will allow you to select the location of the file you wish to link to.


    This will place a link to the file in your worksheet so that when you click it it will launch the file.


    Trust this helps.




    AJW

  • The problem I'm encountering is that the form I'm designing will have different paths for different users. In addition, the month & year will change. Unfortunately, that leaves out a Hyperlink. I don't know the drive letter. Presumably, that could be different too. All I have is the server name.

  • Quote

    Originally posted by iwilli02
    The problem I'm encountering is that the form I'm designing will have different paths for different users. In addition, the month & year will change. Unfortunately, that leaves out a Hyperlink. I don't know the drive letter. Presumably, that could be different too. All I have is the server name.


    you will have to programatically Map the Network drive to a letter;


    Here is some code to do this....


    http://www.xcelfiles.com/Excel01.html#anchor_14212


    woops...code just below this

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!