Access 2007 SP2

My macro action 'OutPutTo' has following arguments:

Object Type: Report
Object Name: rptAutoSubjSU
Output Format: PDF Format (*.pdf)
Output File: Summer by Course.pdf

I want to put this macro on Windows schedule task to run unattended.
How to suppress prompt: "The file already exist. Do you want to replace?" on
each run?

Thanks

Song Su,

There may be a way to do this in a macro, but if so I can't find it.

The only way I know is to use VBA procedure instead of macro. That way, you
can test the existence (use Len(Dir(Path&File))) of the file already, and if
it exists, delete it (use Kill method) before OutputTo.

Only other thing you can do is uniquely name the file each time you output,
for example by adding date stamp to the file name.

--
Steve Schapel, Microsoft Access MVP


"Song Su" <(E-Mail Removed)> wrote in message
news:4BC04C10-AF6F-4F06-B38E-(E-Mail Removed)...
> Access 2007 SP2
>
> My macro action 'OutPutTo' has following arguments:
>
> Object Type: Report
> Object Name: rptAutoSubjSU
> Output Format: PDF Format (*.pdf)
> Output File: Summer by Course.pdf
>
> I want to put this macro on Windows schedule task to run unattended.
> How to suppress prompt: "The file already exist. Do you want to replace?"
> on each run?
>



__________ Information from ESET Smart Security, version of virus signature database 4193 (20090626) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Steve Schapel,

I maybe able to figure out using VBA to create pdf and overwrite existing
file. Even if I can, how to use macro to run that VBA? Because I want to use
Windows Scheduler to run unattended and only macro can do this.

Song

"Steve Schapel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Song Su,
>
> There may be a way to do this in a macro, but if so I can't find it.
>
> The only way I know is to use VBA procedure instead of macro. That way,
> you can test the existence (use Len(Dir(Path&File))) of the file already,
> and if it exists, delete it (use Kill method) before OutputTo.
>
> Only other thing you can do is uniquely name the file each time you
> output, for example by adding date stamp to the file name.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "Song Su" <(E-Mail Removed)> wrote in message
> news:4BC04C10-AF6F-4F06-B38E-(E-Mail Removed)...
>> Access 2007 SP2
>>
>> My macro action 'OutPutTo' has following arguments:
>>
>> Object Type: Report
>> Object Name: rptAutoSubjSU
>> Output Format: PDF Format (*.pdf)
>> Output File: Summer by Course.pdf
>>
>> I want to put this macro on Windows schedule task to run unattended.
>> How to suppress prompt: "The file already exist. Do you want to replace?"
>> on each run?
>>
>
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4193 (20090626) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

Song,

Make the VBA code as a function in a standard module. Then you can use a
macro with a RunCode action to call the function.

--
Steve Schapel, Microsoft Access MVP


"Song Su" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Steve Schapel,
>
> I maybe able to figure out using VBA to create pdf and overwrite existing
> file. Even if I can, how to use macro to run that VBA? Because I want to
> use
> Windows Scheduler to run unattended and only macro can do this.
>
> Song



__________ Information from ESET Smart Security, version of virus signature database 4193 (20090626) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Steve,

It works great! Thanks a lot.

Song

"Steve Schapel" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Song,
>
> Make the VBA code as a function in a standard module. Then you can use a
> macro with a RunCode action to call the function.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "Song Su" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Steve Schapel,
>>
>> I maybe able to figure out using VBA to create pdf and overwrite existing
>> file. Even if I can, how to use macro to run that VBA? Because I want to
>> use
>> Windows Scheduler to run unattended and only macro can do this.
>>
>> Song
>
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4193 (20090626) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

Very good, Song. Thanks for letting us know!

--
Steve Schapel, Microsoft Access MVP


"Song Su" <(E-Mail Removed)> wrote in message
news:E2562FF0-A7ED-4D70-A820-(E-Mail Removed)...
> Steve,
>
> It works great! Thanks a lot.
>



__________ Information from ESET Smart Security, version of virus signature database 4193 (20090626) __________

The message was checked by ESET Smart Security.

http://www.eset.com