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

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 พ.ย. 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

  • @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

  • @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

  • @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
      th-cam.com/video/a9CZy2xu79M/w-d-xo.html