Home     Products      Support      Corporate     Sign In 
Support Knowledge Base, Article 233
Product
ExcelWriter
Version
3.X
Title
Error: "Failed to open file, check file name and access rights"
Problem
When using the SoftArtisans.ExcelTemplate object to populate an existing workbook with data markers, you may see this error which refers to the "xlw.Open" line in your script:
Error Type:
SoftArtisans.ExcelTemplate.1 (0x80020009)
Failed to open file, check file name and access rights
Solution
This error occurs if ExcelWriter cannot open the workbook you are using as a template. The following are all possible causes for this error:
  1. The path to the workbook you are trying to open is invalid. Verify that you are using a valid path in the "xlw.Open" statement.
  2. You currently have the workbook open in Excel on the server when executing the script. Please be sure that you do not have your template workbook in use when you run your script.
  3. IIS cannot open the workbook due to insufficient NTFS permissions. Check the NTFS permissions to be sure that the impersonated web user has at least "Read" rights on the workbook.
Related Links
OfficeWriter Home Page
OfficeWriter Enterprise Edition
Latest OfficeWriter News
OfficeWriter: Programmatic Runtime Control

Created : 12/1/2002 12:00:00 AM (last modified : 12/14/2001 3:41:00 PM)
Rate this article!
Comments