shell

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

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

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

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

Hi Gurus, I have a folder full of pdf files which have similar template. I want to copy the data from each of these files into separate sheet of a workbook. I have extracted the list of files and file paths in the workbook and tried to run this macro My predicament is that this macro only...

My goal is to get file sizes for XML files located in a ZIP folder. I have changed an Excel file’s extension to “.ZIP” and I am trying to only extract the .XML file names. FYI, this may only work on new versions of Windows and Excel. I am using Shell.Application to extract the file names. My...

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

Hello, I have the following code below: Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Dim URL As String On Error GoTo error4: URL = Me.ListBox1.Column(5, Me.ListBox1.ListIndex) Shell "C:\Program Files\Internet Explorer\iexplore.exe " & URL, vbNormalNoFocus Exit...

Hello guys! I made a C++ .EXE program that generates in a txt file points of a Fourier series of a given function. The program is working just fine. It generates the data and I can, manually, import these to excel to create the charts. Marvelous. The problem is when I try to automate the...

Hello guys! I made a C++ .EXE program that generates in a txt file points of a Fourier series of a given function. The program is working just fine. It generates the data and I can, manually, import these to excel to create the charts. Marvelous. The problem is when I try to automate the...

I am trying to parse specific measurements contained in some 3500 PDF files so they can be graphed and trends can be analyzed. The problem is that sometimes my code can loop runs 30 times before I get the "There was an error opening this document. This file cannont be found." from Adobe...

I have been attempting to execute the following DOS command via excel vba cmd net user KERRS1 /DO >C:\DATA\RJR\users.txt Dim RetVal RetVal = Shell("cmd net user KERRS1 /DO >C:\DATA\RJR\users.txt", 1) although it opens a dos window but does not execute the net user command. Any...

Via VBA, I am trying to run an executable that has parameters and a file name. Dim strProgramName As String Dim strArgument0 As String Dim strArgument1 As String '//This is the executable strProgramName = "C:\Dir0\Dir1\Dir2\Dir3\MyExecutable.exe" '//These are the required parameters...

I am currently developing a tool for a client that interfaces with both python 2.7 and excel 2013 and as a result running into a problem. As background, I have a python code I want to run as a executable. The client doesn't have python on their computers so it's vital that the exe runs without...

Hi All, I am wondering how to use the Shell feature in VBA to call a terminal (using mac), then run a perl script called read_scalepack.pl on a log file that I have chosen using GetOpenFileName. Right now I am just using Terminal to issue the .pl script (its parsing a log file) and then...

I have an excel application that is relying on data from a Navision report being run every month on a specific time. Today this is done manually, but I would like to do this programatically ie trigger a macro to run this report. Is it at all possible to run Navision reports and retrieve data...

Hello again forum, I am working on a VBA routine that calc and verifies hash files for a series of folders and sub directories, using a command line prog called exactfile.exe (exactfile.com). It is very similar to M$'s FCIV utility, but it is actually supported on Win7/Win8. The issue I am...

I'm relatively new at VBA, and I am developing this excel based tool that creates two .xls files, whose paths are saved in two variables. The next step is the user has to select these two files, right click and select an application called Compare. I was wondering if this process could be...

I have a WinForm, which I'm calling via VBA's Shell command: Sub Button1_Click() Shell "C:\\TemplateFuncitons.exe " + ActiveWorkbook.FullName, 1 End Sub I made this module an Excel Add-in and added it as a button in the quick access toolbar. Now, the idea is for the WinForm.exe and the...

I need to 1. launch cygwin from VBA, 2. run an executable with inputs and 3. wait for it to finish. I have had success doing steps 1 and 2 OR steps 1 and 3, but cannot figure out all 3. For steps 1 and 2: ReturnValue = Shell("C:\cygwin\Cygwin.bat", 1) SendKeys "S{ENTER}" (this is only one...