Save as user form

[samuelimtech]

Hi all,

I have a user form thatpart of it wil act a save as function, i could use a text box to define the location however i want to replicate what office does and use a browser type function. is this possible?

thanks for any help

[westconn1]

you can use shbrowseforfolder API or shell object, for the user to select a folder, or you can use application.getsavefolder, or someother application dialog, that will automatically save the file as selected, the first 2 options still require code to save the file to the selected location