ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protected VB code - Run-time error (https://www.excelbanter.com/excel-programming/374984-protected-vbulletin-code-run-time-error.html)

AvalancheMike

Protected VB code - Run-time error
 
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

JLGWhiz

Protected VB code - Run-time error
 
Couldn't duplicate the error. Mine saves as without a problem and retains
the protection.

"AvalancheMike" wrote:

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



All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com