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!

Register Log in
  • Congratulations derfloh 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: *

  1. FractalWalk

    Scrape data from web site using VBA

    I appreciate the reply, unfortunately that doesn't help me. When I do that there are no little yellow boxes to click. Secondly, that seems like it is opening up and loading the web page in a browser which is what I am trying to avoid due to my issues with page loading time errors and just...
  2. FractalWalk

    Scrape data from web site using VBA

    ...FORM THE ABOVE LINE AND SO THE NEXT LINE ERRORS "Object variable not set" txt = objCollection(0).innerText If txt Like "*" & nme(x, 1) & "*" Then 'code for player found Else 'code for player not found End If Next x...
  3. FractalWalk

    Variables sent/received using Application.Run

    OK, thanks. I will look into the library solution.
  4. FractalWalk

    Variables sent/received using Application.Run

    ...example: Global n as integer Sub Test() n = 1 Application.Run "Test_Math", n MsgBox (n) End Sub Sub Test_Math(x) x = x * 2 End Sub If I place both macros in the same workbook and run "Test", I get the result I expect: a message box displays the value 2. But when I place...
  5. FractalWalk

    Re-Initiate Function Keys in Excel

    Ah! I totally misunderstood what you said. Yes, that works perfectly. Thanks!!
  6. FractalWalk

    Re-Initiate Function Keys in Excel

    Maybe I wasn't clear. The second macro is to turn the function I assigned off, which I am intentionally trying to do. If I don't run it then the function I have assigned is still active. I want to de-activate my assigned function and re-activate the default function that Excel assigns when a...
  7. FractalWalk

    Re-Initiate Function Keys in Excel

    I have several macros that I use all the time in Excel and so I have mapped them to function keys. However, I want to be able to toggle that ability on and off so that I can access the "original" function of those keys when I need to. So I have built a menu with drop downs to "Turn on" and...
  8. FractalWalk

    General memory questions when opening Excel file

    Understood, but I am not asking to fix specific code, rather I am asking what is a better practice regarding memory leakage. I guess to put it simply, I am asking if this: Set wb = Workbooks.Open(fnme, True, True) wb.Close Set wb = Nothing is more memory efficient than this...
  9. FractalWalk

    General memory questions when opening Excel file

    This is a general question and not about specific code. I utilize multiple processes that open Excel spreadsheets, extract data to arrays and then prints those arrays to text files. My problem is that after a few runs of doing this with bigger files, I end up with an "Out of memory" error. It...
  10. FractalWalk

    Read IE9 notification bar from Excel VBA

    OK thanks, that's a lot of info for me to digest. But before I do let me ask this. You keep referencing a user form: If you add the control to your userform . . . like in case of controls on the userform or userform itself. What userform are you talking about? I am trying to read a window that...
  11. FractalWalk

    Read IE9 notification bar from Excel VBA

    ...vbNullString) Loop 'I'm looking for this part which I know is garbage but hopefully you get the idea. Do until IE.Forms(Child_hndl).text like "*download complete*" DoEvents Loop 'or maybe some type of API Do until txt like "*download complete*" txt = GetWindowCaption(Child_hndl...
  12. FractalWalk

    Read IE9 notification bar from Excel VBA

    What do you mean? I know I will likely have to utilize DoEvents in my code but that isn't my question. My question is if I know the handle of the IE notification bar is there VBA code or an API I can use to extract the text that is displayed in that bar? DoEvents doesn't do that.
  13. FractalWalk

    Read IE9 notification bar from Excel VBA

    I have written an Excel VBA macro that opens an IE9 window and goes through a series of forms and filters to create and download a report. The final step is to click an element to save the report to my local drive. At that point the report and its URL is created by Javascript on the fly so I...
  14. FractalWalk

    Error Adding Single data type

    Thanks. Evidently CCUR allows 4 decimal places and I need it fixed at 2, but I have worked around that.
  15. FractalWalk

    Error Adding Single data type

    The array contains text, dates and values. I can't use currency on that array. I have to use variant don't I?
  16. FractalWalk

    Error Adding Single data type

    OK, thanks. That should work for this section. But there are multiple parts to my code and one of them uses a variant array. Same issue there. WHen Iread the currency values into the variant array, the values change. I can't use currency for the whole array so how can I get proper accuracy...
  17. FractalWalk

    Error Adding Single data type

    ...pieces of the code. Sub test() a = 2 Do Until Cells(a, 1) = Empty ttl = WorksheetFunction.Round(ttl + Cells(a, 1), 2) 'doesn't work: ttl = ttl + Cells(a, 1) 'also doesn't work: ttl = ttl + Int(Cells(a, 1) * 100) / 100 a = a + 1 Loop End Sub
  18. FractalWalk

    Load a file to Sharepoint

    ...= fso.GetFolder(Sourcefolder) For Each f In fldr.Files sharepointFileName = sharepointUrl & f.Name If sharepointFileName Like "*.txt" Then Set tsIn = f.OpenAsTextStream sBody = tsIn.ReadAll tsIn.Close Set xmlhttp =...
  19. FractalWalk

    Load a file to Sharepoint

    I need to be able to replace a text file to an existing folder on a Sharepoint site using VBA. Due to network admin constraints, I can not use a shared drive solution and the site itself requires a username login and password. When I search the web (and this site) the solutions tend to be...
  20. FractalWalk

    Application_ItemSend Still sends E-mail even if I cancel with a message box in outlook

    Again, this is your problem right here: If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Attachment") = vbNo Then Exit Sub Exiting the subroutine does not cancel the send event, it just leaves the rutine that is run before sending it. You need to cancel the event...

Part and Inventory Search

Back
Top