I have VSTO Excel addins (.net 3.5) and need to know when the Excel wookbook is being opened in a Browser rather than the Excel client. I haven't figured out a way to do this nor found a solution online and I suspect I am just not using the right seach words. Does anyone know how to do this?
View 2 Replies
I am developing a system where multiple client apps are going to communicate with a server app. I will probably use TCPIP classes to facilitate the communication.
However, is there a way that a client install can automatically discover the location of the server software on another machine?
I would like to try out a demo (more like a proof of concept), which involves running a .Net language in a browser.
I am talking about a kind of IDE that allows you to do the following:
Step through code (i.e. debug) and inspect variables Run the application
All through a web browser interface
Is there any software out there that already does that?
how to get started in building such a proof of concept demo - i.e. what are the main steps required to put a "Hello world" example together?
I'm making a little application in visual studio which loads a ROM in an emulator. I have two emulators and 20 ROMs.I made a form and added a few buttons. When you click the Button it opens a new form and closes the old one. Then on the new form I have four buttons: each one loads a different ROM in an emulator. So when you press Button1 this code is triggered:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles yellow.Click
Shell("C:UsersshiftyDesktoppokemon gamesEmulatorVBAVisualBoyAdvance.exe ""C:UsersshiftyDesktoppokemon gamesRomsYellowPokemon Yellow.gb""", vbNormalFocus)
End Sub
It works fine - I click it and it loads the game in the emulator. The bit im having trouble with is the file paths. If I send this application to a friend, it would still look for "C:UsersshiftyDesktop" - but that's on my computer, not his.Is there a way to make the application look for the file on his computer (without changing the file path to (C:Users""his user name""Desktop))
I am trying to make a program that is able to find out where it has been saved on the computer, and take that directory and save the output of the program, which is a text file, to the same folder that it is in.
I have already made it so that I can type in the directory in my code, but i want it to be more adaptable.
how can i Discover a Window Class Name ?
View 3 RepliesI want to update my database( using a file from my root folder )every hour even when my web page /form is not openedin the browser..
View 2 RepliesI have an application where some data is stored automatically to Excel. However during the storage of data, the Excel spreadsheet is visible to the user. I need to know if there is any way to make the Excel run at the background.
View 1 RepliesI have added "Microsoft Web Browser" to my windows form and I am trying to use AxWebBrowser1.Navigate("c:/file.xls") to load an excel file in the browser but it is launching the excel file outside the window? What am I doing wrong?
View 1 RepliesI would like to view excel and word document from web browser using VB.Net The excel and document are stored in my database.
View 4 RepliesI'm calling the following method from a button click event to export a datatable to excel. After the export is completed, the excel application object is quit, released and assigned to nothing. But in reality it's not getting released and stays active unless the entire application is closed. So every time the button is clicked for export, a new excel application object keeps on running. How can I solve this?
The problem doesn't occur if two of the lines from the method below are not used. But I can't omit them as they are really needed. Check the * marked lines.
[Code]...
I have a program that uses Excel files as a datasource. When I import data I start the Excel interfaces and after the whole thing is complete I close and empty the Excel references...But, the Excel program will still be running in the backround.(When I check the Task Manager it shows at least one EXCEL running...)Also, one of my excel-files always prompts for "Do you want to save the changes" option when I import the file into my program. Even though it has not been running at all... ?
If fdlg.ShowDialog() = DialogResult.OK Then
Polku = fdlg.FileName
Dim XL_App As New Excel.Application
Dim XL_WB As Excel.Workbook = XL_App.Workbooks.Open(Polku)
[code]....
I'm calling the following method from a button click event to export a datatable to excel. After the export is completed, the excel application object is quit, released and assigned to nothing. But in reality it's not getting released and stays active unless the entire application is closed. So every time the button is clicked for export, a new excel application object keeps on running.The problem doesn't occur if two of the lines from the method below are not used. But I can't omit them as they are really needed. Check the * marked lines.[code]
View 4 RepliesI'm developing a small vb application that will enable a user to select an excel spreadsheet as the source data and a word document as a letter template then create a mailmerge from the two.It's all working fine apart from when the mailmerge runs, a dialog box pops up asking for the sheet to be selected. The list of options is blank until the 'options' button is clicked and 'system tables' is selected. This is a word thing but I'd like to turn this off, if possible selecting the necessary options programatically from within my vb application.
My opendatasource code is:
.OpenDataSource(Name:=sourcefile, LinkToSource:=True, SQLStatement:="select * from 'Sheet1$'", _
[code].....
If an excel document is opened inside a webbrowser control, and you try opening another excel document using a different instance of the same web-browser control, the previous opened excel (inside the web-browser) would not allow users to edit the excel workbook.
View 1 Repliesmy app interacts with excel. im running office2007 on my dev machine but the target machine running office2010.i had this problem before where i had to remove office12, install 11 and recompile the project to get it to work on the clients machine, adding multiple references didn't help. is there a work around, or a library that works with any excel version.
View 2 RepliesIm wanting to pull some data from our Remedy Server every so often. Right now we're having to do it manually; Data > Import External Data or New Database Query. The connection is called AR System ODBC Connection Source. We have to log into the server and then it pulls the info into the sheet. Im needing even if have to setup a conection myself first to just have this conection run every couple or two and update the excel sheet. We're using excel 03, Remedy 7.
View 2 RepliesIm opening an excel document with vb.net and i dont want vb.net to close it but to release excel so that when the user closes excel it does not remain as a running process... which it currently is doing here is the code i was using
[Code]....
I try to develop a automation-add-in for Excel which can get some data from our SQL DB. So i call my add from an Excel-cell.. like "=getThisFromDb()"... This works totally fine! But what if i want to write to another cell then just give a return value? I managed to get the running instance of excel. I can read from it. I can open a new document in it and write to it. ->> But can't write to the Worksheet that called me!!
View 2 RepliesI cannot get Excel 2010 to close by using VB on my Windows XP computer at work. I have what I thought would be able to close it, but it doesn't. I do not get any errors, it its just that after multiple times of the code running, I have multiple instances of EXCEL.EXE running in the task manager, which causes problems. I am going to post the code below:
Option Strict Off
Imports Excel = Microsoft.Office.Interop.Excel
Public Class CompareDataExcel\
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
I have an issue which has successfully busted my head all weekend. I created a COMAdd-in, in VB.NET (VS 2008) for Excel 2003. We now need to work the solution out for 2007 and since the layout and objects are a little different we had to make some critical Interface changes.Instead of a floating CommandBar we are now going with RibbonBar, which looks good but it doesn't work. Whenever I open Excel Workbook (which is the primary application). The Add-in successfully recognizes it and opens it up properly (bunch of Macro calls, layout settings etc). Anyway, after it opens, if I click on any button (on the new ribbon tab) I get "Application not properly initialize. Program will now close" and excel object is lost.
View 1 RepliesI have developed a VB.Net code for retrieving data from excel file .I load this data in one form and update it back in excel after making necessary modifications in data. This complete flow works fine but most of the times I have observed that even if I close the form; the already loaded excel process does not get closed properly. I tried all possible ways to close it but could not be able to resolve the issue.
Find below code which I am using for connecting to excel and let me know if any other approach I may need to follow to resolve this issue. Note: I do not want to kill the excel process as it will kill other instances of the excel
[Code]...
I would like to create my own application that will simply discover the wireless networks in the area, similar to how the wireless card software works. I don't really know where to start, except with maybe the System.Net namespace.
View 2 Repliesgetting a DoCmd.RunMacro method for running macros inside EXCEL and Word?
View 1 RepliesI have a spreadsheet that contains details of change requests; one row per request. This information needs to be copied into a Word form for sending off to our customer who then completes the response section. To speed up this process I have written some code that utilises the mail merge feature of Word and merges the relevant info from the spreadsheet into a Word form. This runs from Excel when a button is pressed.The problem comes when I go to save the workbook and exit Excel; it stays running in the background as a process in task manager.
[URL]
I'm fairly sure it has something to do with the merge code itself but my knowledge of VB is enough to grasp what is happening but not why it is happening. If I open the Word doc that has the merge fields in it, then open the spreadsheet that houses the info Excel says the workbook is already open.
I'm calling the following method from a button click event to export a datatable to excel. After the export is completed, the excel application object is quit, released and assigned to nothing. But in reality it's not getting released and stays active unless the entire application is closed. So every time the button is clicked for export, a new excel application object keeps on running. The problem doesn't occur if two of the lines from the method below are not used. But I can't omit them as they are really needed. Check the * marked lines.
Code:
''' <summary>
''' Exports data from a datatable to excel.
''' </summary>
[code]....
In my vb.net applications, I do a lot of reading/writing to excel files.This is one of the simpler bits of code I use:
Dim objApp As Object, objBook As Object, objSheet As Object
objApp = CreateObject("Excel.Application")
objBook = objApp.Workbooks.Open("C:maid2cleanM2CPrinters.xls")
objSheet = objBook.Worksheets.Item(1)
[code]....
It's never been fast but in the last few weeks it seems to take forever.The "createobject" line is taking 4 seconds to run. is there any way I can find out why it's slowed down?
Im using VB2005 express and the app im creating uses the web browser control.Basically I want to know if its possible to make the web browser control connect through a different ip address and port from your default web browser.
View 7 RepliesI am creating a webbrowser with Visual Basic, and I have finished everything but this: When I click on an external link, (I.E. On a photo, or on youtube) it opens up in a new IE window. I want it to open in my browser, not Internet Explorer.I have read everything I have found on this subject, but it is all for normal web browsers. I want to do this for a tabbed web browser, not one without tabs. Basicly, I want to use this code with my tabbed web browser that uses tab control.
Private Sub WebBrowser1_NewWindow(ByVal sender
As Object,
ByVal e As System.ComponentModel.CancelEventArgs)
Handles WebBrowser1.NewWindow
[code]....
convert the code to be used in a browser with tabcontrol? I tried, and it works with one that DOESN'T use it, but I want to use it with my browser with tabcontrol. And, I have read ALL of the ones previously given to other people.
I've just finished making a web browser suited for my personal use, but when I click on a new link or something it opens a new window in Internet Explorer - which gets extremely anoying.. Is there a way to make all links open up in a custom browser?
View 19 Replies
