File name

[N1234]

Hello again!

I have a button on my form that exports the searched output to excel as a generic name to a selected folder. I was wondering if I'm able to change the name while selecting the folder, similar to a "Save As" for Word for Excel:

Thanks again!

N

 

[arnelgp]

please test.

 

[N1234]

please test.

Hi arnelgp!

This looks nice but the only thing is that the saved file name also takes in the folder name. For example if I save the file as "test1" in my desktop, the file becomes "desktoptest1.xlsx" instead of just "test1.xlsx".

 

[arnelgp]

oops, forget the "\".
here you may try again.

 

[N1234]

oops, forget the "\".
here you may try again.

Hi arnelgp!

This works great! I forgot to mention the "file already exists exception" overwrite feature. I,m worried that I may overwrite an excel file that may have the same name as a newly exported file. Is there a way to create that exception? Thanks again for your help! Much appreciated!

 

[arnelgp]

this will prevent overwriting existing file.

 

[N1234]

this will prevent overwriting existing file.

This is wonderful! Thanks for your help arnelgp!

 

[arnelgp]

goodluck