make new subfolder for excel export

[ll]

Hi,
I am working with a database which exports an Excel report. I need to
create a new folder just for the downloads (by use of mkdir). My
question is, where would I put this mkdir code? It would be ideal to
include it with the Excel report button.
Any ideas?

Thanks,
Louis

 

[John W. Vinson/MVP]

Hi,
I am working with a database which exports an Excel report. I need to
create a new folder just for the downloads (by use of mkdir). My
question is, where would I put this mkdir code? It would be ideal to
include it with the Excel report button.

Just put it in the VBA code in the button's Click event, I'd assume! Without
knowing how your database or your code are set up it's hard to say for sure,
though!