Create a new folder with specified name

[robbydogg]

Hello,

Is there an easy way (which i might not have noticed) to get Access to create a folder on a server (the address on the server will be the same each time) but to have it rename the folder to something relevant and drop a report / table i need in it, with the name as specified.
for example.
I have query results where the ID number is 101.
I want to create an XL sheet with this data, in a folder.
I want the folder to be automatically created and names 09.12.09-101
and the file to be saved as Extract for 101

Is there a way to do this without too much hassle as i'm not that good with VBA?

many thanks
Rob

 

[GaryPanic]

Thats a big ask

first look at make directory (mkdir) in the samples
that will make a directory -
then you are looking at export xls again search the samples

both of these are relative easy - but you are going to have to chop and change how the export works

 

[robbydogg]

hi,
thanks for your reply, i'll have a search around