macro to save a file as PDF, rename and move

[kaylong]

Hallo everyone,
im a beginner with VBA in Access.
i hope that someone can help me with this code. im working with MS Office 2010 and i have Database with more of 25 Tabels and quires.
what i need to do is:
-creat a macro that export reports as pdf-file with the name"BUMS_Projectnr_Project_comment.pdf" (asking before export the file...filedialog??) in C:\desktop
- if that file already exist move the old one to C:\desktop\ISD_Test with the name "BUMS_Projectnr_Project_comment+00.pdf" and if exist....+01..+02 again and again(the new one take the old name and old path)

Thanks

[ranman256]

can you just use a timestamp?

dim vFile

vFile = "c:\folder\file" & format(Date(),"yymmdd-hhnn") & ".pdf"
docmd.OutputTo acOutputReport ,"rptReport",acformatpdf,vFile