Run-time Error 1004: Method 'SaveCopyAs' of object '_Workbook failed'

**melissadunham68** · 01-29-2014, 08:03 AM

This workbook is suppose to work by clicking a SAVE button on first sheet which should generate new workbook by copying the active workbook and automatically renaming and saving in my Documents folder. However, it crashes after first use. At second use its reporting the Run-time error 1004: Method 'SaveCopyAs' of object '_Workbook failed'

Dim myRange

Set myRange = Worksheets("Employee List").Range("B403")

Set Newbook = ActiveWorkbook

With myRange
ActiveWorkbook.SaveCopyAs myRange
End With

I'm very new to macros and formulas but when going into VBA in Excel it reports the following line as having the error and seems to want a Filename (ActiveWorkbook.SaveCopyAs myRange) but why would it work the first time correctly but then crash? Any help would be much appreciated.

**:) Sixthsense :)** · 01-29-2014, 08:08 AM

Hi melissadunham68,

Welcome to the forum

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)