Results 1 to 3 of 3

ActiveWorkbook.SaveAs FileFormat:=xlUnicodeText locked macro cannnot run

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    hk
    MS-Off Ver
    Excel 2010, Excel 2007, Excel 2003
    Posts
    2

    ActiveWorkbook.SaveAs FileFormat:=xlUnicodeText locked macro cannnot run

    Hi All

    When I use below in a VBA password locked for view in Excel VBA in 2010/2007, it cannot be run and shows "1004" error Excel cannot find any data to replace....

    ActiveWorkbook.SaveAs Filename:="c:\test.txt", FileFormat:=xlUnicodeText, _
            CreateBackup:=False
    But if I change it to below, it will work:
    ActiveWorkbook.SaveAs Filename:="c:\test.txt", FileFormat:=xlText, _
            CreateBackup:=False
    Sincerely ask for advice.

    THanks.

    Gary
    Last edited by JBeaucaire; 11-14-2012 at 11:22 AM. Reason: Added code tags, as per forum rules. Don't forget!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1