I will know how do I work with the opened excel instance, when I use multiple userforms. I have on my form1_load open a excel file. Then I observed that on my next userform, was unable to write to that file again. Project have no instance of APP.workbook.
View 8 Replies
Created two userforms in a single ms Word document, along with code, plus a macro on my laptom (Vista). Saved to flashdrive. At work I opened the word doc from flashdrive, but did not fine userforms, nor code & macros. There was a macro from another file I once worked on, but not the stuff from the file opened from the flashdrive.
View 3 RepliesIm just learning and have made some userforms with text box's and comand butttons and i am trying to make them create a new excel workbook and save it. I have try'd all sorts of different code that i have found on the net but carn't get any to work.
View 1 RepliesI am writing a program in VB.net (vs 2008) that requires that only one instance of the executable be running at a time. Naturally I went for the simple solution by selecting the "Make single instance application" checkbox in the Project properties. Unfortunately, this option does not seem to work across multiple users that are logged into a single XP machine, thereby causing the same issues for my program as if I were able to run multiple instances on one single user. Granted this is a corner case, that someone would switch users while my program is running, but I'd like to understand the limitations. So my question is whether the "Make single instance application" property is supposed to work across multiple users? or is it limited to only one-instance-per-user.
Here are the steps the recreate the issue (prereqs: computer with XP pro installed, 2 user accounts (not on a Windows Domain), and a dummy "single instance" program created using the property mentioned above):
1) Log in with user1, start up the single instance program
2) Switch to user2 (StartMenu -> LogOff -> Switch User)
3) Start up the single instance program using user2
*After step 3, the program launches without complaint even though another instance is running on user1. Is this a glitch? or by design?
I've tried searching this forum for an answer to my problem with no luck. I've set my program to allow multiple instances of it to run. Is it possible for each instance of it to determine if it was the first, 2nd, 3rd, etc to be opened? It would be very useful if for example if the program has been opened a 2nd time I would like to be able to load a different set of parameters for certain things for the 2nd instance. The same with the 3rd instance.
View 9 RepliesI use the following code snippet
Dim exlapp As New Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook_new As Microsoft.Office.Interop.Excel.Workbook
Dim strOriginal As String
strOriginal = Server.MapPath(Request.ApplicationPath & "/Attachments/") & "abc.xls"
xlWorkBook_new = exlapp.Workbooks.Open(strOriginal)
The code hangs in the last line. It works fine in the development environment. i deployed in windows server 2000 ,where I get this issue. the browser goes half way and throws the below exception after some time
[Code]...
I have set the identity impersonate to true in web config. This should be mostly an access rights issue.I have even provided access rights for the "everyone " user in the excel file and as well for the interop component. Please post ur valuable comments.
I am developing a application where a url is supposed to be passed to Internet Explorer using a search button. But if more than one url passes it should open in same instance. I dont want new instance to be opened every time. I am using SHDocVw.dll for the same. I have coded for opening a new IE instance and URL is getting passed successfully. But meanwhile if I close that open IE then I get exception and my program dont work.
View 1 RepliesI'm exporting my Dataset to an excel file, and I want to make sure I keep any file errors under control. One in particular that I'm concerned about is accessing a file that's already open. A general IOException occurs that says:
"The process cannot access the file 'C:Reports eport300.csv' because it is being used by another process."
Here is the line in which the error will occur:
Dim output As New IO.StreamWriter(path, False, UnicodeEncoding.Default)
I guess I could just throw a try catch around it, but what if an IOException happens that isnt related to this particular incident? Is there a way I can check to see if the file is already open before allowing this code to run? Especially when I'm using excel.
I have the code below:
Dim i As Integer
Dim objExcel As New Excel.Application
Dim objWorkbook As Excel.Workbook
objExcel.Workbooks.Add()
[code]....
At the end of this routine, eventhough the data was correctly saved to my Data.xlsx file, this routine also opened 15 EXCEL.EXE tasks in task manager.I thought that I had cleaned up before quitting. By the way, whether I write to 1 or 5 or 10 cells in Data.xlsx, 15 EXCEL.EXE tasks would be opened regardless.Is there a way to (easily and) completely close all EXCEL.EXE in task manager before leaving my application?
I want to encapsulate the use of Excel Interop to make it easier to use somehow in a reuseable library.So far, I have written some tests that work good altogether, except that between each test, I force Excel to quite so that it does have handle on the test file no more in order to be able to delete.Once I quit the application instance between after each of my tests, Excel seems to be no longer responding, causing Windows to display "Excel has stopped working and is looking for a solution"
message. This message lasts a few seconds, meanwhile Excel is closing, causing the hang on the file to occur and my tests to throw an exception like "Cannot access file because it is being used by another process..."
[Code]...
I am trying to write data to a binary file using the Print() method, but when I run it I get the System.IO exception Bad File Mode.
Here's the code for the FileOpen declaration, that might have something to do with it?
FileOpen(filenumber, "path to file", OpenMode.Binary, OpenAccess.Write, OpenShare.LockReadWrite)
Print(filenumber, expression(variable))
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.
The problem I have is that I have a 3rd party add-in working in excel to convert certain info into a barcode.
When I open excel normally, the add in works without a problem, but when I open it through excel it just doesnt work until I manually go into the add-in option, disable the add-in and the reenable it.
I need some code which checks if excel is open or not, if excel is not open then opens it (that code is fine)
else try to write some content/cellvalues to the already opened excel, basically I am creating windows application, which has been scheduled to run numbers of time in a day, when ever application executed, the application has something to write to the excel. one more thing is i don't want excel to save and close every time i execute the application, Its like transparent processing of EXCEL writing, a file is already opened, just write some content, and after writing it exit the application without either closing or saving the excel
I found that when group by multiple values does not work well with VB.NET, but it works well with C# ,here are my code, is there something wrong with my VB.NET Code? Here is my VB.NET code:
[Code]...
My program opens 4 excel spreadsheets updating info. I update one at a time and then close it before opening the next one.I want to add code to my program to test if the file is already open, before trying to open it. Occasionally someone will have one of the files opened and it causes a crash. If I test to ensure it is not open, then I can avoid this.
View 7 RepliesI need code to save the opened excel book (save as) and close it.
View 1 RepliesI want to save the opened excel book and close it. My code is given below but i found errors in that code .
xlBook.SaveAs (strTargetFile)
xlBook.Saved = True
xlBook.Close
I have a problem with WebBrowser control and cookies.First of all what happens when one navigates in a normal Web browser (IE9 in my case): open page
I enter my username / password,
I leave the checkbox "Stay signed in" unchecked and click "Sign in",
IE9 opens my GMail page with all my mails listed. That is OK.
1.2. At the top of GMail page there are a lot of links like "Calendar", "Documents", etc.
When I click the "Documents" link, my documents page is opened in a separate tab in IE9. No additional login information as name / psw is asked. This is fine too.Now, what happens when I repeat all that in WebBrowser control (I have created a very simple VB.NET application with single WebBrowser control in it).
2.1. In form load event the following code is executed:
Private Sub MyForm_Load(sender As System.Object, e As System.EventArgs)
Me.MyWebBrowser.Navigate("http://www.gmail.com")
End Sub
2.2. I enter my GMail login information (name and psw) in WebBrowser control,
2.3. When I click the "Documents" link, a new instance of IE9 is opened,
2.4. Instead of showing a list of my documents, Google asks me to login again in an IE9 window. Why? Why I have to enter my credentials again?I think there is something wrong with cookies and they are not set correctly in a step 2.2.
What I wanted to do is close all opened workbooks. This code does the work IF there is at least one or more opened workbooks. My problem is IF there is NO opened workbook at all; It goes around unendlessly in the WHILE Loop. How do I not process the closing IF there is no any opened workbook at all? (NOTE: I found this code from somewhere else.)
[Code]...
I developing an application that downloads some reports from a external ASP web app. I use the control webbrowser to navigate through the pages, generates and download the reports. The URL are in an array ArrURL and I have 2 situacions:[code]
View 5 RepliesSeveral years ago, I created a nifty data entry form that is called from a main menu. Due to recent user requirements, I had to create another form that is very similar to the data entry form. To prevent duplicate coding and testing, I created a class to inherit the existing data entry form. The issue is when I leave the class and return to a sub menu, the class is opening the main menu and the sub menu. How do I only return to the sub menu without the main menu appearing? Here is a snippet of my code. You'll have to scroll down to the very bottom to see the section that is causing issues. BTW, I coded the application in such a way that only one form should be open at a time.
frmMenu (main menu). This is nothing more than a bunch of buttons that allows the user to perform various functions.If user clicks button #1, open the data entry form:
Dim objFrm As New frmDataEntry
bolOkToCloseForm = True
Me.Close() '--- close the menu screen
[code]....
I need to:
1) Read a CSV file,
2) Put the data in a list object that I can sort,
3) and populate a few GridView controls on a form,
4) Write my sorted list to an excel file, which I've never done.
I'd like to create a formatted summary table that would look organized when opened in Excel. Who is best person/ or place to ask about that?
I using Microsof Visual Basic 2008 Express Edition. I need to create a form like: 2 buttons are open and save existing .xls file which each generation can choose a different.2 textbox that can be entered on the column
and last button to when choose two columns, to find duplicates values and mark different color same values. Is it possible?
At the moment Excel file opens, but the comparison does not require the introduction of the columns
I've been tryin' to develop macro, that can find table in the word and then copy it into the excel. Now it works, the only problem is, that is only the first row, that get copyed...
example (cell /w three lines in it):
Today is great day
Today is not a great day
Today, it is outrageous day
and with the code bellow, I get only Today is great day
Code:
For Each tTable In ActiveDocument.Tables
n = 1
With tTable
[Code].....
I'm trying to access the most recent instance of Excel so I can paste data. What works for me is if Excel isn't already opened, I open it and can paste the data where I want to. What isn't working for me is if there are multiple instances of Excel open.
I'll explain: Say I have 3 instances of Excel opened, each with one workbook. Instance 1 = Book1, instance 2 = Book2, and instance 3 = Book3. I want to paste my data to Book3, since that's the most-recently-opened instance. Here's my code:
' Get (array of) all running Excel processes
Dim xlProcesses As Process() = Process.GetProcessesByName("excel")
If xlProcesses.Length = 0 Then ' If Excel isn't found
[Code]....
The AppActivate (line 10) does indeed activate the correct instance of Excel (Book3), but xlApp (line 13) ends up getting assigned to the Book1 instance, and my data ends up pasting there, even though Book3 is the visible/active workbook.
I am looking for the code to consolidate multiple .xls sheets from within multiple work books in a file all containing the same format of information. Each sheet needs to be coppied to a new sheet within a single work book.
Once in a single sheet I need to then copy data from a range of fields into one consolidated sheet.
I developing a windows application. i dont want to allow multiple instance of the application how i will achive that?
View 1 RepliesThere are 3 project in vb.net MAIN PROJECT, BLL(Business Logic Layer), DAL(Data Access Layer) now we are trying to maintain one single instance of some values through out the assembly or what we can called single instance should get used in all projects...for example there is a class called clsParameter we need only one instance of this class should get used through out all projects so if i made any change in MAIN PROJECT same values also get updated in BLL or BLL should receive same values....
View 3 RepliesI don't know how to do this and I've googled this to death.
View 2 Replies
