Save Selected Range as PDF (and Center on Page) | Excel VBA Macro

Поділитися
Вставка
  • Опубліковано 7 жов 2024

КОМЕНТАРІ • 11

  • @drewgossage8842
    @drewgossage8842 2 роки тому +1

    Another great update!!
    Your style is just like someone casually showing you how to do something at work.
    Casual, yet really informative 👍👍

    • @greggowaffles
      @greggowaffles  2 роки тому +1

      That’s the goal! I really appreciate the feedback!! Thank you 🙏

  • @Master-bx4rd
    @Master-bx4rd Рік тому +1

    Hi,
    Presented excercise looks very good. But I wanted to export a range e.g. A1:R50 into 1 pdf page only.
    I'm trying to do it, but it still expotrs to the 2 pages which is what I don't want to. Any help apreciated
    Regards

  • @selvan1264
    @selvan1264 2 роки тому +1

    Excellent video!!! May I check how to use excel VBA to save as secured pdf? The pdf will not be editable, cannot copy paste only for read only etc...Thank you

  • @MuntasirSaqif
    @MuntasirSaqif Рік тому

    Thanks Greg , learned a lot by watching your videos. Quick question: I have a table of data and when saving the data to PDF, the PDF is displaying my table in multiple pages. For example, the category in one page and the corresponding sales in another. How can I fix this? Thanks

  • @MrHatem55
    @MrHatem55 2 роки тому

    Hi thank you. Your videos helped me a lot at work
    Could you please do a video about how to get all updated documents from files?
    I have a file called “weekly report “ I want to gather only the updated documents 3 excel file and 1 word from different files to my main folder “Weekly report” is that doable? Thanks in advance 🙏🏽

    • @greggowaffles
      @greggowaffles  2 роки тому +1

      Glad to hear that! I think so. So you want a macro that looks through certain folders and grabs the most updated documents in each folder to put in another folder?

    • @MrHatem55
      @MrHatem55 2 роки тому

      @@greggowaffles
      Yes exactly. Plus it would be great if I can do the file can update it self weekly without me doing anything

    • @greggowaffles
      @greggowaffles  2 роки тому +2

      ok cool. I’ll make a video on that and I’ll probably spread it across two videos to incorporate the second part

    • @MrHatem55
      @MrHatem55 2 роки тому

      @@greggowaffles
      Thank you 🙏 ♥️
      Waiting for your magic 🪄

    • @greggowaffles
      @greggowaffles  2 роки тому

      🪄Excel VBA Macro: Open Newest Files (from Multiple Folders) and Save Them in Another Folder
      ua-cam.com/video/a9CZy2xu79M/v-deo.html