make new subfolder for excel export

  • Thread starter Thread starter ll
  • Start date Start date
L

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
 
ll said:
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.
Click to expand...

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!
 
Back
Top