Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    444

    Re: Run the same Macro on multiple workbooks

    I just noticed one issue. (Though now that I think of it, should have been obvious to me)

    The Workbooks all contain the same macros
    They all reside in the same folder
    if the open workbook that...
  2. Replies
    5
    Views
    444

    Re: Run the same Macro on multiple workbooks

    :pray:Rosen
    There is nothing quite like the high from observing successful automation

    Thank you very much, that worked exactly as intended!
    And I very much appreciate the help notes in ethe code...
  3. Replies
    5
    Views
    444

    Re: Run the same Macro on multiple workbooks

    Thank You @Rosen for the feedback, apologies for taking so long to reply, was travelling...little hectic.

    So, I tried your code and it does seem to be wroking great!, we are nearly there.
    ...
  4. Replies
    5
    Views
    444

    Run the same Macro on multiple workbooks

    With some great help from the forum community here, I have managed to use a macro that runs through a dropdown list and exports a sheet to a pdf in a user determined location
    Huge thanks to Yongle...
  5. Re: VBA to cycle through dropdown list and export into pdf

    Worked perfectly!!
    I noodled around and also added a msgbox for the users so it is clear what the file browser is asking from them (since the browser title is hard to catch, this makes them press ok...
  6. Re: VBA to cycle through dropdown list and export into pdf

    Thank you for the reply, fair point about the old post comment. I did notice it was quite old but saw that you had last edited it in 2018, so I gave it a shot.
    Will follow your advice in the...
  7. Re: VBA to cycle through dropdown list and export into pdf

    I should mention that I did find this post https://www.mrexcel.com/forum/excel-questions/1043527-change-excel-vba-prompt-user-folder-save-location.html?highlight=prompt+user+file+export+location
    ...
  8. Re: VBA to cycle through dropdown list and export into pdf

    So this worked perfectly for me, plugged in my Const where needed and all is well.
    I also added a dynamic Named range with an offset function, so the drop down list automatically fills up as new...
Results 1 to 8 of 8