Recent content by FRoeCassNet

Trying using the silent switch. Shell "Regsvr32 /s NameofComponent.dll"

I'm not sure your problem is with a comma so much as it is that the string doesn't have a &quot;<&quot; in it. The way you use the loop: Do While character <> &quot;<&quot; will continue forever if your string doesn't have a &quot;<&quot; in it character.

A very quick and dirty approach is: Dim fso As FileSystemObject On Error Resume Next Set fso = New FileSystemObject fso.MoveFolder &quot;c:\test\Foo&quot;, &quot;c:\test\archive\&quot; Set fso = Nothing Then the MoveFolder method will fail (error 76, path not found) if the folder doesn't...

If you don't know how many numbers there are or where they are, you can do a simple loop: Dim s As String Dim sNum As String Dim i As Integer s = &quot;05hdmj09kj03&quot; sNum = &quot;&quot; For i = 1 To Len(s) If IsNumeric(Mid(s, i, 1)) Then sNum = sNum & Mid(s, i, 1) Next Debug.Print sNum

Try adding FOF_NOCONFIRMATION to the .fFlags property

Try using the modulus operator (returns the remainder). If Qty Mod Pack = 0 Then 'Full packs Else 'There not all full packs End If

You can use a DataTable object's DataColumnCollection to add/remove columns. However, if you're also using a dataset, then you'll have to update the schema also with something like WriteXmlSchema() Hopefully this will get you pointed in the right direction. Dim cols As DataColumnCollection =...

I believe split() was added to VBA in the office 2000 version.

numbers don't have leading zeros, text strings that represent numbers can though. What you need to do is format the number as a string when outputting it. Since the length of the string changes, get that first. nLength = Len(strTmp(1)) Then format your number to that size Msgbox...

You are correct, but I believe mscott was looking for dropping an object onto his &quot;non-running&quot; shortcut, not dropping onto a currently running program.

A lot depends on how you created your StrArray Class, but if like a normal array with an index and upper/lower bounds, why not just loop through it that way. For i = lbound(c.param) to ubound(c.param) set p = c.param(i) .... Instead of the For Each p In c.Param

You're right about the doevents in the service, wasn't reading real close :/ Did you use the SetTimer() function to create the timer and if so, how long of a delay did you give it? Maybe the delay was too long, try setting it to a smaller delay and the use the datediff to determine the 10 minutes.

I hope this is embarrasingly simple.... I believe that by default if you &quot;drop&quot; a file onto an exe from Windows Explorer, it will pass the filename to the program as the first parameter. So, if you drag the file &quot;C:\Foo.txt&quot; and drop it onto myprog.exe, you'll get the...

The DoEvents methods exists in: System.Windows.Forms.Application.DoEvents() I'm not sure this will take care of your CPU utilization since you'll still be in a tight loop though. Any idea what was causing the Timer to be flaky?

Have you looked at the DataGrid? It has what may (may not) be what you're looking for. With hierarchical data, it'll display the top node records with a plus expand down to child rows and so on.