How to use vbscript to get filesize? 1

[ddelport]

See the search facility is not working!?

I want to run a procedure that is dependent on the evaluation of two files' sizes. As the one grow it's larger size will be used as condition to update the second file. This I need to build in an Access procedure but I don't know vbscript that well. My idea is to get the file sizes using the latter and put these values in variables respectively. Now I can base an IF-statement on this and get on with it. Anybody got me a suggestion how to operate this vbscript function?

 

[Blorf]

Try something like:

Function FileSize()
X = FileLen("C:\ChaZ.Txt")
MsgBox X
End Function

ChaZ


"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[ddelport]

Thanx Chaz! Didn't know about that one. I suppose I can get along without the help of vbscript afterall! I have, in the meantime, found another alternative as well - just for info, but pleeze help me right if the following is wrong (it works in practise though) :

dim flsysobj, thefile,thesize
Set flsysobj = CreateObject("Scripting.FileSystemObject")
Set thefile = flsysobj.getfile("c:\file.xyz")
thesize = thefile.size 'etc...

 

[Blorf]

Would seem OK I suppose, but if all you need is the file size, I suppose you could get it with out using a module of any kind.

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[ddelport]

Yeah, thanks, and your's takes less time AND space...