Search:

Type: Posts; User: 32CARDS; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: If Chip Pearson's website ever helped you, please jot a note...

    I have visited many excel websites, I do remember help from chips's website, reading through some things that have helped.
    Thankyou.
  2. Re: Running a python script from a macro/command button

    I found a trick to run a .py script using a .bat file/script

    If you know how to make a .bat file ( open a txt file, put the code below.

    in the .bat file, to run a .py script
    the code is:...
  3. Replies
    7
    Views
    324

    Re: Deleting rows in Loop from list of names

    works good, had to add last bit of code at the end, so the next macro can start right at cell D3, it's fail_safe.


    Sub FT_2()
    Sheets("Sorted").Select
    [d3].Select
    ...
  4. Replies
    7
    Views
    324

    Re: Deleting rows in Loop from list of names

    =IF(COUNTIF(A2:A10,B2)>0,1,"")

    Thanks Michael M
    But I don't yet understand the "bigger picture" on how to implement your version.
    I have to see the entire process.

    Cheers
  5. Replies
    7
    Views
    324

    Re: Deleting rows in Loop from list of names

    footoo


    It's part of another process-macro, it starts and finishes at D3 when the list is sorted.
    If there is no new items ( empty new list), the other macro gives a msg then click and ends the...
  6. Replies
    7
    Views
    324

    Deleting rows in Loop from list of names

    Column A has listed items that are Accepted.
    Column B has listed items that are not Accepted.

    Column B is fixed set of items, but 1 or 2 new items from time to time may be added or deleted.
    ...
  7. Re: JSON WEB QUERY FROM EXCEL---WHERE DO i START PROGRESSION ?

    bump
  8. JSON WEB QUERY FROM EXCEL---WHERE DO i START PROGRESSION ?

    I been using the same excel dynamic web query for over 10 years, it becane the basis for almost everything I know ab out Excel VBA
    Soon, all my work will be useless as far as web query is concerned,...
  9. Replies
    10
    Views
    2,316

    Re: VBA Web Query not working

    Thanks

    I'll try them, obviously they want $$, we'll see...
  10. Replies
    10
    Views
    2,316

    Re: VBA Web Query not working

    Firefox won't work at all,
    the only browser that can access that site is OPERA, but does Excel 2010 (student version) utilise OPERA in settings ?


    COMODO DRAGON was my default browser once upon...
  11. Replies
    10
    Views
    2,316

    Re: VBA Web Query not working

    Thanks 999, that tick box is not there, I looked
  12. Replies
    10
    Views
    2,316

    Re: VBA Web Query not working

    After some testing with other software, it's been confirmed it's a TLS 1.2 issue.
    Even if I "force upgrade" the XP, ti still won't work because IE 8 has it's limitations and won't "talk" with TLS...
  13. Replies
    10
    Views
    2,316

    Re: VBA Web Query not working

    Thanks mole9999,

    I have no latest PC's at the moment, all are still XP because I simply don't have a real need to do anything else except web quieries and some number crunching for statistical...
  14. Replies
    10
    Views
    2,316

    VBA Web Query not working

    I have not used a specific workbook for over 12 months, but it worked before.

    I suspect the web page owner's security upgrades may have changed things, or the web browser I use on this specific...
  15. Replies
    4
    Views
    245

    Re: Deleting rows macro needs modifying

    SOLVED

    Both methods work great, so I have implemented both.
    I can't decide which to use, so I've set the task to Odds and Evens.

    An Odd numbered day uses 1 option and an Even numbered day will...
  16. Replies
    4
    Views
    245

    Deleting rows macro needs modifying

    I have a list of rows to delete in Sheets("Sort").,
    but the list has grown in Sheets("CONTROLS").

    The code below works fine when there was up to 3 rows of data which is not required. So I just...
  17. Replies
    3
    Views
    172

    Re: Percent Formula required please.

    AlanY,
    Thanks,
    that's exactly what I was trying to remember, each cell has a use in "what-if" scenarios for some tests.

    millhouse123
    Thanks,

    I think there will be one more percent formula...
  18. Replies
    3
    Views
    172

    Percent Formula required please.

    This is suppose to be a simple math question, but I've forgotten.

    Search a reliable online percent calculator which not only shows the result, but the formula, and have not been able to find it,...
  19. Re: Fixed Cell Range Value to Equal random Active Cell range Value-SOLVED

    For the record, the format is General and it's all numerical.

    It worked !
    SOLVED

    Thanks
  20. Re: Fixed Cell Range Value to Equal random Active Cell range Value

    MARK858


    My apologies, wording was not correct and good it is pointed out.
    The VBA is in a Module, not within the sheet's module.


    MARK858
    In regards to your solution,
    I have to implement...
  21. Fixed Cell Range Value to Equal random Active Cell range Value

    Currently I am using a Copy and Paste to "fix" this time consuming problem within a VBA Loop.

    The current VBA is in Sheet Name: "Timer" is:

    Sub kwik_fix ()

    Sheets("Timer").Select
    ...
  22. Replies
    3
    Views
    1,876

    Re: VBA or BAT won't run python script

    Thank for the reply MrExcel,
    Yes I tried various combinations. The double backslash was suggested by the author of the py scripts, but had not tested it themselves, it was up to me.
    I thought at...
  23. Replies
    3
    Views
    1,876

    Re: VBA or BAT won't run python script--SOLVED

    Option Explicit

    Sub test()


    Dim PathCrnt As String

    ChDir "C:\directory_bat_is_in "

    PathCrnt = ActiveWorkbook.Path
  24. Replies
    3
    Views
    1,876

    VBA or BAT won't run python script

    I have some python scripts to run using VBA,
    At first it worked, then stopped working after a PC change over.
    ( the old pc rip'd)
    I thought it may be something in the VBA module...
  25. Re: Cell value from one workbook to another using string vba- solved

    Sub Get_reference ()

    Sheets("sheet1").Range("C9").FormulaR1C1 = _
    "='[workbook2.xlsb]sheet7'!R9C3"
    'I recorded a macro and got that formula, then to remove the formula and retain 'the values I...
Results 1 to 25 of 124
Page 1 of 5 1 2 3 4