I need to open a .xlt for editing, like so:
System.Diagnostics.Process.Start("Template.xlt", "Editable=True")
But I don't know the correct switch in Excel. This is the same as right-clicking on an .xlt and choosing "Open", whereas the default action is "New".
This is simple to explain, i need to track the process id from the files I execute. So lets look at the code.For this example just create 2 files in the C: and call it 1.xlsx and 2.xlsxNow open the firts file ...
Dim objFileExecute As New System.Diagnostics.Process
objFileExecute = Process.Start("C:1.xlsx")
MsgBox(objFileExecute.Id)
[code].....
I am trying to open a word template inside a form in my vb.net application but I cannot seem to find any guidance to doing this. I do not want to call microsoft word to open in order to see/read/write on my template. I want the word document to be within a form I am creating like a print preview sort off. I am using Word 2007 and VS 2008. I have been using so far automation and calling and interacting with the template but until so far I have to open Microsoft word to open it for me.
View 2 RepliesI would like have a progress bar like Outlook 2007. when you click on a link in a message. you can see a progress bar between the ribbon menu and reading pane in outlook 2007.
Is it possible to have the same progress in Excel 2007?
I want the presence of a text file in a folder to trigger a printing software and print using a template I already designed..all this should be done as a serviced..i.e. in the background coz I don't want my users to know how I am printing.
View 1 RepliesI'm using Process.Start to start an external command line application and using the StartInfo.Arguments method to send parameters to the application. I imagine I'll need to use a loop... but I can't figure out exactly how yet.I need to send anywhere from 1 - an infinite number of files names to this application. Each file has to be sent one after the other. So once the first one is done, I need to loop back around and past the second one.I can probably use the Directory.GetFiles method to get all of the files, but I don't know how to assign them.
View 7 RepliesVisual Basic 2010 - Net Framework 4.0 Client
I have an application (application #1) running with Administrator privileges on Windows 7.
I want application # 1 to start another application (application #2) without Administrator privileges so application #2 is running as a standard user.
Is there a way to do this? I have been using Process.Start.
Here's what I currently have:
[Code]...
I've commented out various things to limit it to specifically this command (example, I can swap mklink out with notepad and it works fine). The command runs fine from a DOS window, but can't be found when I use it this way. I also tried using the SHELL command just to test and I get the same results. No idea why it can't be found, as like I said it executes from the command prompt just fine.
i need to generate an excel sheet from an excel template which contains drop down lists. I need to use the template and populate the with data from datbase and select the appropriate value from the drop down lists and generate the new excel sheet.
View 2 RepliesMy app starts an On-Screen Keyboard process like this:
Dim PID as System.Diagnostics.Process
:
PID = Process.Start("C:WindowsSystem32osk.exe")
:
[CODE]...
It seems to work 90% of the time. However, sometimes the PID.Kill() fails because it says the process already exited. At this point the OSK is always still there on screen. Yes, I know my code should be testing to see if the process is still running before trying to kill it, but given that the OSK is still on screen..
I have a program that starts another program after setting the regkeys basically the program continually syncs the calandar of outlook and another application.I set the regkeys than launch the c:sync.exe app. I have tried a simple process.start and launching the process as a thread and they both do the same thing: The other process starts and works as it should but my main program goes "White screen" or "not responding" until the process.start has exited.
I want the process.start to run in the background so if users click in my main app it responds and truly that they can access the context menu of my main app from the taskbar while the process.start is running.
Trying to create a button that when clicked will check to see if a certain process image is running and if that process is running give the process focus. If the process is not running then start the application.
View 9 RepliesMy website creates an email from an HTML template using MailDefinition and ending up with a System.Net.Mail.MailMessage object.
Usually, I just call the Net.Mail.SmtpClient.Send method and the email is sent.
Now I need to be able to open the created email in the clients default mail program and then they click their email programs send button to send it.
I am trying to pass a different template to a Telerik Grid, depending on if the add button or the edit button is pressed (on creation: a few field to fill. on existing: add button : some extra fields to fill, edit button : most field are read-only, new field to fill).
Dim myGrid = Html.Telerik().Grid(Of SomeModel) _
.Name("myGrid")
If Model.Action = AddNewData Then
myGrid.Editable(Sub(editing) _
[code]....
I have no idea on how to do the if "gridBoutonPushed = Add" then part.
Whats happening is I run the code below and get the following error "The system cannot find the file specified". I've read that with UseShellExecute set to false that you can't use WorkingDirectory.
Dim Password As String = "password"
Dim SecureStringPassword As New System.Security.SecureString
For Each c As Char In Password
[Code].....
How would I go about starting a new process without it being the child of the calling process.
Example:
Main Program (Caller.exe)
process.start("file.exe")
i use System.Diagnostics.Process.Start to run a process
example :
Dim p As New System.Diagnostics.Process
p = System.Diagnostics.Process.Start("D:ProjectApplication.exe")
it works perfectly during run time. but after i deploy to server.... this code did nothing, it did not call out this process
It gets some links in a listbox, And i had to create a new ListBox for because i only want to keep some items, So i got this.[code]But i had to do a new listbox for it, I dont mind that, But the problem is, It creates duplicates, I've tried making it delete the item from the first listbox after it was added to the new listbox, But it is not edible during the process structure so i thought i could get some help here because im getting so many Duplicates of 1 item.
View 8 RepliesI managed to export my data to an excel file, by using a excel template that I created beforehand. But I'd rather have that the excel file will be create when I press the button instead going to my file.
Dim ApExcel As Object
ApExcel = CreateObject("Excel.application")
ApExcel.Visible = True
[Code]....
I need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Diagnostics
Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
I am writing an application that in the end needs to execute another executable at some point, the problem is that the executable has dependencies in the directory it runs in that are required to operate. When I use the Process.Start to run the executable it errors out because it's looking for the dependencies in my applications directory.
I tried the startInfo.WorkingDirectory option but that didn't seem to do it either (not sure if I did it right) - here is how I used that:
Process.Start("my.exe").StartInfo.WorkingDirectory = "C:Test"For the life of me I cannot find how to set the "Start In" directory. I looked everywhere, so unless it's under a different name, I'm at a loss.
I have a an excel file that has been manually populated, and now needs to be automatically populated using ASP.NET, vb or c#. I've been looking around, and have found examples on how to export a gridview, and data to excel sheet, but not anyway to maintain the format of the original template. I've recently populated a word document using merge fields... does excel have anything similar? Could I break the file down into XML and use that as a template?
View 1 Repliesi make my textboxes to export data into an excel template....it works fine but there are few errors too..but i don't know how to fix it...here is my code.
Dim objExcel As Object
Dim objWorkBook As Object
Dim objWorkSheet As Object
[Code]....
for the objworkbook.SaveAs,it will always ask me to replace to file and i would like to use SAVE command...bu it not works..anything happen?sumore everytime i run this process,it will tell me the file is read-only while the setting doesn't shows that the file is read-only...and i have to go to task manager and end the EXCEL process by myself to run the process again
I have a program that needs to create a downloadable excel template with the following headers on the first row named, name, age, gender. And I also want the template to only have 1 sheet on it. How can I create a sample template using vb.net code?
View 6 RepliesI need to port a VBA app to VB.NET, there is only one problem excel won't save my template. Excel opens the right file and it shows me the save file dialog, only one problem it won't save any file, however it won't give me an error but won't return me the file path because it doesn't save the file anywhere.
[Code]...
How to print excel file form vb .net without opening excel?
View 9 Repliesi'm trying to save an excel file after I open my excel application. This is what I have so far:
'Opens the report
xlPeakDemand.Visible = True
xlPeakDemandWorkbook.SaveAs("C:Documents and
[Code].....
When saving as an xls it works fine but when saving as a htm its a disaster Just a bunch or symbols and stuff. BUT if I go into my xls document and Save As webpage from there, it works fine!
I am trying to create an app that will perform actions on specific times (much like the Windows Task Scheduler). I am currently using Process.Start() to lunch the file (or exe) required by the task. I am initiating a process by calling a file (an .mp3) and the process starts WMP (since it is the default application), so far so good. Now I wan't to kill that process. I know that it is normal behavior for the Process.Start(string, string) to return nothing (null in C#) in this case. So I am asking how can i close WMP when I called it through Process.Start(string, string)??
[Code]...
I have attached a printscreen version of my excel template here,
Now I just want to know, using vb.net code, on how can I import this data from a specific cell, including the header itself so I can insert it into mysql database.
I want to open a excel template with a browse button, the file needs to open and must be directly saved by the user. after the file is saved the file location needs to be displayed in a textbox.With this i can open excel itself, but i don't know how to open the template and save the document
Dim Xl As Excel.Application
Dim Filepath As String
Dim Workbook As Excel.Workbook
[code]....
The file opens and i get a save as dialog, but when i want to save the document it doesn;t save at all, However it won't give me a error.