Passworded Excel File

Legacy Poster

• 2013年03月08日 04:52

Hi,

Can someone please help me I have an Excel file with a password to open it and I need help in how to get BarTender to open this file.

 

Thanks

David.

0

• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2013年03月25日 08:16

  Normally with a password protected database you will need to supply the password in the database set-up options.  Do you have it?  However, I vaguely remember that for Excel that this might be a show stopper -- not sure though.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2013年04月03日 05:25

  Yes I do and I have also tried to create a file my self and get no where.

   

  It worked OK with office 2003 but corporate upgraded there office to 2007 and this is when it broke I have also tried it on 2010 and it still dose not work.

   

  Also the database setup wants a username and password Excel files do not have a username only password that I know of.

   

  David.

  0
• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2013年04月17日 16:02

  Unfortunately Microsoft's OLE DB and ODBC drivers do not support password protected Excel files.   Not supported I'm afraid.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2013年10月04日 03:20

  So why dose my Customer have it work with Office 2003 on the same OS?

  0
• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2013年10月04日 14:07

  You mean Excel 2003?  I don't know myself, I guess Microsoft changed something, which they're apt to do.

  0

请先登录再写评论。