Export to excel in an unspecified location (user chooses where to save)

[LeeHutchins]

Hi,

i would like the end user to use an export button to export form "ContractDetails" as a .xlsm document is there a way to do this?

thank you.

 

[theDBguy]

Check out the FileDialog object.

FileDialog object (Office)

Office VBA reference topic

docs.microsoft.com