Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fishysheep
  • Content: Threads
  • Order by date
  1. fishysheep

    "excel reporter" - is there such a product?

    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...
  2. fishysheep

    read file property from "temporary internet files"

    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
  3. fishysheep

    sendmessage ctrl+c

    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...
  4. fishysheep

    frames in htmlDocument

    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
  5. fishysheep

    retrieve contents of framesCollection from webBrowser

    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)...
  6. fishysheep

    copying text selection in external app

    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...
  7. fishysheep

    recognising selection in external window

    instance of IE - any way to find out if there is anything selected (text, pics) in IE window? ta
  8. fishysheep

    life is too short for this... but the customer is always right

    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...
  9. fishysheep

    short delay after opening excel workbook

    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 -...
  10. fishysheep

    call javascript onclick event

    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
  11. fishysheep

    SQL having/where nightmare

    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...
  12. fishysheep

    cross compiler for mac (os X)

    hi, this doesn't have to be a .net solution - anyone know of any cross compilers that will produce an .exe for mac from windows. ta
  13. fishysheep

    select query based on values in other records

    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...
  14. fishysheep

    get innerHTML for every frame in multiple frame web page

    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...
  15. fishysheep

    follow javascript link

    <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
  16. fishysheep

    run javascript link from vb6 program

    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
  17. fishysheep

    sort

    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...
  18. fishysheep

    pivot table - can a calculated field do this?

    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...
  19. fishysheep

    pivot table - sum all data section to ONE cell

    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...
  20. fishysheep

    excel reference - hide workbook

    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...

Part and Inventory Search

Back
Top