View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Link between files with vba

Possibly treat your workbook as a database and use ADO

http://www.erlandsendata.no/english/...odao/index.php

However, I would suspect this would be slow if used in a worksheet function.

Perhaps you can do it using the old Excel 4 style macros.

--
Regards,
Tom Ogilvy

"syaronc " wrote in message
...
Do you have a creative idea how to bypass this problem ? in the second
file i have money data that i don't want unothorized users to see...
Yaron


---
Message posted from http://www.ExcelForum.com/