Saving PDF document

[sneil]

Hi,

I am a relative newbie to VBA.

I have a VBA script that retrieves multiple attachments connected to each record in a database (works fine). Double-clicking on the attachment is the only way to open the file (there is no context menu that allows a save of the attachment).

I need to save these documents (which can be either Word or PDF documents) to a specific folder.

Is there a way to automate this save? (it might just save me a few months of mind-numbing FileSaveAs keystrokes).

Thanks in advance for your help!