Protected VB code - Run-time error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My code runs fine, however when I protect the code from viewing I get the
following run-time error:

Method 'SaveAs' of object'_Workbook' failed

Here is the only code I have for saving the file:
ActiveWorkbook.SaveAs Filename:=SourceName, FileFormat:=xlTextPrinter,
CreateBackup:=False

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert a macro that was created in 2003 Excel to 2007 8
Protecting VBA (Excel) code 5
SaveAS dialog box gives run time error 1004 in Excel VBA 3
Export worksheet to .csv 3
Error on ActiveWorkbook.SaveAs method 3
Module protection & Shell issues 1
Simplify save code 11
SaveAs *.txt - Outputting with Text quantifiers 4

Back
Top