Changing file name when clicking the export button on form. (1 Viewer)

NikkiK1234

Member
Local time
Today, 15:12
Joined
Jun 22, 2020
Messages
56
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:

1614262648136.png


Thanks again!

N
 
Last edited:

arnelgp

error reading drive A:
Local time
Tomorrow, 03:12
Joined
May 7, 2009
Messages
12,050
please test.
 

Attachments

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

NikkiK1234

Member
Local time
Today, 15:12
Joined
Jun 22, 2020
Messages
56
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

error reading drive A:
Local time
Tomorrow, 03:12
Joined
May 7, 2009
Messages
12,050
oops, forget the "\".
here you may try again.
 

Attachments

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

NikkiK1234

Member
Local time
Today, 15:12
Joined
Jun 22, 2020
Messages
56
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

error reading drive A:
Local time
Tomorrow, 03:12
Joined
May 7, 2009
Messages
12,050
this will prevent overwriting existing file.
 

Attachments

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

Users who are viewing this thread

Top Bottom