opendialog

  1. E

    Choose File and Use

    Hi, Essentially, every week there is a new file saved (wb1) in a new folder destination within a Network Drive (sadly the filename always changes depending on the date). This file is then used to populate another (current workbook). I wish to have the user choose the file (wb1) and upon...
  2. C

    vba to save pdf to specific folder

    Hi, I have the code below that saves a wksht range as a PDF. I would like the PDF to save to a specific folder that is found in cell S17 in the wkhst, so for example S17 contains the following text string resulting from a formula: C:\Users\Steve\Desktop\Data Files Any help much appreciated...
  3. C

    vba creating a PDF from an excel sheet but pictures are poor quality

    Hi, I have the code below which selects a range in excel and prints it to a PDF. The range is mainly made up of text boxes, graphs, shapes and 3 pictures. The quality in the PDF is excellent apart from the pictures which are poor (fuzzy) and let the rest down. Any ideas of how I could change the...
  4. C

    vba to save wksht as PDF but remove disallowed filename characters first

    Hi, I have the following code that saves an excel worksheet as a PDF and give the user the ability to change a pre-defined filename using a cell value. Can I have the code so it automatically changes a / (fwd slash) in the pre-defined filename to a , (comma)? Thanks Dim Opendialog As Variant...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top