accessing file remotely VBA code

[instanceoftime]

I have my xls with code on my desktop.

The code needs to access a remote computer to open an excel file "items".

How is this done? I tried a Z: and the following:

Workbooks.Open Filename:="Z:\Fileserver\Admin1\Glen\101-061-909\Glen\price program\items.xls"

but says could not be found? Help me please

 

[Kenneth Hobson]

Check that the path exists by recording a macro to open the file and compare.

 

[instanceoftime]

Check that the path exists by recording a macro to open the file and compare.

crap, good call .. I didn't do as you asked (not sure how to go about what you asked) but

the network drive was correct (and visible) so I opened it and made a shortcut of the file I was trying to open and checked the properties for the location.

Workbooks.Open Filename:="Z:\Fileserver\Admin1\Glen\101-061-909\Glen\price program\items.xls"

should have just been Workbooks.Open Filename:="Z:\items.xls"

thanks

 

[Kenneth Hobson]

Right click your Ribbon and Customize it. Check the box on right side for Developer. From it, you can record macros, play, edit, insert controls, etc.

Recording a macro can help you create routines where syntax is not known. As you code, you will find that recorded macros is just a start. It uses a lot of Select, Selection, and Activate. Most times, that is inefficient and not needed.