View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
richiverse718
 
Posts: n/a
Default Linking workbook and range protected Excel sheet to Access


I am trying to link an excel spreadsheet to Access and retain the
workbook and range protected sheets. I know the passwords but I cannot
create queries in Access without having the spreadsheets open. Is there
any way I can keep the excel sheet unopened and link it to Access?


--
richiverse718
------------------------------------------------------------------------
richiverse718's Profile: http://www.excelforum.com/member.php...o&userid=32655
View this thread: http://www.excelforum.com/showthread...hreadid=524614