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
Last edited by JBeaucaire; 11-14-2012 at 11:22 AM. Reason: Added code tags, as per forum rules. Don't forget!
Advice? Use the second syntax since you know it works.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
As my text file contains Unicode characters, I need those Unicode to be saved inside the text file.
Why it have different if I use the Lock view for the project inside macro? Any suggestion?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks