shell

Hello All, My First Post but trust a freaking long time user. :) OK so this is a new one for me and I always seem to get the fun stuff. I have a simple Excel VBA Workbook program that has worked fine up till now just using its internal calculations. However, recently a rigorous program...

Dear All, I want to open a notepad file from my excel file, paste a range of cells from my excel file to the current notepad file, name the notepad file same as my current file name and ultimately save it on either Desktop or the same path where my excel file exists and close the notepad file...

I need some help for my excel vba program. I use ShellRun code to execute external program (***.exe) Public Sub ShellRun(sCommandLine As String) Dim hShell As Long Dim hProc As Long Dim lExit As Long hShell = Shell(sCommandLine, vbNormalFocus) hProc =...

Hi! I've the following task: For about 80 people I've to create something that follows: - who is on break at the moment - who would like to go - notify a user if he/she can go to take a break, if the user can't react to this notification it should timeout (disappear) Unfortunately I have no...

I am new to excel macro and VB, pls bare with me. I have remedy ticket numbers(eg , HD0000001006530) in one column. I have to create a hyperlink on each cell referencing to itself.Cliking the hyperlink will run a macro. The Macro have to create a file of type .artask with content like below and...

Hello, I am trying to adapt this code, which reads shell output. There are many different approaches how to do it, but this one adds unique feature - Excel does not hang while it waits for the console program to complete its execution. But I don't understand how to get the response. Here is my...

Hi all This is really a DOS/Command Line/Shell question but it's being run out of VBA and I know this forum better than any other. I need to add a file to a zip file. I have working code that does this using SHELL() the below: "C:\Program Files\Winzip\winzip32" -min -a...

I am stuck...obviously. I was tasked with gathering some data on a long list of companies for my supervisor (I'm a grad assistant) from a messy website (i.e. no specific URLs for each report). I wrote a "simple" program to open internet explorer, navigate through a disclaimer page, change the...

Hey guys, This is my first time posting in the forums, so I hope I'm in the right place. I'm writing this program using VBA in Excel 2007 and am somewhat experienced in VBA. I'm trying to give the user of the program an option to browse a folder, select the excel file that they want to open...

Hi all, How can I close Notepad from VBA and overwrite the file with UTF-8 encoding? ATM I'm using Shell "Notepad.exe" & filename, 1 to open the file the file are encoded with ANSI, I want to save it with UTF-8 encoding, how can I do that? thanks Anders

I am fairly proficient with writing excel macros. I am not familiar with what is called "shell commands". I am not able to find any reference to this subject as applied to excel macros/vba. please show me the path. I have both 2003 and 2007 versions of excel and my os is windows xp

I need to open one or other exe file if it is installed If the PC is 32 bit the file will be in C:\Programs Files\myfolder\filename.exe If the PC is 64 bit the file will be in C:\Programs Files(x86)\myfolder\filename.exe So far I have tried a combination of the following using the Shell...

I have a macro that changes a few text lines in a file called LREAD. It then calls an executable that uses LREAD to generate an output file called LWRITE. Many files have to be analyzed by the executable so I have set this up to run by itself and copy LWRITE files over to another drive...

Hello all, I am trying to use my program to set up an ODBC connection on the user's computer. I am trying to make it more user friendly for the other people that may want to use my file in the future, and it entirely depends on this database query. Below is some code that I tried for...

I am trying to invoke a shell function with three challenges - the path to the executable (vlc portable) is variable as it runs from a usb drive causing the drive letter to change; the file names passed to the executable (audio and video media files) are stored in a cell that has a...

Problem in running dtexec command with multiple parameters in macro:- ------code in macro----- Dim Rsvr As String Dim Runm As String Rsvr = Sheets("update_xml").Range("C6") Runm = Sheets("update_xml").Range("C7") ' MsgBox Rsvr ----value= Hi ' MsgBox Runm ----value= Hello Call...

I created a form in Excel made to calculate a customer's financial savings by entering their information in text boxes and clicking a macro button which calculates everything on a seperate spreadsheet. I did not create the form using VBA. Just using cells and macro buttons. I want to make...

Hello, I have a macro that normalizes a data file in excel for upload to a web server. Ideally I would like something light like notepad to open as the macro is running and print out directions/steps for the user to take after the macro completes. for example... "This file contains x amount...

hello, i'd like to run a batch file in cygwin. my script is: Sub test() Shell "c:\cygwin\bin\bash /K c:\test.bat", vbNormalFocus End Sub but this doesn't work. the cygwin window opens then immediately closes without running the batch. (and no, i can't run test.bat in cmd.exe because it...

Howdy, I'm in the process of building a user form that required the user to brows for a file, the path of the file that they select is then displayed in the textbox next to the "browse" button in my form. I also have another button next to this which when selected will open the file that is...