Search results for query: *

'Find newest file Here is were you've been starting your directory reading. dirname = Dir("n:\Share\Hpcheck\tests\line" & MachineName & "\", vbDirectory) This section was reading all the filenames before it got to the DO LOOP. So it would have been putting you at the...

Here's another alternative. If it can't open the file presumably the file doesn't exist. There may be an obscure time when it doesn't work. So far I haven't seen it fail yet. Public Function FileExists(Filename as string) as Boolean On Local Error got FileOpenError Dim FileNum as long...

I use the following VB code to execute a file Shell ("FilePath") If FilePath is a variable holding the path of the executable then the quotation marks have turned it into a string. :-) And I believe you do have to put in an absolute path too...

Yes its possible to utilise your VB and SQL learning on Linux. Apparantly no emulator needed. Search on Google for Envelop and Pheonix. VB lookalike in Windows not sure what it looks like in Linux. The files to specifically search for are "phoenix-1.5-6.i386.rpm" and...

Find the empty rows first and store the column,row pointers in an array. ie... Array.col and array .row Then populate the spreadsheet by cycling through the array. Record type testarray col as string row as string End type Dim MyArray() as testarray 'In Procedure... Dim I as Integer Dim J as...

If your sending information to a textbox on a form you could use a variable instead or Form.Hide Use a splash screen or animated icon so Users can see something is happening.

This is written in VBA in Excel 9 Shouldn't be difficult to translate to VB5 - 6 There are probably better ways of doing it. Thats the fun of VB doing your research. Sub KillDetail() Dim I As Long Dim K As Long I = 1 Do Until Range("A" & Str(I)).Text = "Total :-&quot...