shell

  1. J

    Shell for non .exe Files

    Hello All, So I currently am trying to open from VBA, an output file of a macro recordercalled tinytask. I am able to sue theshell function to open the macro recorder itself using the below: Sub TinyTaskCallExample() DimstrProgramName As String Dim strArgumentAs String...
  2. wadergirl

    Macro to open another program - shortcut target has a command line switch

    So, in my spreadsheet, I have an existing macro that uses: Shell ("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe") So I'm pretty sure that it is the base of what I need to use for this other program, but the other program I need to use a shortcut which has a command line switch...
  3. M

    Excel - running a cmd line from a cell to cmd/powershell

    Hi, I have a cell with a command on it and would it be possible to be launched to cmd or powershell? I encountered this function, PID = Shell("notepad c:\MyFiles\TextFile.txt", vbNormalFocus) but I am not sure how would this launch to cmd or powershell. How would I incorporate the cell with...
  4. C

    Malicious Macro Detected When Using Shell Command

    I am trying to create a code that could open a .pdf file via Adobe Acrobat by using Shell command method. However, i keep receiving an alert saying "Malicious Macro Detected" and my excel file shuts down itself without saving. After some debugging i realized it is the shell command that...
  5. C

    Use VBA to run/terminate Shell command and save file

    Greetings! I have a shell command that uses curl to capture live audio output from a port on our call server. Sub RecordAudio() Call Shell("cmd.exe /S /K" & "curl 92.68.0.10:8888 > i:\voicetemp\voice.wav", vbMinimizedFocus) End Sub What I would like to know is; 1) how can I stop the...
  6. UniMord

    Suppress Sizing Handles on "Packager Shell Object" icon

    When embedding a file as a “Packager Shell Object”, I’d like users to be able to click the icon without the sizing handles displaying. Is there any way to prevent the handles from appearing?
  7. S

    Search and Replace close matches

    Hi, I'm importing data from our credit card bills. I want to bring the data into our accounting system. We have an issue when the names are not always the same. IE Shell 1234 and Shell 4354. I would like it to load it to the name Shell. Or Amazon charge of Amazon, Amazon Direct or Amazon...
  8. D

    Open windows explorer to a folder

    Hi, I have this hard wired code to open a folder called Comm. It works perfectly. Shell "explorer.exe ""C:\Users\Pas\Comm\", 1 I have this full folder path recorded in cell A1. Just to make it a bit more flexible, I loaded this value to a string variable and execute the same script to open...
  9. M

    Shell command: Error 5

    Long time that I played with the Shell command. I keep getting Error 5. I think that it is related to some space included in the path, but can't find how to resolved that yet. The goal, start and external application when my Excel file is opened. Private Sub Workbook_Open() ' Setting a...
  10. L

    Retrieve Unique Tag Metadata from a folder and its subfolders

    Guys I would like your support on how to retrieve all TAG metadata from files that are saved on some folder including its subfolders. The idea is list all Tag Metadata as unique values in a txt file. Unique because it can be repeatable due the loop will check on different files. Below an example...
  11. M

    Excel 2010 Shell does not close completely

    This has started in the past month or two: I have a workbook open, only one. I close Excel using the X in the upper right hand corner in the outer frame. The open workbook closes but leaves the shell open with no workbook. Some notes: This used to close the shell as well as the workbook. It...
  12. azizrasul

    Using Shell

    I am trying to merge 2 win2pdf files (pdf1.pdf and pdf2.pdf). I have been given the following command line to create the merged file called pdf3.pdf. Is there a way of using Shell to do this? I tried the following which didn't error but didn't do anything either...
  13. M

    Excel VBA - Using Shell to Open a TXT file in Notepad that Begins with the First Part of the Filename?

    I have a macro which uses Shell to open a TXT file in Notepad. I am trying to get this macro to work with opening a TXT file in Notepad beginning with the first part of the filename; I have listed below my two attempts to have this work (MacroAttempt1 and MacroAttempt2): Sub MacroAttempt1() Dim...
  14. B

    Using AppActivate to switch to other software that is open

    I'm trying to get Excel to switch over to a completely different software that has a title that is difficult to capture....and as you may know AppActivate needs the exact title to do that. I need a method that captures the full title name and passes the string to AppActivate.... This part...
  15. D

    Synchronously execute a shell with a winscp command - VBA

    I have currently this code: Call Shell("("C:\Folder\WinSCP\WinSCP.com /ini=nul /script=""C:\Folder\WinSCP\Remote2local.txt"" ", vbHide) Application.Wait (Now + TimeValue("0:00:10")) Rest of the code ... The problem with this code is that if the computer is slow, it will...
  16. C

    Excel VBA Upload with FTP

    Hello every one! Using Excel VBA I am trying to upload files to a server. In order to do so the macro creates a command-file called 'FTP_batch.txt' and when the subroutine finishes, it kills that file again. When I run the command prompt and copy/ paste the commands from the 'FTP_batch.txt'...
  17. C

    retval = Shell("excel.exe """ & filename & """", vbNormalFocus)

    Hi all! Is there any way to choose a sheet in ???? I need to open another excel file with "shell" in a specific sheet. Thanks
  18. P

    Shell cmd window position?

    Is there a simple was to control the position of the cmd shell window. I am using this to position userforms and popups(msgbox) and this works well. ' Simple "with" to put Userform in centre of monitor when I'm using 2 monitors With MYUSERFORM .StartUpPosition = 0 .Left =...
  19. J

    Help with shell command on paths with spaces

    Hi all, I'm really struggling to workout this shell command on paths with spaces in them. The code below works with no issue, but as soon as I uncomment the long path with the same set of 20 zip files, I get an error (Error: cannot find archive). I feel like I've tried an infinite number of...
  20. andrewb90

    Attach current excel file to email sent using CDO

    Hello all, My question has multiple parts to it. Basically, I already have my CDO code and functions that can send emails and attach a pdf of different sheets. What I am looking for is: a) a way to locate the file location that the current workbook is in. b) add that file location to my cdo...

Some videos you may like

This Week's Hot Topics

Top