none
Run Time Error 1004 Cannot access Read only document RRS feed

  • Question

  • this is the snapshot when I took option to debug

     AC = ActiveCell
        If Len(AC) = 69 Then
        ActiveCell.Offset(1, 0).Select
        Else
        ActiveCell.Delete
        End If
        Next a
    'export to a file time saver can read
    Sheets("export").Copy
        ActiveWorkbook.SaveAs Filename:="c:\payhoolei.txt", FileFormat:=xlCSV, CreateBackup:=False
       ActiveWorkbook.Close

    Is it something in my Excel?  I used to be able to run this up until 2 weeks ago.  I have not changed my computer or files.

    Please help

    Wednesday, November 22, 2017 12:31 AM

All replies