Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Hyperlinks thru code
I want to automate a process where files (Excel or Word) are places in an
Eroom on the Intranet and access them via VBA. I don't know any path exept the hyperlink. I'am not allowed to access the files using the "\\server\share\..." manner. Is it by any mean possible to do so? Hope I have supplied enough information /Christer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Hyperlinks thru code
There are lots of methods. Do you mean that you haven't been successful in
accessing the files using \\server\share\...", or you don't have permission on your server to get the files in this manner. Yo may be having problems because you filename (including path) excecess ~126 characters. The solution would be to map a network drive to a subfolder on the network drive. DIR() won't find files on network drives but a "file scripting object" will find the file names. You could use FTP to download the files and then open them from you local PC. Can you see the files using a window explorer and if you can can you open the files with the windows explorer. "Christer" wrote: I want to automate a process where files (Excel or Word) are places in an Eroom on the Intranet and access them via VBA. I don't know any path exept the hyperlink. I'am not allowed to access the files using the "\\server\share\..." manner. Is it by any mean possible to do so? Hope I have supplied enough information /Christer |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Hyperlinks thru code
Thank you Joel, the fact is that I don't have the permisson to access the files exept using the hyperlink. Files may (in some cases) also be accessed at the same time by more than one user. Could it be possible instead to put an MS Access database in the Eroom (preferable with a frontend and backend file) and keep track of the information? In that case all the Excel or Word files are not nessecery. "Joel" wrote: There are lots of methods. Do you mean that you haven't been successful in accessing the files using \\server\share\...", or you don't have permission on your server to get the files in this manner. Yo may be having problems because you filename (including path) excecess ~126 characters. The solution would be to map a network drive to a subfolder on the network drive. DIR() won't find files on network drives but a "file scripting object" will find the file names. You could use FTP to download the files and then open them from you local PC. Can you see the files using a window explorer and if you can can you open the files with the windows explorer. "Christer" wrote: I want to automate a process where files (Excel or Word) are places in an Eroom on the Intranet and access them via VBA. I don't know any path exept the hyperlink. I'am not allowed to access the files using the "\\server\share\..." manner. Is it by any mean possible to do so? Hope I have supplied enough information /Christer |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Hyperlinks thru code
the prefer method when files are sharred is to use Access. Then setup a
webquery or database query using hte worksheet menu Data - Import External Data - Import data - New Query (web or databasse). A macro can also be used to generate the query on the worksheet. Or with a macro you can connect to the database (either ADO or DBO methods using SQL) and read the data. If the users are going to submit data then the ADO or DBO methods are used. "Christer" wrote: Thank you Joel, the fact is that I don't have the permisson to access the files exept using the hyperlink. Files may (in some cases) also be accessed at the same time by more than one user. Could it be possible instead to put an MS Access database in the Eroom (preferable with a frontend and backend file) and keep track of the information? In that case all the Excel or Word files are not nessecery. "Joel" wrote: There are lots of methods. Do you mean that you haven't been successful in accessing the files using \\server\share\...", or you don't have permission on your server to get the files in this manner. Yo may be having problems because you filename (including path) excecess ~126 characters. The solution would be to map a network drive to a subfolder on the network drive. DIR() won't find files on network drives but a "file scripting object" will find the file names. You could use FTP to download the files and then open them from you local PC. Can you see the files using a window explorer and if you can can you open the files with the windows explorer. "Christer" wrote: I want to automate a process where files (Excel or Word) are places in an Eroom on the Intranet and access them via VBA. I don't know any path exept the hyperlink. I'am not allowed to access the files using the "\\server\share\..." manner. Is it by any mean possible to do so? Hope I have supplied enough information /Christer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing New Menu code | Excel Programming | |||
Accessing Menu Options from VB Code | Excel Programming | |||
VBA code to add hyperlinks | Excel Programming | |||
Accessing Addin from Sheet_Event Code | Excel Programming | |||
Accessing Addin from Sheet_Event Code | Excel Programming |