Access Open Excel Read Only File

[John]

I have an app that opens an Excel spreadsheet which is password protected. I
don't have the password but I am allowed to open as Read Only. I only need
read only access but don't know the syntax to send for automation. Here's how
I do it now....

objXL.Application.Workbooks.Open WorkbookName

Also, is there a good online (free!) reference for Excel Automation commands?

 

[Alex Dybenko]

Hi,
you can look at Excel VBA reference. Furthermore - you can do a following
trick with Access - start macro recorder in Excel, do whatever you need,
stop macro recorder and look as a code excel generated

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Klatuu]

You already have one. VBA Editor Object Browser.

 

[John]

Thanks. Now I just need to figure out how put the pieces together! Appreciate
the quick response!

 

[John]

GREAT HELP! Thanks, Alex!

Hi,
you can look at Excel VBA reference. Furthermore - you can do a following
trick with Access - start macro recorder in Excel, do whatever you need,
stop macro recorder and look as a code excel generated

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com