I have a unique problem that I have not had before. I was wondering if anyone else has seen something like this.
I have a VB.NET program that uses Jet4.0 to access a table in MS-Access.
I am using .net 2.0 (vs2005 etc).
Private _ConnectionString As [String]
Private ConStr As String...
thank you! I am reading your post and the link in that post. Can VBA and Vb6 handle this easily? It seems it would just be an API declare in VBA.
I think I am going to go this route because I can see other applications of the same method.
you rock :)
Thank you HarleyQuinn,
The deeper one sounds very interesting, is it very difficult to do it?
It sounds like an instant messenger app between excel and my VB6 app.
I think that would be more secure and reliable yes?
I am trying to have my excel VBA application send information to a VB6 application that is running at the same time.
I want to have excel VBA trigger action in my VB6 application that continuously runs in the background.
I'd rather not use some kind of file swap or having VB6 app continuously...
I have a unique problem that I need to code and I just can't get my head around it.
I have a list in descending order:
Points Cost Cost / Points
500 8000 16
470 7520 16
400 6400 16
350 5600 16
310 4960 16
270 4320 16
250 4000 16
210 3360 16
170 2720 16
150 2460 16.4
120 2028 16.9
100 1750...
I have a function in excel that looks up several databases and calculates a result based on a number of business rules.
Due to reasons beyond my control, the lookup function takes about 30 - 70 seconds to complete without a problem.
So my question is does anyone have some experience or links...
So I have a fairly robust VB.NET winform that opens excel and collects data.
The problem is that I am still testing it, and trying to debug it can be problematic.
So i'm asking if someone has a code snippet for VB.net that would kill any extraneous excel.exe running..
So the programs opens a...
I've been working on a single sign on type VB.NET winform that uses the regular com web browser control.
Dim HTMLDoc As mshtml.HTMLDocument
HTMLDoc = WebBrowser1.Document
'select the inner frame
Dim f1 As mshtml.IHTMLWindow2 = CType(HTMLDoc.frames.item(0)...
I tried that, then you run into the session ID problem.
The problem is just being able to programmatically address the "input" element.
So when I drill down into the page - I can address non-framed input and image click elements no problem.
And I can scan the frames on the more complex...
I'm using AxInterop.SHDocVw as my browser.
I'm able to run this code:
objDoc = WebBrowser1.Document
' Create a collection of all the "input" elements in the page.
Dim wbrAll As mshtml.IHTMLElementCollection = objDoc.getElementsByTagName("input")
' Create an object that...
Also,
I tried using excel web query and it did not work since the links are encased in some kind of AJAX control.
You can tab around and click the links but can not COPY them or lift the object names nor can you search for them.
Only thing I can do is right click the link and COPY SHORTCUT...
I have a IE browser based application that I can tab around but can not lift the objects inside (using java). I can tab through the options on the screen, but the COPY is grayed out, but I can manually right click a link and COPY SHORTCUT, and then paste it into excel.
So I want to tab to this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.