Search:

Type: Posts; User: XPDiHard; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    10
    Views
    187

    OK here it is.. ...

    OK

    here it is..

    http://media.tatts.com/documentations/ICustomer/Methods/SellWageringToteBets.html


    The, WP, MR, 5, 4, 10 and 0.0 with passwords etc in the code below would be ready in a...
  2. Replies
    10
    Views
    187

    Sent some interim info Thanks

    Sent some interim info

    Thanks
  3. Replies
    10
    Views
    187

    No prob, It was un-forseen change, but...

    No prob,

    It was un-forseen change, but expected. The company was once thriving with VBA coders to access the server, then it went to XML, (I still stuck around with my proto-type development on...
  4. Replies
    10
    Views
    187

    ruirib , thanks. I'll just keep reading, might...

    ruirib , thanks.
    I'll just keep reading, might "get it"
  5. Replies
    10
    Views
    187

    Thanks Paul T I checked out the links, it has...

    Thanks Paul T
    I checked out the links, it has xml and stuff I am not familiar with, but thank you.

    My current project in the Excel Workbook uses VBA, the web query is VBA from that same...
  6. Replies
    10
    Views
    187

    JSON format and VBA

    This is brand new territory, so basically I am asking for directions at this stage.

    The next phase of my project requires "communication" to log into and send data and numbers to a server.
    The...
  7. Is IE Web Browser Excel's only default for web DATA query ?

    While I'm waiting for the official release of Win 10, ( it does not mean I'll be back-packing at the computer store to be first, I'd rather be last.), my web browser choice will remain the same, IE...
  8. Thanks :rolleyes: Selection.Offset(0,...

    Thanks
    :rolleyes:




    Selection.Offset(0, 1).Select '*Right*
    Selection.Offset(0, -1).Select '*Left*
    Selection.Offset(-1, 0).Select '*Up*
    Selection.Offset(1, 0).Select '*Down*
  9. VBA to color Active.Cell with Arrow key syntax

    Although it's part of a recorded macro to obtain the color number, is there anything else required in the VBA coding ?
    It has to use the ActiveCell.Offset(0, -2) part because the Cell location is...
  10. Replies
    4
    Views
    239

    Thanks, The workaround I think is to use some...

    Thanks,

    The workaround I think is to use some VBA, to remove formulas if data rows are blank.
    There is usually a Minimum of 7 to a max of 16, in this case it was 15 items in the example sheet....
  11. Replies
    4
    Views
    239

    Thanks for the reply, Overall, the sheet is...

    Thanks for the reply,

    Overall, the sheet is not "static", the entire workbook is not static either, it is real time web query.
    The updated numerical values may occur from every 30 seconds to...
  12. Replies
    4
    Views
    239

    Index match paradox

    I'm not sure where the error is, or missing something in the INDEX MATCH formula.


    Only happens when there is a zero anywhere in the array of numerical values.

    percent calculation, the sum...
  13. Replies
    5
    Views
    114

    [SOLVED] I see, had the shoe on the wrong foot ! The RG...

    I see, had the shoe on the wrong foot !
    The RG say's I had the wrong shoes for the right feet, backwards to !
    :eek:

    Thnaks !
  14. Replies
    5
    Views
    114

    [SOLVED] Thanks Rory, it don't seem to work. The formula...

    Thanks Rory, it don't seem to work.
    The formula is in Cell L20

    Cell A4 is actually a 0 or 1 type of "switch".
    So if it's 1, then the first part of the formula works, if it's 0 then the second...
  15. Replies
    5
    Views
    114

    [SOLVED] Correct syntax for ElseIf formula

    The formula I'm trying to add to is
    =IF($E$4=C4,B4,"")
    But I need it to go further with a ElseIf

    This ain't working
    =IF($E$4=C4,B4),elseif($A$4 ="0"),$F$4)

    How is it suppose to be ?

    Thanks
  16. Replies
    6
    Views
    623

    Record Macro ?? Sub Macro2() ...

    Record Macro ??


    Sub Macro2()

    ActiveCell.FormulaR1C1 = _
    "=IFERROR(INDEX('Raw Data'!R2C3:R5000C3,SMALL(IF(('Raw Data'!R2C1:R5000C1=R1C[-2])*('Raw...
  17. same here

    same here
  18. Replies
    13
    Views
    1,469

    Rory, I got it from here after an extensive...

    Rory, I got it from here after an extensive search. Depends what one types in a search engine.
    ...
  19. Replies
    13
    Views
    1,469

    No, It was still "on" when activating the code...

    No, It was still "on" when activating the code while checking task manager.

    Thanks
  20. Replies
    13
    Views
    1,469

    Paul, thanks for the reply it has to be code so...

    Paul, thanks for the reply
    it has to be code so it can be "controlled" by VBA

    jwoods, thanks.

    a scheduled task as suggested will not do, it has to be within the VBA.

    This code I found in a...
  21. Replies
    13
    Views
    1,469

    How ? Thanks

    How ?


    Thanks
  22. Replies
    13
    Views
    1,469

    Office Home and Student 2010 Version:...

    Office Home and Student 2010
    Version: 14.0.6129.5000 ( 32-bit)

    Installed on 1 laptop, not networked.
  23. Replies
    13
    Views
    1,469

    disable osppsvc.exe

    Firstly, thanks to all who have helped me with my project, VBA codes, formula etc etc.
    My project is running great, still on test, but getting results.


    I'm still on XP Pro, Office 2010, ( till...
  24. Replies
    4
    Views
    396

    Ok, I'll run the process over the next few days...

    Ok, I'll run the process over the next few days and see what happens.

    I know my VBA processeing is rather large.
    I am thinking along the lines that nothing is wrong except a preset load limit,...
  25. Replies
    4
    Views
    396

    No, don't have 5 copies of Office running No,...

    No, don't have 5 copies of Office running
    No, don't have malware, anti-virus up to date.


    No.


    No
Results 1 to 25 of 197
Page 1 of 8 1 2 3 4