新聞財經娛樂♬資訊 News Economy

Dear EE ExpertS,

I get one website for download my data files and when I input edit my product No and press enter key ,the IE7
window will  display data I want according to  my input product No. , and so I try to do testing ,  I try to
disconnect internet  and then after that I try to click its download button in the webpage,the  download popup
window  is  still  comming out or appear  and I still  be able to save the exact file I want after click save button .

So I wonder why I can save the  file even I  disconnect internet ,So I believe it is because when I input edit
the product NO and press enter key , the data file is fetched already into Cache file or memory  in my  PC before
I disconnect internet. So my question is if so, whether I am able to save my file without going through  the
download  or popup memu process  that will help me to save a lot VBA download file  program code and
exceute time with automation

I go to seach to my PC directory, finally I found one directory which is asynchronous to what I nagivate in IE7 before.
In such directory it has so many  sitename and image, files name that   I fire IE website before in recent days

The directory name is like C:usersmyaccountAppdataLocalMicrosoftWindowsTemporary Internet FilesConeten.IE5P5LBXH2C
something like that  in Window Vista , it seems it is mirror or Cache file to my PC memory, Is it true ?

In other words, I am able to save files directly from the Temporary Internet Files directory,Is it Right ?
So if so, I am easier to use VBA and following code to check file is existed or not and copy it to my directory from
the Temp Internet File directory, Is it right ? Please advise
Since I have a lot of files want to download in target website, so I prefer to do it in VBA with everything in auto
that will  save a lot of execute time when number of file to be download is huge like 1000 files

I try it before, but it is  fail and it might be not as much as easy I say.. Or  I ask where the Cache file is stored for internet file
in most in our PC 's memory and Cache file directory ?  I know Cache file directory is just a link or mirror to direct our PC
memory location. are those files to be able to be  saved by users ?
Please advise and Thanks

Duncan

Function CheckFileAvailable(sFilePath)    On Error Resume Next    Dim oFS    Dim oFile    Set oFS = CreateObject("Scripting.FileSystemObject")    Set oFile = oFS.OpenTextFile(sFilePath, 8, False)    If Err.Number <> 0 Then        CheckFileAvailable = "Fileinuse"      ' Debug.Print "FileinUse"    Else        CheckFileAvailable = "Fileisfree"       'Debug.Print "FileisFree"    End IfEnd FunctionSub CopyFile2File(wkdir As String, workbookname As String, wkdir2 As String, workbookname2 As String)Dim FsoSet Fso = CreateObject("Scripting.FileSystemObject")On Error GoTo Err Fso.CopyFile (wkdir & workbookname), wkdir2 & workbookname2  ' Change "*.*" to "*.xls" to move Excel Files only Exit SubErr: MsgBox "File path or Files not Found" Err.ClearEnd Sub                                  

1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:25:26:27:

The website is embeded with  Java Applet Application and it is advance stream data system
I enter product No and press enter, and then through window to disconnect
internet that is really easy, and then click the download button  and the file can saved to
my expect. I try many time for the testing, it is no problem at all.

Duncan
1 - GetWindoesCaption() - Gets the caption of the window that currently has focus
2 - boolOpenWindow = False - The window has already ben opened by the dialog box and sent on to download (that page doesnt need opening) Because you already have the file

R3nder