Start In 2008 Express Existing Excel Application?
May 14, 2010How do I start in visual basic 2008 express, a existing Excel application? e.x test.
View 2 RepliesHow do I start in visual basic 2008 express, a existing Excel application? e.x test.
View 2 RepliesI am complete newbie to VB express. I have created a simple windows form that opens programs using menus and so on.Works great using the Process.Start on windows apps (word, excel, etc.) but I have some very old programs that run in DOS I am also trying to open that do not work when using the Process.Start method.
I am able to get the command prompt box to open up and in the title bar it shows the path of the .exe program I want to open but the actual program is not opening.
[Code]...
I've been in VB express for about tree weeks, formerly of VB 5 for about 10 years.
I need to open a form on top of the form of another application, that is, making the other applications form its parent. The title on the applications form can change, so searching for the form by name won't work.
I'm also curious, can you start a vb express application without opening its form? Like in Vb5/6 you could start in Sub_Main?
I recently installed vb express 2008 and with that download i also installed Sql server 2008. Earlier i have been working in MS Access so i have no experience in SQL server. My first problem is how to start sql server. I can see only following:
Start>All Programmes>MS SQL server 2008>Configuration Tools, Import and Export Data(32 bit)>SQL server configuration Manager,SQL server Error and Usage Reporting,SQL server Installation Centre. Moreover in Programme Files i have two folders:
1. MS SQL SERVER and
2. MS SQL SERVER COMPACT EDITION
how to start to create a database in SQL server with Vb express 2008.
how I can start a program with Visual Basic Express Edition 2008? I mean do you have any code I can use as a base to start another program? If that made sense.
View 3 RepliesI have an Excel template that contains numerous pre-defined charts and a program that opens this template and collects data used to populate the charts. This works great but I now want to adjust the series length so that the charts only used the data collected (not a range of 32000). I'm trying to iterate through the charts and determine the range for each series of each chart but not having much luck. The snippet below allows me to see the xvalues but does not return any information as to where this data is located. Does anyone know how to extract the range for each series in a chart?
[Code]...
I have made my application to start automaticly when windows start (registry ../currentversion/run/appname + path). In this mode the application start minimized and an little icon appear in the notification icon area. With this icon you can maximize the app or exit it.If you exit the app and start it again using the Menu (Start/programs etc) than the application start in minimized mode (and in this case I would like to have it in normal mode) because the setting autostart is still true.Is there a way you can detect when the application start when windows startup using the above registry or when people click on an icon in the programs menu (or desktop)?
View 2 RepliesI'm, following the tutorial on creating your first program in Visual basic. I'm instructed to start a new project, and select windows form application. When I hit okay I get the following error:"Could not load file or assembly 'Microsoft.Build.Engine, Version 3.5.0.0, culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified."
View 1 RepliesI have a windows 7 computer with vb 2008 express on it. it works really well, except only one thing. when I try to debug an application ( usually windows forms), it produces a run-time error saying: Error while trying to run project; unable to start debugging.
View 2 RepliesMy intentions are to add command line switching. I am trying to see if i could run my application in varoius ways i.e.
App.exe -S - Start the application in XX Mode
app.exe -T30 - Start application with 30 second delay
and that kinda switching.
I have recently released a free application for some game and now I have added a few features 'the public' requested.
I used Inno Setup to create the installer, which works just fine.
Now however, instead of having the ask the user to uninstall the current version, and then reinstall my new version, I want to be able to give the user an Update install exe which they can simply run and it will update the existing application.
One thing I would like is that the users Settings are not changed. So hence the following questions: 1. Where are the Settings stored? I thought it was in the user's Local Settings <Application Name> directory, but I cannot find my application there... I cannot find it in the All Users or Administrator 'accounts' directories either...
2. Are the Settings stored depending on the Version of your application? (Assembly Version / File Version)?
If 2. is true, then obviously changing the Application Version (which is logical in an Updated executable, no?) would also change the Settings back to default..? Can I avoid that?
Finally, is it enough to simply overwrite the executable? What registry 'work' do I need to do, or can Inno Setup do that for me? I am only using one other file which is the SharpZipLib DLL file.
For some reason I get "Exception from HRESULT: 0x800A01A8" from the following code only if I open the XLS file outside of the application I'm coding while this code is being ran. Can anyone advise as to what might be occurring and how to fix this? Right now when my application launches I just output a messagebox informing the user not to open Excel while the data is being loaded. I'd like to correct this problem.Another thing is that when I open the XLS file externally after my application loads an instance of the file, it doesn't prompt to open it as read-only.
[Code]...
I have worked with Visual Basic in the past, but never using it with Excel
View 3 RepliesI 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.
I have a 20 x 20 Excel table that I want to transfer to a numeric array in VB 2008 Express.
View 1 RepliesI got the following code snippet, but it shows errors in 3 places, the error is type "item name" not defined. I underlined and made bold where the errors show up below'Firstly retrieve data from Access database
Dim con As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:myDB.mdb")
con.Open()
[Code]....
i'm using visual basic 2008 express edition and having a problem in saving the data i've added in datagrid to excel. i use inputbox to add data into the datagrid. when i click the save button, the data from the datagrid must be save to excel. this is the code i get from some forum and i already edited it but it only saves the last data/row i inputted.
[Code]...
I added the reference and the "Imports" line, and I get the folowing error on the line
Code:
Dim oApp As New Excel.Application
Dim oWB As Excel.Workbook = oApp.Workbooks.Add()
Dim oWS As Excel.Worksheet = CType(oWB.Worksheets(1), Excel.Worksheet)
COMException was unhandled
Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
I'm using VB Express 2008 and I would like to open an excel file and save it with different name file. For example, I would like to open a file in
C: est.xls
And then I want to save them with different file name such as
C: ry.xls
I am trying to read off some cells from an Excel File. I can't figure it out. Here is my code:
Public
Class TOC
Dim ExcelObj As New Microsoft.Office.Interop.Excel.Application
[Code]....
After making WorkSheetObj I dont know what to do.. I am trying to dynamically change the Texts of Four buttons. The text values are to be to read off of Excel cells.
Does anyone has a sample code that do like,Open and select excel file and select the exact excel sheet to import then connect to SQL server 2008 and append all the data from the certain sheet to the SQL table?
View 8 RepliesI'm using the 2008 express edition. Now, I created an application that will allow the user to choose transaction in the combobox.text and input its price and quantity using an textbox.text. When the user click button1, it will be push in the datagrid/datable I created. And when the user click the button2, it must be save to excel file. The only thing I need is how to save the data from datagrid/datatable to excel. This is my code.
Imports System.Data
Imports System.Data.SqlClient
Imports Excel = Microsoft.Office.Interop.Excel
[Code]....
I am in learning stage of .NET. i am assigned a task of doing a web application project in VB.Net 2008.
But iam purely new to it.i did followed few tutorials to create web application from start, but i dint feel easy to learn it.Could u kindly let me know some usefull links to start learning web application? in VB.NET language.
How do I diagnose this?I have an app that I am creating... it has worked fine up till now.Heres what changed from the last build:Took most of images and removed them from resx file and instead added them in folders set to content and copy if newer.Added a RichTextBox Added an XML reader (Imports Imports System.Xml & Imports System.Xml. Serialization)
then just code to load/parse an xml file - and load it into the RTB an color some tags I published it, uploaded it (ClickOnce)tried it on my pc.. worked fine.. updated/ran users are saying the app says "The Application wont start - contact vendor"How on earth do I diagnose what the issue is? any ideas? (I cant get to these peoples computers... i dont know them)EDIT: Seems that it works fine for Vista Users, but not for XP users...? (odd, im on XP and it works fine)Digging around i found an app called dependency walker. Its saying that the DWMAPI.DLL is missing.. seems to point to IE7 needing this on XP?So, if I am thinking right... if the XP users dont have IE7, then the XMLReader breaks it? maybe??
I downloaded an itextsharp DLL that I would like to use in my vb.net 2008 express application.In which folder should it be placed?I went into choose items in the toolbox and tried to add it but I got an error
This is what I downloaded:[URL]..
am trying to store and retrieve data from a closed excel worksheet while in a form created in vba studio express 2008?
View 3 RepliesI am creating an application for learning purposes. I am using this: process.start("iexplore.exe"); That is working fine. However I would like to be able to tell when the page has been loaded all the way. I would like to know how to tell if the application is done processing or not, that is my main goal. If using the webbrowser control you can use the webbrowser documentcompleted event.
View 10 RepliesHow can i have my app start in a certain position on "any" screen. I want to start my application at the top and center of any screen that its open on.
View 8 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.