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 strongm 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
  • 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"

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

    read file property from &quot;temporary internet files&quot;

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

    copying text selection in external app

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

    VB.NET for beginners

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

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

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

    short delay after opening excel workbook

    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
  13. 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...
  14. 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 -...
  15. 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
  16. fishysheep

    SQL having/where nightmare

    Remou, I'm speechless with admiration here. If that's what you consider an "attempt" I'd hate to see a full-on effort :-) thank you so much
  17. 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...
  18. 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
  19. fishysheep

    select query based on values in other records

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

Part and Inventory Search

Back
Top