shell command

I am very new to VBA and have been learning as I go on a work project. One of the things that was requested was to have a search bar to find other files of a similar problem solving event. What I want to be able to do to have a vba program that opens file explorer and searches by tags. but all...

Hi I've having trouble with the VBA shell command. I can use the basic command to launch a file directly from VBA and obtain the task ID. E.g., ProgID=Shell("C:\addressofprogram.exe ""C:\addressoffiletobeopened.doc"""), vbNormalFocus I'm sure this is simple. However, I can't work out how to...

Hi, I am thinking of incorporating the ROBOCOPY with excel since I am doing a lot of file transfers. I just have no idea where to start. I would like to be able to enter a source and destination path into a cell then maybe some radio button or any kind of selection depending on what specific...

Hi there, I have a script which interacts with excel and does some "stuff" - I now want to create a macro which will use this script and do some other "stuff" after it is completed. Can I create a module which will call this script to run? The script name is - missingprice_check_v4.sh and is...

hey guys im new here, i started using VBA on Excel a couple of days ago, so still a beginner but trying to apply experenieced codes lol. i Need help with the code im trying to write. i want to use the function "Shell" to open a camera Software 4 times, i have 4 connected cameras...

Hi, got my code all set up but require a dynamic shell function when calling notepad. Currently it is as below (which works fine): Call Shell("notepad C:\Users\Shudarstaran.Neel\Desktop\DummyTest.xml", vbNormalFocus) I would like it to be dynamic and work like below...

Hi, I want to be open Windows Explorer and select (but not open) a specified file (like a show in folder command). The file is on a USB drive and I'm asking the user to enter the drive letter in a cell. Cell D1: Drive Letter. Example: E Cell E1: Folder: Example: \MyVideos\ And the...

Hello, I am a very beginner in VBA and need to convert lots of unix files to windows file on windows computer. I could do it in Command Prompt by TYPE input_filepath & filename |SORT > output_filepath &filename . I am wondering if I can do it in VBA writing a loop? Any suggestion...