Recent content by WBURKERT

I have this vbscript working but don't seem to know how to get the port number passed into the Function GetPingInfoIP(strComputer). The worksheet layout is Column A is an administrative entry, Column B is the Port Number, Column C is the IP address and Column D is the results and is shifted...

The following PAPING.EXE script is working but how can I get the port number from Column B? The worksheet layout is column A = computer name, column B is the port number and Column C is the IP Address. Column D is the current results. Sub PingChecker() Dim MySheet As Worksheet Dim...

The kine below does not execute and may be causing my macro from running. paping.exe works without a problem from a command prompt. boolCode = objShell.Run("paping " & strWKB, 0, True) This line executes and is similar to what I am trying to accomplish with paping. 'boolCode =...

I am trying to use the paping.exe in an EXCEL VBA but the command is not getting executed. Doing the same with Ping.exe works as expected. The code below is showing the ping command working and the paping.exe commented out. the paping command works when manually entered in the command window...

everything is working and I have learned so much again. Thank-you Skip

Skip, I have your code entered exactly as you have shown, now what? How does the macro run? How does the Userform pop up and display ENGLISH or METRIC? I am following your example and don't know what's supposed to happen next.

This there not a Load frmUNITS and frmUNITS.Show somewhere?

Skip, I truly appreciate your commitment to total satisfaction. While I am not an expert by any means I think I can get basics done and certainly copy your code. Have you tried this Excel 2010? I gotta tell you, once again, that when I put (UNITS As String) after Sub Data_Change and save...

Skip, Thanks for your assistance. I am trying to pass the name of the command button back to the main sub so I can make decisions

Maybe, but that gave me a compile error on Data_Change. I just changed, again, everything that works to your suggestions and get the same compile error. When I enter Data_Change(UNITS As String) the macro disappears from Excel 2010. While you may have provided support it did not work in Excel...

its more like I can't the pieces of your suggestions to work. It seems as though you feed cryptic examples never telling anyone where to insert the suggestions. I do not mind being made to try but time does not allow for reinventing the wheel. You helped alot with the command button click...

I have this working quite nicely but I can't detect when the METRIC command button is clicked, any ideas. (I really don't want to change too much logic because things are working. Elegence, efficiency and execution time are not a concern so please help me get past this current hurdle of...

Sub Data_Change() resides in Modules and is named Module1 Private Sub CommandButton1_Click() resides in Forms and is called frmUNITS Private Sub CommandButton2_Click() also resides in Forms and is called frmUNITS If this is still not what you are after then maybe you might have to spell it...

VBAProject (ISOKINETIC.xlsm) Microsoft Excel Objects Sheet1 (NOTES) Sheet2 (RUN 1) ThisWorkbook Forms frmUNITS Modules Module1

The Module and Forms and listed under the VBAProject (ISOKINETIC.xlsm)