Recent content by yarondavid

The following code still doesn't work: Call Shell("cmd.exe /K t:" + SendKeys("ENTER"), vbNormalFocus) I get a Compile error message

Hi I want to send and "Enter" key to the cmd window from VBA script I use the following line in VBA script, but it doesn't work: Call Shell("cmd.exe /K t:" + Chr$(13), vbNormalFocus) Thanks, Yaron

Hi I want to send and “Enter” key to the cmd window from VBA script I use the following line in VBA script, but it doesn’t work: Call Shell("cmd.exe /K t:" + Chr$(13), vbNormalFocus) Thanks, Yaron

Hi I want to send three commands into the same cmd window for e.g.: 1. Change the directory to t: and send “Enter” 2. Run a specific command line (like: "setbaseline.exe -component cpss_qa_tests -stream dx_01 -baseline DX_01_058 –noprompt") Thanks, Yaron

Thank you very much, it works !!

Yes, I use the following command: Call Shell("cmd.exe c:\Temp\C-env_scan\c_env_wrappers_coverage.py", vbNormalFocus) I want to open the Command line and run the script python "c_env_wrappers_coverage.py", but the script dosn't written in the Command line

Hi I want to run a python script from VBA code, but I don't know how to do it. Thanks, yaron

Hi I have some rows which are in MergeCells. I want to know how can I delete all the rows that are Merged Thanks

Hi I want to know how to run a VBA macro from batch file The following code in batch file does't work: cd c:\Program Files\Microsoft Office2003\OFFICE11\ excel.exe "G:\Pss\C-env_tests_CPSS_APIs_coverage.xls" Thanks

Hi, I have a VBA macro that run from other excel sheet (I add a 'Custom Button' in the Excel's menu bar). But when I run the macro from "target" sheet, an excel sheet that contains the macro in ThisWorkbook, is also opened. How can I automatically close the "source" excel sheet which contain...

Thanks bartrein It's work good Yaron

Hi I want to know how to insert an If statement that check if the specific cell contains a Validation type or not. I get an error message with this statement: If Range("B3").Validation Then End If thanks, Yaron

Hi I want to know how to insert an If statement that check if the specific cell contains a Validation type or not. I get an error message with this statement: If Range("B3").Validation Then End If thanks, Yaron

I use the ShellExecute function from shell32.dll lib and I don't know how can I insert a Hyperlink into Email In my part of macro I want that Path string (in line 14) will display as Hyperlink in the Email ================== 1. Private Declare Function ShellExecute Lib "shell32.dll" _ 2. Alias...

I don't know how I can insert the texts from few cells into array(i) by Excel macro script. In my part of Excel macro, I want to take some text from cells in column A from my "Summary" sheet and insert them into the elements of 'PlatformNames' array. Dim PlatformNames(1 To 20) As String With...