I am writing VB code , in which I am trying to open the excel application through GetObject. But when user trying to enter data into excel sheet simultaneously, then system error generated due to component busy. How can I detect if Excel is busy??
View 1 Replies
I have created a program using FaxServer and FaxDocument. I want to know if there is a way to determine programically if the modem is busy? Busy in terms of it could be sending/receiving a fax or another program is using it. I just need to know if its in use.
View 5 RepliesI am trying to determine if a modem is busy. I have tried using serial ports which from what i can see just tells me that something is tied to a port or not. It does not tell me if the modem is busy.
My overall question is How do can I determine if a modem is busy? For an added bonus, also is there a way to tell what device is using a particullar port?
I have read some of the other posts on this and seem to be a little different than my situation. Trying to print out some reports into an excel document on the clients machine - of course it works fine on my local (heard that before right). I went in and set my references Ms.Office.Core and Ms.Office.Interop.Excel to 'Copy Local' = True so the .dll are in the servers bin folder.
[Code]...
Details : I have the MultiModem (MT5656ZDX) . I wrote visual basic application for making the call using 'MakeCallAsynch(txtPhoneNumber.Text)' function. Also i have the callback event handler for get the line status and write the log. But my tapi call is not going the status except DAILING,PROCEDING,CONNECTED,DISCONNECTED and IDLE. Its not showing the line busy, phone swithed off status. Please guide me regarding this.
My event handler
Friend Sub LineProcHandler(ByVal hDevice As Long, _
ByVal dwMsg As Long, _
ByVal dwParam1 As Long, _
[code]....
Just tried out a new Excel component. (Spire.Xls)I make a reference to the DLL and write my code to create an excel workbook. Everything seems fine but when i compile my program i got this warningWarning1The referenced assembly "Spire.XLS" could not be resolved because it has a dependency on "System.Web, Version=4.0.0.0, Culture=neutral, ublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider retargeting your project.Mix-kasse
View 2 RepliesI would like help with a script component in Visual Studio 2005 to take a text file as a source and convert it to Excel file (output). The text file uses a ~ (tilde) as the column delimiter.Also, can this be done without installing Excel on the server? Any and all suggestions are welcome. Below is sample I am having a problem with in the script component:
[Code]...
I keep getting an error stating that Excel.Application is not defined and I also get Option Strict On requires all vairable declarations to have an 'AS' clause. Can someone point me into the right direction?
I am converting an old Vb6 solution to .net 2.0 in vs2010. I've been working in C# for about 3 years now and .net for 5. I don't recall having this problem in C#, but if I want initialize a readonly collection of DerivedControlFoo Is there a clean way to do it besides creating a sub to do it all off somewhere else? I'd love to be able to do it at the class level at the declaration for readability and simplicity.
View 1 RepliesCreate a DLL component for database operation and use created component in another project. Required methods, events and properties
a. Connect
b. Add
c. Delete
d. Save
e. Record navigation (first, next, previous, last)
f. Properties for all database fields
g. Events for validation of database fields.
I've created a component whose name I'd like to be able to change while editing in the component tray. I've added a Designer action for a name property, but now I'm stuck.
Looking at the property grid, I can see that the name property is parenthesised, indicating that it's not a regular property.
I have a client program I wrote that waits for TCP communications. I found that when it was waiting, the form became unusable. I did some reading and learned about threading. Now it works great. Now I came to the point where I need to stop the program.. this is basically what I have:
[code]...
I figured I'd use the quit option to set the bool to false that the thread will see then do the proper closeout. However, it doesn't seem to work. After banging my head against the code, hehe, I realized that the thread is hung waiting for a client on the "AcceptTcpClient()" line.. so it's never getting a chance to evaluate SystemRunning.Is that an accurate assumption of the problem? If so, how does one deal with it?Also, I surmised that I probably should put my "end" statement at the end of the thread to be closed rather than my quit sub. I was afraid the marker boolean for the thread would get set and then the quit sub would immediately trigger "end" before the thread had a chance to close out. Is that also correct, or doesn't it matter?
How can I access data that WebBroswer1.navigate function is downloading from a website, while it is downloading it? If I access it once it has finished downloading it through the WebBrowser1_DocumentCompleted function, it only slows down my program, since it has to wait for the website to finish downloading to the control before I can access it.
View 2 RepliesI wrote a fax program that is using Microsoft FaxServer and FaxDocument on a windows 7 machine. I want to be able to check if the modem that the FaxServer is using is busy. I maybe busy for whatever reason (in use by another program, receiving or sending faxes, whatever). What currently happens, is if the modem is busy, the fax is sent to the Windows Queue and waits for the modem to get done. I don't want that to happen. So before sending I want to check if the modem is in use. I have a couple of things I have already done. But I am having issue tying them together.
I can get a list of ports for the computer and I can get the faxserver devices. But I would like to be able to do something like... take the faxserver device it is using(Com1, Com2, Com3...Whatever) and I want to check if it is free.
[Code]...
Windows 7; Visual Studio 2010; Visual Basic; Home UserQuite frequently during Visual Basic debugging Visual Studio hangs and requests that a notification be sent to Microsoft regarding the issue.I tried the links in response to
View 1 RepliesI have a form with several buttons on it and when the user presses one of the buttons it begins a lengthy process (takes up to several seconds). What I want to happen is that any subsequent button presses that occur on any other button on the form are ignored until the process is complete from the initial button press. What actually happens is that subsequent button presses go into a queue and are executed in sequence as the processes for each complete. What I mean is, if each button executes a function that takes 2 seconds and I hit 5 buttons very quickly (in less than 2 seconds say) it leads to a sequence of events that takes 10 seconds.... what I want to happen is for it to lead to only the FIRST button press occurring and taking the 2 seconds that it's activated function takes.
I am writing software that interfaces with hardware through a USB to UART converter and am using virtual COM ports and timing is critical. I want something to occur ONLY when I press a button, not seconds later after being queued up and waiting for a previous operation to finish.
In my new application i have to process a SQL statement.Depending on the settings , the statement takes between 10 an 20 seconds.is there a possibility to display a second from / dialog / popup for this time?
View 5 RepliesIm trying to show animated gif during busy process or loading. but it isn;t working rite. the gif stops to animate when loading instead and animates only when no loading is n progress. what i have done is to show formB from the formA. i load the gif into the picbox in formA and crete a new thread which will be opening another formB.
dim loadThread As Threading.Thread
LoadingGif()
loadThread = New Threading.Thread(AddressOf loadingForm)
loadThread.Start(formB)
but the gif doesn;t move at all unless another form is displayed.
I working on a project wherein i need to merge 2 or more files. but while the program is running or doing the specified descripted job. it seems to be standing still, which may confuse the user that application is not working or not responding. so i want to add a progress bar or anything related to show that the application is still running. can someone explain or tell me how to add this in my program. can you explain me with a simple program or something.
View 1 RepliesWhen I try to build a project, vb hangs and displays this message in the notification area
Microsoft Visual Basic Express 2010 is Busy. I have to end up using Task Manager to end the process. I have been using VB Express for about a year and have never had this problem. i have tried to re-install VB 2010 express, no joy. I even built a Hello World app, still no joy. This is really stopping all my VB work.
I am currently developing a chat application and am trying to include:
Various states, like MSN does, available, busy and away.If the user doesn't touch the keyboard for one minute, the state of the user isto be changed into Away.Or something similar to these.I also need the program to be able to play a sound while running.
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 have a excel file place on server. I am using a application which written by VB.NET to open file in read only mode. User 1 open file in read only mode. How can user 2 detect that file is open or not status?
View 2 RepliesI have an application that browses through Excel-files, changes color in some cells if they are in a wrong format etc.When my application is saving the changed file I get this alert about compatibility issues that can occur, and this alertbox has to be agreed or cancelled to move on to the next file.
How can I disable this compatibility check programmatically? Or is there any way to ensure there are only Excel 2003 compatible colors in the document before saving?
I have this problem with this macro. I think it's a VERY common problem, but I just kind find a straight answer since it's so specific.
I have data like this:
juanA50
juanB60
juanD70
pedroA50
pedroC70
pedroD80
pedroF90
felipeA50
felipeH100
felipeL200
The first column is the name of the employee.
The second one contains the name of payment concepts (salaries, insurance, etc).
The third column contains the actual amount to be charged or discharged.
The desired output should be like this:
___A_B_C_D_E_F_H_L
juan_50_60__70___
pedro_50__70_80__90__
felipe_50____100_200
Delete duplicated values in the names, merge the matching rows of an employee and put them in the correct colum that matches the payment concept. I'm using SQL Server 2000 and Excel 2007, so feel free to talk about querys and Excel 2007 new functions. This is done with a VB6 application (not VBA), so I'm using Excel's object model as a reference in my project. I was originally trying to do it with SQL Server, instead with a macro, but I couldn't find a way.
I was wondering if there is a way to programatically check and see if a sheet exsists in an excel workbook?
Basically what I am doing is checking if an excel document exists, opening it up and checking if the specified sheet exists. I am currently unaware as to how to check and see if the sheet exists.
UPDATE
I have been given some good code to make this work. All i am missing now is the correct imports.
I have searched and found this import :
Imports Tools = Microsoft.Office.Tools.Excel
But for some reason that is not recognized. Do I have to configure VS somehow to make it work? Or am I just using the wrong import?
I use the following code in a webservice to fill a SQL 2008 database.
[Code]...
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 have an application that browses through Excel-files, changes color in some cells if they are in a wrong format etc.When my application is saving the changed file I get this alert about compatibility issues that can occur, and this alertbox has to be agreed or cancelled to move on to the next file. How can I disable this compatibility check programmatically? Or is there any way to ensure there are only Excel 2003 compatible colors in the document before saving?
View 13 RepliesI am exporting text to a worksheet with fixed column widths and there instances where the text in the cell does not fit and will obviously overlap to the cell on the right.
I'd like to prevent that overlapping by reducing the font size of the cell if it is necessary. The problem is how to check if the text does not fit.
I can upload excel to sql but when i upload again with old record for update and another record to insert new record [code]...
View 2 Replies
