Open Excel With Command-line Switches?

Sep 10, 2009

how to open excel with switches using vb.net, similar to what "Run.." does in Windows.. eg: this is what you would put in the "Run" ComboBox : excel.exe /r "C:ook.xls"

View 1 Replies


ADVERTISEMENT

Command Line Switches - Keeping Command Window Open?

Feb 24, 2010

I am using the following code to run defrag and to analyze if the C: drive requires defragmentation:

Dim analyze As Process = System.Diagnostics.Process.Start("C:WindowsSystem32defrag.exe", "C: /a /h /u /v")

This process runs through analyzing, runs it in normal mode & prints the progress to the command window.

My problem is that as soon as the process is complete the command window closes. I need it to stay open so that I can read the results.

View 3 Replies

PathName In Shell Function With Arguments And Command Line Switches

Jul 10, 2009

I'm using VB2008 Shell function to execute file with arguments. But I'm not sure how should look my PathName in Shell function with all necessary arguments and command-line switches. Without arguments: [Code]

View 4 Replies

Give The Form A Command When User Switches To Another Application?

Apr 20, 2009

let's say i have this application running, preset size. and there are other applications, like, firefox, vb, etc. in the background where i can click on them to bring them to front and use. now, when that's done, i'd like my application to minimize by it's self instead of just becoming a application that got sent to the back of another one.. the minimize is just to get me started, since i'll probably resize it to a button or so.just a squirrel looking for my nut...

View 4 Replies

How To Open Multiple Files Using "open With" Command Line Arguments

May 15, 2012

I have an application that can read certain types of files, and I have it working so that if you do "open with" from windows, it automatically starts the application and opens the selected file.

Unfortnately, I cannot get it to work for more than one file.

System.Environment.GetCommandLineArgs() contrains the following:
System.Environment.GetCommandLineArgs(0) = name and path to the .exe
System.Environment.GetCommandLineArgs(1) = name and path to the first file selected to be opened

System.Environment.GetCommandLineArgs().Length is 2 when the user tries to open 1 file, which makes sense since the first argument is the .exe itself and the 2nd is the path to the file, but it does not increase to 3 if the user tries to open 2 files... meaning that System.Environment.GetCommandLineArgs(2) is never populated Here is some sample code that shows the problem: It will recognize no files or 1 file being opened, but if you try to open multiple it will only show the first.

[Code]...

View 1 Replies

Open An Excel 2007 File Using A Shell Command?

May 13, 2011

i am trying to open a excel 2007 file using a shell command in visual studio .net 2008 from a button object but it says "File Not Found" even though I created the file and put it into the same folder as the application.

View 2 Replies

Command Line Argument: Check If Correct Command Line Or Exit App?

Jun 6, 2012

I have beginner skills using VB (am using the Express edition to learn). I would like to know how to set up a conditional statement in a Windows Form (WF) app that would check if a specific command line has been passed by another separate app that launchesthe Windows Form app using command lines, and if not passed, then the Windows Form app would shut down (exit, close).So far, I can use:

For Each s As String In My.Application.CommandLineArgs
If s <> "xyz" Then
Me.Close()

[code]....

View 14 Replies

Send A Command To A Command Line And Then Submit The Command?

Apr 30, 2010

First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.

I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:

Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _

[Code].....

View 6 Replies

VS 2008 Open A Txt File, Read Line By Line, Decode Each Line Into An Array And Display?

Oct 14, 2011

what i need to do is open a txt file, read line by line, decode each line into an array and display. Now all works ok apart from one line.

sTextLine = objReader.ReadLine() <-- Value of string cannot be converted.

full code here
-------------
Dim objReader As New System.IO.StreamReader(sOpenFile.Text)
Dim sTextLine As New ArrayList()
Dim sText As String = ""
Dim i As Integer = 0

[code]....

View 3 Replies

Send Command To Command Line From Windows Form Application?

Mar 11, 2010

I am trying to send a command to the external command line (cmd.exe) from the Windows form application that I'm writing in VB.NET (using VS2008).

I can only access the external program thru the command line (its not my program) and I must do so from a form app.

I am trying to use the following code. I am able to call a cmd.exe window, but I can't pass the command line my command.

Using mp As New Process
With mp.StartInfo
.FileName = "cmd.exe"

[Code].....

View 8 Replies

Command Line Program To End Before Moving Onto The Next Command In Loop?

Feb 4, 2011

I am using a CheckedListBox that is populated with Filenames (full path, i.e. C:TestTest.jpg)When I have the files that I want in the CheckedListBox I wish to click a Start Button which will process the list one at a time using an exe program that runs on the Command Line. There are arguments that need to pass to the command line as well as the file location in order for the program to process.I currently have it working but the issue is the loop finishes quickly and it is left up to the CMD.exe to finish the process. What I would like is for the LOOP to wait until each file completes processing before passing the command for the next file in the CheckedListBox.There some reasons I wish for it to work this way.

1) I would like to have a button that can Pause/Restart the Loop.

2) I would like to have a button that can Stop the Loop so the whole process can end.

3) I would like to have the Loop remove each file one by one from the CheckedListBox after it has been processed.

4) I would like to display a Message once all the files have been processed.

5) And if it were possible I would like to report the status either by text or a progress bar showing where it is at in the process.

6) And the ability to add some error handling if possible.

Since the Loop finishes so quickly as it just passes the command to the command line using the & as a seperator it is the command line that is handling the rest of the process. Because of this there is not control over it in the GUI.The code I am using allows the Command Line text to display in the Form so it won't open up a seperate window to run CMD.exe. This is the desired affect as I would like everything to appear to run from within the Form itself.

[Code]...

View 6 Replies

.NET - Pass Command On Command Line?

May 29, 2012

I am struggling to pass a parameter to a VB.NET application via a Windows scheduled task. It works perfectly in Visual Studio (passing a command line arguement via project properties).If I am calling a VB6 application, then I will supply the following parameters and it works:

Run: c:progra~1TestTest.exe TestParameter Start In: c:progra~1Test However, if I supply the same parameters in VB.NET, the program throws an exception when it tries to create an instance of a class in the Form.Load: System.NullReferenceException cannot create instance of object.

I have also tried the following:Run: c:program filesTestTest.exe TestParameter Start In: "c:program filesTest" This time the status of the scheduled task changes to "cannot start".What is the correct way to specify command line parameters in a scheduled task for a VB.NET program?UPDATE I found the solution on this web page:[URL}.. I am still confused as to why the program would not create an instance of an object when I used the 8 bit paths (i.e. progra~1)

View 1 Replies

[2005] Can't Open Excel File By Using XlApp.Workbooks.Open?

Feb 11, 2009

I would like to open the excel file after create the excel file. The creating file function is done, but the system unable to open the excel file. My coding as below:

Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim misValue As Object = System.Reflection.Missing.Value

[code]....

View 1 Replies

Open Command Prompt And Run The Command "netstat -a"

Oct 2, 2011

I'm starting to make a program that will run some commands, so i need some code that will open command prompt and run the command "netstat -a".

View 11 Replies

Export A Datagridview To Excel And Open The Excel Spreadsheet (not SAVE The Worksheet)?

Jan 10, 2012

I'm trying to export a datagridview to Excel and open the Excel spreadsheet (not SAVE the worksheet).

Public Sub ExcelRpt(ByVal DgvName As GridView, ByVal url As String)
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet

[code]....

View 1 Replies

App That Opens Excel Visible Then Another Button_click That Writes To The Same Open Excel

May 11, 2012

I have a VB.Net App that on ButtonRun_Click open Excel to get the "tab" and "column" then another buton that past content from textboxes. I get a "COMException was Unhandled" If I reopen excel it's in use.

Private Sub ButtonRun_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonRun.Click
Dim MyExcel As New Excel.Application

[Code]....

View 3 Replies

Open Excel File And Reusing Existing Excel Instance?

Jul 13, 2010

I have an application the contains several excel files bundled with it. I'm not opening the files and processing them within my application. These files contain a data-connection to reload all of the pivot-tables within each excel file. I have a 'link' on my form, that when clicked, it determines which file to open and calls a sub using filename and executing Process.Start(filename) for any excel file I want to open. I have no problems opening any one of the files and then exiting excel.

The problem is when I 'close' a file, but don't exit Excel; then try to open another file(clicking link on form)... it creates a new instance of Excel.

I know from experimenting that the fileopendialog form will 'reuse' an existing Excel instance, IF it does not already have a file open.

How can I do the same thing without using the fileopendialog?

I don't want the end-user to have access to the folders where these files live. That's why I have multiple 'links' on my form, one for each xls that already exists. I just want them to be able to click on a link and the xls file opens AND if they choose to merely 'close' a file and not exit... Don't create a new instance of Excel, but re-use the existing one.

View 5 Replies

Took Oledbconnection With Excel File But Unable To Open That Excel Manually?

Mar 10, 2009

I took oledbconnection with excel file, after disposing this connection i m still unable to open that excel manually,It shows some access error.

View 1 Replies

Run A Command Line EXE From .NET?

Mar 3, 2006

I want to run the following command line program from VB.NET: rotor95.exe -d -k "password" -i "C:FileLocation" -o "C:FileLocation" The reason for this is that I don't want my users to have to drop out to a command line prompt in order to run a tiny program for 3 seconds. Typing in a 50 - 75 character file path twice isn't any fun either.

I tried using tooltask as discussed in the MSDN2 help but it appears to work with switches (/d etc.) but not parameters (-k "password"). I couldn't get the thing to work. See the following for the tooltask example:[URL]..light now I'm just using Shell("rotor95.exe -d -k "password" -i "C:FileLocation" -o "C:FileLocation") which works just fine but I'd like to use the .NET 2.0 super-whammy version of handling this problem if there is a better way to do it.

View 3 Replies

Using FTP Over The Command Line?

Sep 19, 2010

how to use basic FTP functions straight from the command line tool. and I started using Visual Studio to create "macros" for the command line tool (i.e. writing down specific functions to perform, write them to a txt file and then run Shell() to execute.)But what I want to know is if I can open a command prompt window and then interact with it. Say for example I'm writing an FTP class/object, I'd want to be able to keep a window up for my program to send commands to (And wishfully read data back from it.)Because it seems to me that whenever I use the Shell() command it just opens a prompt window and then closes it after my line of code has been executed. Is there way to interact with a command line window from Visual Studio? And maybe even scrape data from the terminal like with terminal emulator scripts?

View 1 Replies

.net - How To Use Command Line Arguments

Aug 22, 2011

I have a console application which reads .txt files. I want to be able to drag a txt file over my app and it would automatically open my app and show the text files contents. I think I have to use command line arguments like this:

Sub Main(ByVal cmdArgs() As String)
End Sub
Sub ReadFile(FilePath as String)
End Sub

But how can I pass the text files path to my ReadFile sub?

View 1 Replies

Allow Application To Be Run From A Command Line?

Jul 8, 2010

OK! I've written my application in all it's GUI glory. I now just want to be able to run it from dos/a command line/batch, with no GUI appearing? So it just runs (& does its batch process).

How can I detect if my application has been initiated from command line/dos?

How do I then not open up the application and show its GUI etc?

View 35 Replies

Command Line Variables?

Dec 9, 2010

Printing Work Orders from with in a .NET scripted screenSummary of code:

Public Overrides Sub onload(ByVal e As ScriptonloadEventArgs)
Dim CWONO As String
SetValue("CWONO") = "WO_Number" '(This field is automatically created with previous code)

[code].....

View 3 Replies

Compile In Command-line?

Mar 9, 2009

I was wondering if it's possible to create a .vb source file from notepad and be able to build/compile from the command line without the need of a vb environment?

View 1 Replies

Get Another Application Command Line?

Jun 7, 2011

is there anyway to get the another application environmenat commandline argument

View 1 Replies

Get Forms App To Run Like Command Line App?

May 3, 2011

I have a forms app that contains a few forms. My task is to make it run invisibly when called from the command line with arguments.I have defined a Sub Main in a module and made it the startup item. I have an if/then/else that looks at args.length and if it equals 0 then I load the form and run the app normally. But how do I handle things when args are passed? I still need access to all the functions defined in my main form. Can I load the form invisibly and still "use" it?

View 14 Replies

Getting Command Line Arguments ?

Feb 8, 2010

When you open up a .txt file, the command line opens up notepad.exe with the argument %1. which opens the text file. i dont know about the function but i understand a little bit about it.

So what i wanted to do was create a .lxproj, and make it open up with my application. i have done this part so far with an installer that creates registry keys. but, what i would like to know is how to open the file. for a test i would like a message box to be displayed if the program is run by clicking the .lxproj. if its opened normally the messagebox doesnt display.

View 5 Replies

How To Execute A Command Line

Aug 2, 2011

I am making a console application that will be prompted from a cmd. I want to be able inside my application to start an other program. Here is the line I am trying to use: %SystemRoot%Microsoft.NETFrameworkv4.0.30319MSbuild.exe /p:Configuration=Release test.shfproj This is making Sandcastle Help File Builder create a documentation with the test.shfproj i've builded previewsly.

[Code]...

View 2 Replies

How To Use Command Line Parameter

Aug 25, 2009

I want to create a shortcut that do following:Link back to "my application"with command line parameter so that it will not do anything.

View 4 Replies

Read From Command Line?

Oct 3, 2009

I'm making a program that has to execute commands in cmd.exe, but without actually opening it. I set RedirectStandardOutput to True, and I need a way to read the result of the command from the stream. Right now, I use ReadToEnd(), but there's no end to the stream, apparently. How do I read the result of the command?[code]...

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved