Passworded Excel File 关注

0
Avatar
Legacy Poster

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.

5 评论

0
Avatar
Ian Cummings
版主
评论操作 固定链接

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
Avatar
Legacy Poster
评论操作 固定链接

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
Avatar
Ian Cummings
版主
评论操作 固定链接

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

0
Avatar
Legacy Poster
评论操作 固定链接

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

0
Avatar
Ian Cummings
版主
评论操作 固定链接

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

请先登录再写评论。