I run a report for multiple customers - for each customer
it's own report. In my proccess after the report is
generated it is exported to a specific location and after
it is e-amiled as an attachment. Is there possible to
create on the fly a new path where to save the reports?
Let's to say for customer AA the path will be
C:\MyDocument\AA, for cust BB to save in
C:\MyDocument\BB...my question if the folder AA or BB can
be created through the proccess not before I run the
reports?

thx

VBA contains the command MkDir which allows you to create a new directory.

--

Ken Snell
<MS ACCESS MVP>

"GeoHunter" <(E-Mail Removed)> wrote in message
news:268fa01c4617c$9f852a80$(E-Mail Removed)...
> I run a report for multiple customers - for each customer
> it's own report. In my proccess after the report is
> generated it is exported to a specific location and after
> it is e-amiled as an attachment. Is there possible to
> create on the fly a new path where to save the reports?
> Let's to say for customer AA the path will be
> C:\MyDocument\AA, for cust BB to save in
> C:\MyDocument\BB...my question if the folder AA or BB can
> be created through the proccess not before I run the
> reports?
>
> thx
>

Ken, can you please show me the line of code, I'm sot very
good in code.

thx

>-----Original Message-----
>VBA contains the command MkDir which allows you to create
a new directory.
>
>--
>
> Ken Snell
><MS ACCESS MVP>
>
>"GeoHunter" <(E-Mail Removed)> wrote
in message
>news:268fa01c4617c$9f852a80$(E-Mail Removed)...
>> I run a report for multiple customers - for each
customer
>> it's own report. In my proccess after the report is
>> generated it is exported to a specific location and
after
>> it is e-amiled as an attachment. Is there possible to
>> create on the fly a new path where to save the reports?
>> Let's to say for customer AA the path will be
>> C:\MyDocument\AA, for cust BB to save in
>> C:\MyDocument\BB...my question if the folder AA or BB
can
>> be created through the proccess not before I run the
>> reports?
>>
>> thx
>>
>
>
>.
>

If Dir("C:\MyDocument\AA", vbDirectory) = "" Then MkDir "C:\MyDocument\AA"

--

Ken Snell
<MS ACCESS MVP>

"GeoHunter" <(E-Mail Removed)> wrote in message
news:26a4201c461bb$1362b0b0$(E-Mail Removed)...
> Ken, can you please show me the line of code, I'm sot very
> good in code.
>
> thx
>
> >-----Original Message-----
> >VBA contains the command MkDir which allows you to create
> a new directory.
> >
> >--
> >
> > Ken Snell
> ><MS ACCESS MVP>
> >
> >"GeoHunter" <(E-Mail Removed)> wrote
> in message
> >news:268fa01c4617c$9f852a80$(E-Mail Removed)...
> >> I run a report for multiple customers - for each
> customer
> >> it's own report. In my proccess after the report is
> >> generated it is exported to a specific location and
> after
> >> it is e-amiled as an attachment. Is there possible to
> >> create on the fly a new path where to save the reports?
> >> Let's to say for customer AA the path will be
> >> C:\MyDocument\AA, for cust BB to save in
> >> C:\MyDocument\BB...my question if the folder AA or BB
> can
> >> be created through the proccess not before I run the
> >> reports?
> >>
> >> thx
> >>
> >
> >
> >.
> >

Thaks a bunch!

>-----Original Message-----
>If Dir("C:\MyDocument\AA", vbDirectory) = "" Then
MkDir "C:\MyDocument\AA"
>
>--
>
> Ken Snell
><MS ACCESS MVP>
>
>"GeoHunter" <(E-Mail Removed)> wrote
in message
>news:26a4201c461bb$1362b0b0$(E-Mail Removed)...
>> Ken, can you please show me the line of code, I'm sot
very
>> good in code.
>>
>> thx
>>
>> >-----Original Message-----
>> >VBA contains the command MkDir which allows you to
create
>> a new directory.
>> >
>> >--
>> >
>> > Ken Snell
>> ><MS ACCESS MVP>
>> >
>> >"GeoHunter" <(E-Mail Removed)> wrote
>> in message
>> >news:268fa01c4617c$9f852a80$(E-Mail Removed)...
>> >> I run a report for multiple customers - for each
>> customer
>> >> it's own report. In my proccess after the report is
>> >> generated it is exported to a specific location and
>> after
>> >> it is e-amiled as an attachment. Is there possible to
>> >> create on the fly a new path where to save the
reports?
>> >> Let's to say for customer AA the path will be
>> >> C:\MyDocument\AA, for cust BB to save in
>> >> C:\MyDocument\BB...my question if the folder AA or BB
>> can
>> >> be created through the proccess not before I run the
>> >> reports?
>> >>
>> >> thx
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>