Why doesn't this code compile?
 

This code:

ActiveWorkbook.SaveAs XlSaveAsAccessMode:=xlExclusive

returns the Compile Error "Named Argument Not Found."

Why?

Why doesn't this code compile?
 

Hi Keith,

Try:

ActiveWorkbook.SaveAs AccessMode:=xlExclusive


---
Regards,
Norman



"keithb" wrote in message
...
This code:

ActiveWorkbook.SaveAs XlSaveAsAccessMode:=xlExclusive

returns the Compile Error "Named Argument Not Found."

Why?

Why doesn't this code compile?
 

ActiveWorkbook.SaveAs AccessMode:=xlExclusive

xlsaveasaccessmode represents one of those constants.

keithb wrote:

This code:

ActiveWorkbook.SaveAs XlSaveAsAccessMode:=xlExclusive

returns the Compile Error "Named Argument Not Found."

Why?

--

Dave Peterson

Why doesn't this code compile?
 

Try ActiveWorkbook.SaveAs AccessMode:=xlExclusive

HTH

Matt

"keithb" wrote in message
...
This code:

ActiveWorkbook.SaveAs XlSaveAsAccessMode:=xlExclusive

returns the Compile Error "Named Argument Not Found."

Why?