Hi,
My company has asked me to take a look at something called "Excel Reporter". I've googled and the although I can find mentions, the only definite link brings me to Synaptris' web site and a product called IntelliVIEW. Are "IntelliVIEW" and "Excel Reporter the same thing? Is there...
ok, so now I understand that the folder you see in explorer doesn't actually exist and that the files are held in \content.ie5\<random sequence>
If I use that path in vb with fso then it works and it retrieves the correct info... but that info isn't up-to-date. I can see it change in explorer...
Hi,
I need to read the "Last Accessed" property of a single file - all is well except when I try to do this on a file stored in "temporary internet files". Explorer is set to show all hidden files.
ta
I'm trying to copy and paste the text contents of a web page which contains an applet. If I do a straight forward copy and paste by hand then all is well.
Because of the applet, innerHTML is no use. I've also tried using sendkeys but no matter which format I use nothing ends up on the...
hi,
this line of code is fine (wb is webBrowser) in documentComplete event:
MsgBox wb.Document.frames.length
so what I then want to do is to loop through the frames in each document and display the html - but the following doesn't work:
MsgBox wb.Document.frames(1).innerHTML
thanks
have following in document_complete event of webBrowser.
Dim h As mshtml.HTMLDocument
h = wb.Document 'wb is webBrowser
Dim f As mshtml.FramesCollection
f = h.frames
Dim i As Integer
For i = 1 To f.length()
'how to pull text here
'f.item(i)...
if the text was part of html source then I'd be able to do that - since posting the above this text I've realised it's most likely part of an applet. From everything I've read it would seem that applet text is refused by the sytem clipboard, and if I use vb6/net then nothing is copied to the...
Hi, need to select block of plain text from external app window (IE). tried using getWindowDC and getWindowRect without success. Code so far is:
ie = New SHDocVw.InternetExplorer
ie.Visible = True
ie.Navigate("http://www.whatever.com")
mouse_event(MOUSEEVENTF_ABSOLUTE + MOUSEEVENTF_MOVE...
If you can already program then I'd say that site is no better no worse than many others out there. It's just a case of sitting down and working through a structured book and posting on forums for things that don't make sense.
If you're new to programming then I wouldn't start with vb.net - no...
grouping doesn't do what's needed. The suggested UI for the app was to have a main app window (only this would appear in taskbar) and then from that main window you could view the MSoffice/IE windows as required.... only the user wasn't happy with that :-)
I was hoping there was some sort of...
got it! 5mb down to 122k :-)
turned out I had 817 oleObjects. Not enough just to check for links or drawingobjects, also have to check type of drawing object:
For Each obj In sheet.DrawingObjects
if typename(obj) ="OLEObject" then obj.delete
next
vb.net app that opens various excel/ie windows. As you'd expect, taskbar shows windows in order they were opened. Along comes user who decides to open something else, this window appears at end of taskbar. NO, no, no... user doens't like this, this is catastrophe! User wants new taksbar icon...
Hi
working with excel wb that had become very bloated over time. Code in wb.open to clear all sheets (formatting, formulae and data), drawing objects, names, shapes and links. That's worked to reduce file size (20% of original) but once the code has finished running I can't click on a sheet -...
Hi,
I need to call following piece of javascript from vb. I don't mind if web page loads into instance of IE or webBrowser.
type="radio" name="gettype" value="T" onClick="setA('typeA', 'T');
thanks
five in morning here and my brain's gone on strike. Can some kind soul help out before breakfast/deadline please. ta.
TABLE-1
ID
=
1
2
3
TABLE-2
ID CODE VALUE
==================
1 1 0
1 2 5
1 3 1
1 4 4
1 5 0
2 1 3
2 2...
ok, simplest structure
TABLE-1
ID
==
1
2
3
TABLE-2
ID CODE VALUE
==================
1 A 100
1 B 101
1 C 102
2 A 200
2 B 201
2 C 001
3 A 300
3 B 301
3 C 999
query should examine all A Code...
classic two table db. invoice + multiple order line setup. Linked on invoice ID.
What i need to do is to select 2 rows from the order lines, BUT.... I only need to select the second line if the first row fufills certain conditions.
I've tried a nested IIF but the problem is that I can't...
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.