Print a picutre from Excel to PDF using VBA

GREEN Tony 0 Reputation points
2023-02-01T11:25:40.4533333+00:00

I have a large number of spreadsheets that contain a picture on one specific tab. The location of the picture varies, as it is pasted by different users into an area near the bottom of the sheet. The tab has a reference in a specific cell which I would like to use as a file name when I print the picuture to pdf. I can see how to select the image and copy to the clipboard, but I cannot think how to take this to somewhere I can print to pdf using the data from my celll as a file name.

Any suggestions?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,519 questions
0 comments