Make Copy of pdf Document in Specified Folder

[scotthutchings]

I need to make a copy of a pdf document that the user identifies in a "hidden" folder that is associated with my backend database. I am not sure how to code this. I am using Access 2013. Can anyone point me in the right direction?
Thanks
Scott

 

[AOB]

If you can identify the path to the document, could you use the FileSystemObject to make a copy of the file?

Dim objFSO As Object
Dim strOriginalFilePath As String
Dim strCopiedFilePath As String
 
strOriginalFilePath = "<Path of the pdf you want to copy>"
strCopiedFilePath = "<Path where you want to copy to>"
 
Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.CopyFile strOriginalFilePath, strCopiedFilePath

 

[scotthutchings]

Perfect. How do I call the system browse window so the user can specify the file?

 

[pr2-eugin]

Lookup for Application.FileDialog !

 

[gemma-the-husky]

note access has some intrinsic commands

filecopy fromfile, tofile - copies a file
name fromfile as tofile - renames a file
kill fromfile - deletes a file

hard to find thesei n help, especially "name", as you get other help for name

 

[scotthutchings]

That is perfect. Thank you.

 

[okang]

Extract to Desktop OLE PDFs embedded into MS Access 2007 table

Hi there,I have never done this. Don't know if this is possible.I have embedded PDFs in a given field of table in MS ACCESS 2007.Problem:VBA on How to extract or copy a selected field into my Desktop from Fieldname in table to Filename that I want on my desktop.thanks in advance.Okang