I need some code to use the OPEN statement. The file I want to open is on another computer on my home network.
Anyone know what the file string should look like
Thanks
How To Open A File On Another Computer On A Home Network
Hot Topic
- iexplore.exe - Application Error
- ShellExecute Function
- Can't open regedit
- Error Referencing DLL in VBA
- Application Error Caused by launching a Game
- Unable to start debugging In VS2005
- Method 'OnAction' of object 'CommandBarButton' Failed
- Sum of hours using select statement & VBA
- Access 2003 adp ignoring OpenConnection encryption setting
- WSD (Web Service For Device) code Generation Tool
Microsoft ISV
- Summing up hours on form based on parameter query
- combine 3 combo boxes values into one string
- vba array?
- Microsoft Platform Test for ISV Solutions
- Workbooks.Open (... problem
- Call Windows API to store hyperlink path to external documents
- cutting down this code? help?
- can you help ?
- open a workbook with events turned off
- subscript out of range
How To Open A File On Another Computer On A Home Network
Vladimir Chtepa
The basic format for a local/remote resource is "file:///"
For example, if you're looking to browse the directory "C:\TEMP\", you'd use the path "file:///C:/TEMP/".
afitoine
Hi
Easiest think to do is to set up a drive mapping in windows which loads each time your computer starts,then you can use a drive letter to refer to the computer. Otherwise, turn on the macro recorder and open the file from My Network Places and the recorder will correctly record the path for you.