Importing data from a closed workbook on a network

[clayton]

Hello,

I am trying to get the values of named cells from a workbook on our server to show in my workbook. I only want the values.

In the below code the FileName is being selected before hand and is working.
range(ordercell1) holds the value I am trying to get.

Im trying to do something like this:

var1 = "\\ourserver\folder name\" & FileName & Worksheets("Sheet1").Range(ordercell1) 

ThisWorkbook.Worksheets("Sheet1").Range("testcell") = var1

I've been trying all kinds of variations and nothing has worked.
Can I get some of your all's good advice?

[raypayette]

You should try sharing your workbook or your workspace:
http://office.microsoft.com/en-us/ex...898961033.aspx

[clayton]

You should try sharing your workbook or your workspace:
http://office.microsoft.com/en-us/ex...898961033.aspx

Thanks for your replay but for this little project the sheets are not the same. One is entered by administration and the other (the one I want to import data to) is used by workers.

All I'm trying to do it have a button on the worksheet that when pressed does a few things.

1. Opens a File selection box so they can choose a file (perferably already in the server folder "\\server\files"

2. After selecting the specific file they want this sheet will import all the specified named fields with the values in thoses cells.


Anyone have any ideas on how to accomplish this?