Link excel protecte Workbook (1 Viewer)

erncelen

New member
Local time
Today, 12:21
Joined
Mar 21, 2004
Messages
7
Hi,

Anybody know how to link excel protected workbook?

any suggestion will be appreciated.

Thank in advance......
 

Parker

Registered User.
Local time
Today, 19:21
Joined
Jan 17, 2004
Messages
316
erncelen said:
Hi,

Anybody know how to link excel protected workbook?

any suggestion will be appreciated.

Thank in advance......

I don't think you can. Because of the way linking works, even using a routine that unprotects and the re locks wont work (at least I couln't get it to)

Why do you need to protect the workbook and link it with access?

Is there maybee another way you could achieve this?

Explain more about what it is you are trying to achieve and the circumstances that surround your protected data in Excel.
 

erncelen

New member
Local time
Today, 12:21
Joined
Mar 21, 2004
Messages
7
The workbook is protected because is not mine, I only have to retrieve some data from it, make queries, filters using access.

If it is not possible, I'll use VBA code.

Thank.
 

Parker

Registered User.
Local time
Today, 19:21
Joined
Jan 17, 2004
Messages
316
erncelen said:
The workbook is protected because is not mine, I only have to retrieve some data from it, make queries, filters using access.

If it is not possible, I'll use VBA code.

Thank.

This thing has been bugging me so I took another look.

If you open the workbook on your machine then you can link or import the worksheets

So dependant on how often the workbook is updated you may be able to get away with that and open the workbook first. The workbook will need to be open on your machine anytime you need to use it in Access. If not, as you say, you may be able to do it with VB. Although I'm not sure how VB would handle the encryption given to a protected WB
 

erncelen

New member
Local time
Today, 12:21
Joined
Mar 21, 2004
Messages
7
The excel workbook, is shared, and is not located on my machine.

Anyway, I'll connect to it, using VBA, setting a connection to the workbook adn adding password parameter.

Thank
 

Users who are viewing this thread

Top Bottom