dynamic creation folder while preview report

[MUHAMAMD SALIM SHAHZAD]

dear sir

i wanted to create the folder of today date by default in c driver
under c:\reports folder..i hve tried mkdir, dir with vbdirectory but
did not success

Private Sub cmdReport_Click()

docmd.openreport "myreport",acpreview

DoCmd.OutputTo acOutputReport, "myreport", _
acFormatRTF, "c:\reports\myReport.rtf", False

End Sub

can anyone help me

thks and rgds bye

[peter walker]

MkDir works. You are probably trying to create a folder using the date
format. This would contain illegal characters in the file / folder name.

Try something like...
MkDir "c:\reports\temp" & Format$(Date, "ddmmyy")

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
[url]www.papwalker.com[/url]

"MUHAMAMD SALIM SHAHZAD" <msssd786@yahoo.ca> wrote in message
news:5a7850d5.0307012230.70349520@posting.google.c om...

> dear sir
>
> i wanted to create the folder of today date by default in c driver
> under c:\reports folder..i hve tried mkdir, dir with vbdirectory but
> did not success
>
> Private Sub cmdReport_Click()
>
> docmd.openreport "myreport",acpreview
>
> DoCmd.OutputTo acOutputReport, "myreport", _
> acFormatRTF, "c:\reports\myReport.rtf", False
>
> End Sub
>
> can anyone help me
>
> thks and rgds bye