I have an Excel accounting application which exports a number of
Sheets to a PDF (using PS to PDF/Distiller). I'm looking to take the
output files (multiple PDFs) and prompt the user for a location in
Sharepoint 3.0 and copy the files to it. I've reviewed many of the
various methods used to open a file dialog and store the value to a
variable, but none of them seem to work for Sharepoint document libs.

If anyone has examples of how to copy files from Excel VBA to a
Sharepoint document library, I'd appreciate any hints.

Many thanks.