Open Excel spreadsheet via Access VBA as Read-only

[Amras]

Good afternoon, all. Thanks for the taking the time to review my question. I thought that this should be easy, but I'm not able to find anything in either Google or Bing: I'm trying to open an Excel spreadsheet with VBA code in a 2010 MS Access db, but I want it to be a Read-Only copy of the spreadsheet. I've simply used Application.FollowHyperlink in the past, but I can't seem to find a parameter to open my referenced spreadsheet as a read-only copy. I apologize if this has already been addressed elsewhere; I couldn't find anything. If it's of any help, the path for the spreadsheet in question is "R:\Customer Contact Center\CS Assistance Documents\Exclusive and Incentivized Mail Order.xlsx". Any help will be appreciated!

[June7]

Can't use FollowHyperlink for that.

Would have to establish Excel object variables in VBA, set those variables, and manipulate the objects.

Otherwise, set the permissions on the Excel file to be read-only. That could also be done programmatically, but I've never tried. Review http://www.access-programmers.co.uk/...d.php?t=215253