VS 2010 How To Handle A Bad Value From Linked Excelsheet
Dec 15, 2010
Im using an excel sheet as a datasource to retrieve som values that I use to draw a modified voltmeter.
However the excel sheet is DDE-linked to another application (3rd party) that updates it on a realtime basis. Every once in a while, that means my app gets a value it cant handle, or it cant access the specific cell because its being written to.
This causes my picturebox (voltmeter) to draw an error image. Now I would have thought that once it�s supposed to redo the whole operation (datafetching and drawing) that would get rid of the error image (it�s on a timer). It doesnt.So how do I solve this? If I close the form and reopen it, that takes care of the problem, but I dont want to do that.
View 3 Replies
ADVERTISEMENT
Sep 8, 2010
In my code I have used myexcelsheet.range("MYrange").Resize(2,10) but it is not working
View 2 Replies
Oct 19, 2011
I have the following function that combines objects based on their gameScore attribute [code]NOTE the function is in a different class than where I have the lists I'm giving it..I had to set all the game positions blank because it saw an object with the same ID but different position as a different object. I didn't realize that even though I passed in the list ByVal the code deletes the courses on the original list somehow.First I input the origonal list expecting it not to be altered and put the output as a new list.[code]Yet somehow even the last one deletes the gamePosition attribute on listGames BUT *Doesn't* do the sum funtion for them, why is this happening it doesn't make any sense, it shouldn't touch listGames
View 7 Replies
Apr 14, 2011
i have 2 excel sheets (file1.xls, file2.xls), both with 2 columns. the first column of both files contain keywords, (both files have the same). now i want to write code in excel that compares the 2 files and put all the cells that are different in a new file (file3.xls). i already saw an example here on the site, Excel sheet values comparison, but somehow it doesn't fit for what i need, and i don't get it to work.
View 7 Replies
Dec 12, 2010
I've written a program that works perfectly well when installed on my development PC, but when I use the wizard in "Build-> Publish" and install the software on another computer it complains it can't find the DLL that I've linked to.The DLL comes from a programmable board that I'm linking to, so I don't have access to the source code, and I've included it in my project using the following lines:
Declare Function InitMbee Lib "C:UsersMartin & CelinaDesktopVBminimb.dll" () As Boolean
Declare Function SetOutputs Lib "C:UsersMartin & CelinaDesktopVBminimb.dll" (ByVal outputs As Integer) As Boolean
However I've not included the DLL in any other way, so I'm wondering if I have to add it to a list of items that need to be included with the installer, or if I've declared it in such as way that it needs to be in the same place for all installations.
View 1 Replies
Jan 11, 2011
Following code below. I will explane what it does and it needs to do.
Its a query that fills a gridview. Everything thats in the gridview needs to be exported to a excelsheet.
I've got it working that when i fill it, it will fil the sheet with only the same line. Im not a prof VS developer.
Code:
Now the problem is the following.
Code:
It need to pick up each line but it only picks up the first line and duplicate's it.
I left the qeury line out for privacy reasons.
View 2 Replies
Aug 21, 2011
I would like to create a little list in my Windows Form showing a list of custom colors with their 'friendly names'. Technically it can be anything (ListBox, ListView, Panel etc... whatever).
I simply want it to look something like this:
I would like to store data for this list in a simple TXT file in such form:
Quote:
Blue,Blue
Red,Red
#F6A118,My favourite color
#004080,Another color
And of course I would like each element on such list to be clickable, so if I'd click 'My favourite color' it should return the color's HEX value (#F6A118).
View 21 Replies
Jan 22, 2011
I've got a form that acts as a progress report for a long running operation, it has a listview on it (which I might be replacing with a DGV soon) that gets updated with progress updates from a background thread that is doing all the work. The method running on the background thread raises events that the form then handles and adds the string passed in to this event to the listview. The method running on the background thread raises progress update events several times a second and for each of these updates the event handler on the form must invoke a method on the UI thread to actually add the item to the listview.
This works fine on my test PC (which has a quad core CPU and 8 GB of RAM) but others have reported that after a while the form goes to the Not Responding state so I'm assuming all of these updates on the UI thread are being requested too often for it to be able to process them all as well as user input.So I'm looking for a better solution and have come up with the following:When the background thread raises these progress updated events, instead of them being added to the listview instantly I add them to a Queue(Of String). Then every second the form would check this queue and remove any items currently in it and add them to the listview - using a Queue(Of T) instead of a List(Of T) should guarantee they come out in the correct order. Both of these operations (adding to the queue and reading/removing from it) would be done under a SyncLock block that would lock on the same object to avoid both threads trying to work with the queue at the same time, so there would still be some contention but I'm hoping it would mean the UI thread only gets busy once a second instead of potentially roughly 30 times a second as it is doing now.Does that sound like a good plan? Can anyone think of a better way of handling this?
View 18 Replies
May 2, 2011
I have been working on a program and I need it to unzip a zip file. I tried handling a zip file as a directory but that didn't work.It wouldn't hurt if I could compress files into a zip file to! But I need unzipping the file first.This is my code handling it as a directory:
Dim count As Integer = Directory.GetFiles(My.Application.Info.DirectoryPath & "Games" & game & "�00.zip").Length
MessageBox.Show(count)
It has an error saying it is not a valid directory name.
View 4 Replies
Aug 28, 2010
I need to get the handle of a variable. How do I do this?
DEVICE_PARAMETERS = New PresentParameters
ZeroMemory(>>Handle of DEVICE_PARAMETERS<<, Marshal.SizeOf(DEVICE_PARAMETERS))
-Ren�
View 4 Replies
Dec 26, 2011
Only now, I'm facing this kind of problem, i have a application that until now worked with two different cultures ENG and PT, i always knew this, and i manage to solve all problems related to parsing the numbers, but now i have to change the code, and "protect" the code to handle with others cultures. So i need tips/best way to handle different cultures, and different database culture settings.I think that i shouldn't limit the user, by setting the decimal, the grouping digit, the date time format, etc. . The application should accept the numbers in the user current culture. But this path forces me to putting everywhere the parse/tryparse method.
View 1 Replies
Dec 23, 2010
I am working on a new version of my clipboard manager. I was wondering if there would be a way to copy the value of a given handle without knowing its type? The current methods I know require one person to know the type of the handle (as an example by using Marshal.PtrToStructure).
View 1 Replies
Sep 24, 2010
I am trying to use a free 3rd-party DLL (SmartWIM.DLL - Smartdeploy Imaging Component) which is, essentially, a COM wrapper for the WIMGAPI DLL for creating images of Windows drives.You have to register the dll with REgSVr32 of course Now, included with the installation package is a VBS that does a CreateObject for the SmartWIM object. When I use the VBS I can successfully create an image with the CaptureImage method.However, when I convert the same code to VB.NET and called exactly the same method, the CaptureImage method "hangs".By that I mean it successfully creates an image file but then doesn't do anything else. I am at loss to understand why it would work when run via a VBS and not work in a VB.NET Console application?
View 2 Replies
May 30, 2012
I have an event in a module, like this:
vb.net
Module Module1 Public Event Event1(Value as Boolean)End Module
I want to be able to handle this event from different forms. This is what I tried to do...
vb.net
Public Class Form1 Private Sub Event1Handler(Value As Boolean) Handles WindowsApplication1.Event1 End SubEnd Class
But I get a squiggly line under WindowsApplication1 that says Handles clause requires a WithEvents variable defined in the containing type or one of its base types. I tried to swap Module1 in, but same thing. I tried without anything in front of Event1, but still nothing.
View 11 Replies
Jun 5, 2012
I'm needing to make something to ALWAYS replace a "." to "," in all textboxes...
That's what I'm doing, and it's working:
Private Sub Timer1_Tick(sender As System.Object, e As System.EventArgs) Handles Timer1.Tick
For Each myControl As Control In Me.Controls
[Code]....
View 7 Replies
Jan 27, 2011
WebBrowser Handle new window: How I can open it in a new window
View 7 Replies
Dec 31, 2010
I have inserted the following code depicting a procedure that can place the cursor at a particular location within a Rich textbox. However, I am unable to get the Hwnd handle to run without an error.
Would someone advise if the SendMessage arguments are correct and how do I access the RichTexBox Hwnd window handle for this procedure.
[Code]...
View 4 Replies
Jan 29, 2011
Ok i'm loading a webpage in the WebBrowser Control, but what i need to do is manipulate that webpage. Here is the webpage (you will probably need to take a look so you know what i'm talking about). [URL] Now i'm trying to remove the advert at the top of the webpage OR somehow get the handle of the Java applet and set it to an x and y co-ord on my form.
View 2 Replies
Jan 30, 2011
I want to make a screenshot of a specific window of which I know the handle. I know there is a BitBlt function but I can't get that to work with the handle, I prefer it to work even if the window is not active but I'm not sure if this is possible at all.
View 1 Replies
May 4, 2011
I have a very huge server log files like files are more than 500 to 600 mb and even some files are over 2 gb data. the files are maintained for few years. it will be maintained as is. each log file has at least 1 million lines to 20 million lines.I am looking create an application which can find a line in the text file using regex, removing duplicate entries.how these huge file can be handled in a way it works very quickly.
View 5 Replies
Feb 25, 2012
I have been working on an image capturing tool for a long time now & I was wondering how some of those programs are able to make an aero capture of a form.I know you can capture a window if you have it's handle by using the BitBlt, but that doesn't keep the transparancy of the aero form.Let me give you an example:I did a lot of research on google but I never found anything close to something that explains how to do it.
View 4 Replies
Apr 7, 2011
I'm trying to use a asynchronous UDP-Port to recieve data on a form.I manage to receive one message at a time(for each click of btnReadData), however if I do this receive in a loop (in order to continously receive new messages), my form seems to be locked.What am I doing wrong?
Public Class FPR2DIS
Delegate Sub dDataReceived(ByVal Data As String)
Dim UDPWorker As New Worker
[code].....
View 3 Replies
Jan 16, 2011
For an app. I'm making I need to find all the windows that belong to a process.
From all of this windows I want to have the handle and title.
View 4 Replies
Jan 25, 2011
I've got my serial/com port code working ok using the standard Port.DataReceived handler:
AddHandler Port.DataReceived, AddressOf port_DataReceived I now want to be able to handle multiple COM ports. Do I have to create multiple copies of the handler sub or is there a way the handler sub can tell which COM port it was called for?
View 3 Replies
Apr 18, 2011
I am reading dates from a table in a database to display in a DataGridView column that is formatted as a date. The problem is that when the value is null in the database my program errors out because it cant convert the value to a date. How do you guys handle this? *Edit: If I set the value of my date variable to "Nothing" it displays as "1/1/0001" in my DataGridView, and I would like the cell to be empty for the null dates.
View 24 Replies
Sep 3, 2010
I've looked through a lot of snippets online and I see a lot of things similar to
Dim bytes(tcpClient.ReceiveBufferSize) As Byte
networkStream.Read(bytes, 0, CInt(tcpClient.ReceiveBufferSize))
but what I am unsure of when to call such a thing? How do I know when there is data to receive...in visual basic 6 with winsock, there was a specific routine which was called upon data arrival, but I see nothing of the sort for vbNet.
View 2 Replies
Feb 15, 2012
I have just loaded an access 10.0 database into my VB project as a dataset.Two of the tables contain an Ole object field and an attachment field (the data in the fields are described by the field types). All of the data contained in either of these field types, when observed in the dataset, show a warning and indicate that it is unable to display that data. As might be expected, when the data is called in a gridview, anything from those fields throws errors.
I would like to know if there are any known issues with these types of fields and VB, and if so what might be done to resolve that.
View 4 Replies
Apr 3, 2012
I have multiple user controls (the same one dynamically added to a form 4 times), and one class. I would like all of the user controls raise events in that one class. For example, if any of the user controls are clicked, I want it to send a string to the class to be processed and show a MsgBox "Control name was clicked"I am doing this as an exercise to reduce repeating the same code over and over directly in the control, and to avoid creating the class over and over to accompany each user control.
View 1 Replies
Mar 23, 2009
I wrote an application to handle a joystick with directinput. It works fine if it uses the handle of the main window but it doesnt happen the same if the handle is the one of the component that contains the joystick's operation.
I mean:
main form handle: 15
component handle (which is inside the window and the joystick needs the focus of this component to work): 25
It always work if the handle i initilizate the device is the main form (15).How can i use only the handle of the component?
View 1 Replies
Jun 29, 2009
I'm using VS2005.After I install an application using an .msi. Everytime this application loads it tries to find the setup and installs itself again if a file has been modified. If I delete the .msi file then the application can't even load.Is there a way to remove this link between the application and the msi?
View 2 Replies
