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...
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)...
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...
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...
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...
project has webBrowser control and reference to HTML object library.
Page loaded into webBrowswer has multiple frames and so using webBrowser.document.body.innerHTML doesn't return any detailed html, merely the setting up of the frames. As document_complete is fired multiple times I thought I...
<already posted on vb6 forum without success>
Hi,
webBrowser shows page with links. Moving mouse over link displays:
javascript: whatever('xxxxx')
in status bar. How can I call that javascript link from within vb program so that the new page is displayed in the webBrowser control?
thanks
Hi,
webBrowser shows page with links. Moving mouse over link displays:
javascript: whatever('xxxxx')
in status bar. How can I call that javascript link from within vb program so that the new page is displayed in the webBrowser control?
thanks
Hi
vb prog with excel reference to 2 workbooks each with multiple sheets. Have selected x amount of rows (and I can see that this is correct because they are highlighted in front of me).
If I sort the same rows in excel then all is fine, but I can't seem to sort them via vb. I think the...
Hi
data as follows:
DATE ITEM RANK SCORE
eg
1 feb aaa 1 3
1 feb bbb 2 0
1 feb ccc 3 3
1 feb ddd 4 1
2 feb aaa 1 9
2 feb bbb 2 1
2 feb ccc 3 1
2 feb ddd 4 0
output should look as:
1 feb...
Hi
Assuming i have pivot based on following fields:
date time place TotalA TotalB TotalC
pivot looks as as follows:
1 Jan 05 9:00 London 100
101
102
2 Jan 05 11:00 Swindon 200...
Hi
vb project with excel reference. One instance of excel app with two workbooks. Want to hide (on task bar) one of the workbooks. Must be possible as all I'm trying to do is to mimic clicking Windows | Hide from the Excel menu.
I've sort of solved it by having two instances of Excel and...
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.