Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WEB Link
Hi
I need a excel macro code to enter to the web link and search for particular xls file and save it to desktop.. I have a web link, when i browse my web link, i will have a list of excel files which i need to save to my desktop.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WEB Link
try this code. when searching a web directory I think youjust need to put //
infront of the filename strFolder = "//abc.com/mydir" Public file_loc As String Sub findfile() 'set MyFilename and strfold as required 'file to search for Const MyFileName = "xyz.txt" 'directory to start searching strFolder = "c:\temp" file_loc = "" Set fso = CreateObject _ ("Scripting.FileSystemObject") Set folder = _ fso.GetFolder(strFolder) Call GetWorksheetsSubFolder(strFolder + "\", MyFileName) MsgBox ("File found in folder: " & file_loc) End Sub Sub GetWorksheetsSubFolder(strFolder, MyFileName) Set fso = CreateObject _ ("Scripting.FileSystemObject") Set folder = _ fso.GetFolder(strFolder) If folder.subfolders.Count 0 Then For Each sf In folder.subfolders On Error GoTo 100 Call GetWorksheetsSubFolder(strFolder + sf.Name + "\", MyFileName) If file_loc < "" Then Exit For 100 Next sf End If 'folder size in bytes On Error GoTo 200 If file_loc = "" Then For Each fl In folder.Files If fl.Name = MyFileName Then file_loc = folder.Name End If Next fl End If 200 On Error GoTo 0 End Sub "Ranjit kurian" wrote: Hi I need a excel macro code to enter to the web link and search for particular xls file and save it to desktop.. I have a web link, when i browse my web link, i will have a list of excel files which i need to save to my desktop.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink Link Field to link to file on website | Excel Programming | |||
Updating link to database w/o breaking the link | Excel Programming | |||
How to Change External Link to Internal Link | Excel Programming | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) |