Assistance with Excel Macro

[VEL_070]

Hi everyone, my first post.......

This forum has been extremely helpful as a novice excel user and I hope someday I can return the favour and help somebody else.

I have been trying to get some macros to work for and workbook we use to auto generate a job number in our work shop for a job card we use. Up until now it's been working well, where it simply generates the next job number and auto saves to file as that generated number into one folder location on our server.

I'd like to now take this to the next level whereby it does what I just mentioned, but would like it to create a folder of the job number it just generated and save that file into that new folder. I have spent days looking through these forums, as well as Google but can't seem to find anything that works, and I just seem to get errors on what I try.

The code I am currently using the generate the next job number and auto save the file with that number into a single folder location is as follows:

This is the workbook code:

Please Login or Register  to view this content.

This is the Module1 code:

Please Login or Register  to view this content.

Any assistance and guidance would be greatly appreciated.

Regards,
Matt

[humdingaling]

all you need to add is MKDIR command to make the directory
http://www.techonthenet.com/excel/formulas/mkdir.php

not sure where along the line you want to plonk it in

probably just before the save as in the create invoice macro?

[VEL_070]

all you need to add is MKDIR command to make the directory
http://www.techonthenet.com/excel/formulas/mkdir.php

not sure where along the line you want to plonk it in

probably just before the save as in the create invoice macro?

Many thanks for your reply and feedback. How does this create a new directory for the file name that my original code has created ?? i.e; my code will generate a new job card/file with the next number, but I need it to now create new folder with that job number as its name and save file into it.

[humdingaling]

untested because it would take too much effort for me to setup this scenario

Please Login or Register  to view this content.

[VEL_070]

You my friend are an absolute legend !!! It works, thank you very much, I greatly appreciate this, thank you !

[humdingaling]

not a problem
glad to help


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[VEL_070]

Done. Again thanks for your help. I'm learning slowly and hopefully one day I can be of help to someone else.

Cheers....

[humdingaling]

your coding seems good from what i can tell
you seem to follow the good coding practices of idents etc
makes life much easier for anything trying to follow

just need more exposure to functions and how they can be applied really