File name (1 Viewer)

N1234

Member
Local time
Today, 16:27
Joined
Jun 22, 2020
Messages
64
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
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:27
Joined
May 7, 2009
Messages
19,169
please test.
 

Attachments

  • Example (2).zip
    326.9 KB · Views: 118

N1234

Member
Local time
Today, 16:27
Joined
Jun 22, 2020
Messages
64
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:27
Joined
May 7, 2009
Messages
19,169
oops, forget the "\".
here you may try again.
 

Attachments

  • Example (2).zip
    327.3 KB · Views: 115

N1234

Member
Local time
Today, 16:27
Joined
Jun 22, 2020
Messages
64
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:27
Joined
May 7, 2009
Messages
19,169
this will prevent overwriting existing file.
 

Attachments

  • Example (2).zip
    320.7 KB · Views: 109

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:27
Joined
May 7, 2009
Messages
19,169

Users who are viewing this thread

Top Bottom