Search results for query: *

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...

This is the source text file: ============================== @rem Reads the config spec info @if "%CC_CURRENT_COMPONENT%"=="chip_simulation" goto set_chip_sim_user_base set USER_BASE=X:\pss\SW\prestera goto set_user_base_done :set_chip_sim_user_base set USER_BASE=X:\simulation\chip_simulation...

I used this script for help but I still have a problem, the two next lines in the file are also deleted This is my part of script ============================== string envBaseFile, LineInfo integer Len=0 long Pos=0 strfmt envBaseFile "%s\envBase.bat" CopyRelFolder fopen 0...

I want to know how I can replace a searched line in the Text file with other line string. I mean to delete a specific line that found in file and insert my string instead of that line.

I don't know how can I scroll on Aspect script file via Mouse Wheel.

I use a part of ASPECT script to unzip my zip files via PWZIP.EXE. The uncompress action is work fine and all directories are unzipped but the files that are located in those directories are not extract so I didn't see the files after the uncompress action. This is my part of script: strfmt...