Need assistance on VBA command to save (overwrite) filenames w/out

[Brent E]

I need to find out a VBA command that allows me to save and name a file (and
overwrite any already existing file of same name) w/out bring up "save as"
dialogue box.

Any suggestions?

 

[Steve Rindsberg]

I need to find out a VBA command that allows me to save and name a file (and
overwrite any already existing file of same name) w/out bring up "save as"
dialogue box.

It'd help if you mentioned the application you're working with.
Thanks.

 

[Brent E]

Yes. Sorry
That would be good
LOL.

I use a Microsoft Access VBA module to control outputs and interplay between
Acess, Word and Excel. I use an OBJECT variable defined as an OBJECT variable
to control word.

I need to setup a command that allows me to create a blank document in word,
save that to a certain file name and overwrite any existing file by that
name. Isn't there some sort of parameter that can be used w/ "SAVE AS"
statement that will not prompt for user permission to overwrite?