How to view tif / pdf file from excel vba code and based on image type, selection an option and save the fiile.

[SivaR]

I am just a novice in vba excel. I have a requirement. Need to select a scanned image file (mostly in tif format and some may be in pdf format). i am using a few basic controls (text field, command filed, option buttons to get file name from the folder). would like to view the image content by the side of userform (you may suggest suitable control) and on viewing the image, need to select one of the many option buttons and rename the file and save in anothe folder with same file extension. I have written vba code to select file, renaming file and saving in another folder (currently viewing of image is done outside vba code and option is selected). would liike to view the image as part of vba code. request you to guide me - Siva India

 

[Fluff]

Duplicate to: Want to open a huge number of .TIF/.PDF files one by one - open, view the image and based on type of image, rename the file with unique number

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.