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....
But if I change it to below, it will work:![]()
ActiveWorkbook.SaveAs Filename:="c:\test.txt", FileFormat:=xlUnicodeText, _ CreateBackup:=False
Sincerely ask for advice.![]()
ActiveWorkbook.SaveAs Filename:="c:\test.txt", FileFormat:=xlText, _ CreateBackup:=False
THanks.
Gary
Bookmarks