Named argument not found ThisWorkbook.SaveCopyAs

mssbass

Board Regular
Joined
Nov 14, 2002
Messages
209
Platform
Windows
Anyone know why I get an error "named argument not found" with highlight as accessMode:=xlShared? If I use Save As (rather than SaveCopyAs), I don't get the error:

ThisWorkbook.SaveCopyAs Filename:="\\ccx.carecentrix.com\Shares\Teams\CSC\Staffing\Confidential\MSOC\DailyReports " & txtdate & ".xlsm", accessMode:=xlShared
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,669
Office Version
365
Platform
Windows
With SaveCopyAs you can only specify the path & name
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,669
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,351
Messages
5,486,357
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top