Hi there.
Is there anyone that could help me with a problem.
Im opening a userform (image below), where i want the user to enter a desired name to save a PDF file of the worksheet, and a BMP image of the range A1:F26.
I want it like, if the PDF file is called 01, that the BMP file in the textbox2 (bmp) is called the same as textbox1(pdf), and when im clicking the Save As button, that the user selects where they want to save it on the computer, then both files (pdf and bmp) is saved at the location.
Userform screenshot:
https://imgur.com/a/UyF5513
Is there anyone that could help me with this?
Thanks in advance.
Is there anyone that could help me with a problem.
Im opening a userform (image below), where i want the user to enter a desired name to save a PDF file of the worksheet, and a BMP image of the range A1:F26.
I want it like, if the PDF file is called 01, that the BMP file in the textbox2 (bmp) is called the same as textbox1(pdf), and when im clicking the Save As button, that the user selects where they want to save it on the computer, then both files (pdf and bmp) is saved at the location.
Userform screenshot:
https://imgur.com/a/UyF5513
Is there anyone that could help me with this?
Thanks in advance.