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?
Opening a file [SOLVED]
-
-
-
Hi and welcome to the board
This can be tricky and therefore we need more information about the pathway and so on.
BTW, have You consider to use share workbook instead?
-
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.xlsI'm not sure what you mean by "Share workbook."
-
Ok
Shared work book is everyone can open it at the same time, write to it and save it.
So a group can use it at teh same time, not as is usual one person.
Jack in the UK
-
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 shareHope 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
-
Use UNC Path to Open a Workbook
So does that mean you cant use the UNC Path to reference a network location?
Regards,
Aaron
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!