Question about saving a workbook with a macro

[Colombo]

I've got a question about saving a workbook with a macro. I can save the workbook fine with the macro. What I would like to do is have the macro generate the file name based upon a given text & add the month year into the title of the file name.

So for example, I want to save the file name as "Feb 2003 Monthly Report.xls"

Is there anyway to setup the macro to use the date function or something else to generate the Feb 2003 based upon the current month, or possibly by looking at a cell in the workbook?

Thanks in advance for any help.

Josh

 

[Colombo]

Narf...

if len(dir("C:\monthly reports\"))=0 then MkDir("C:\Monthly reports\")

Sorry, don't know what got into me.

LT

That gives the same error too. It works fine when the directory does not exist, but if it exists I get the error.

 

[LTunnicliffe]

if len(dir("C:\monthly reports\", 16))=0 then MkDir("C:\Monthly reports\")

Sorry about that it works for sure this time.

 

[Colombo]

if len(dir("C:\monthly reports\", 16))=0 then MkDir("C:\Monthly reports\")

Sorry about that it works for sure this time.

That did it.

Thanks for all the help.

Just curious though. What exactly does the len function do, and what does the 16 on the back do? I searched through the visual basic help and didn't find any info on that particular parameter.

I really need to get a book or something that can give me a little more info and help on the fundamentals.

Josh

 

[LTunnicliffe]

The function len() returns the length of a string (ex. len("Cat") would be 3).

The 16 which I failed to get anytime before my last shot is a parameter of the dir() function, it tells the function that we're looking for a directory and not a file.

Hope these explanations are enough.

LT

 

[Colombo]

The function len() returns the length of a string (ex. len("Cat") would be 3).

The 16 which I failed to get anytime before my last shot is a parameter of the dir() function, it tells the function that we're looking for a directory and not a file.

Hope these explanations are enough.

LT

Yup,

That's good, Thanks again.

Josh