Search results for query: *

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)

:o) You just ask something that I am totally not sure about. I think they are stored within the speific workbook project but you may have to tell me how to know and where to look. I just typed in the macro a second time from scratch and get the same symptoms.

Skip, I tried this from yesterday's reply but it seems to mess up EXCEL and MACROs. I am using EXCEL 2010 and when I make your change then go to RUN the MACRO no macro's exist. I tried it again this morning with the same kinda results. I also can't STEP INTO the MACRO after I make that...

This is what I have but a compile error coming from Data_Change that I am now trying to fix. The compile error is: "Wrong Number of arguments or invalid property assinment" Sub Data_Change() Dim UNITS As String Load UserForm1 UserForm1.Show ' 'STACK DATA FIELDS ' Select Case...

I am trying to create a dialog box that has just two command buttons - ENGLISH and METRIC. I got the box and the buttons working but clicking on either button fails to exit the sub and then I am not sure how to pass the clicked button's value back to my macro that is nothing more than a bunch...

Fumei, I am glad you said that - I can not seem to get macro recorded when I used tables. If I start outside the table I can not select anything within the table, if I start inside the table I still can't the mouse to control or highlight cells. I have learned alot from recording macros but...