PC Review


Reply
Thread Tools Rate Thread

Displaying Excel Workbooks In Access Forms

 
 
=?Utf-8?B?TURX?=
Guest
Posts: n/a
 
      19th Oct 2005
Is there a way for me to set up a "window" in a form into which I can load
(and, ideally, un-load) pre-existing Excel workbooks? Essentially, I'm going
to use the FileSystemObject to read all the files available in a given
folder, and the users will pick from a list box.

I want to display the workbook just as though it appears if you open it in
Excel (or conversely, how it would be displayed in MSIE if you opened a
spreadsheet on the Web). The users do not need to actually make changes to
the contents; I just want them to view the info that's on the sheets.

I'm using Access 2003. I tried creating an "MS Office Spreadsheet" control
to the form, but I don't see a property or method that would allow me to load
a saved workbook.

TIA.

--
Hmm...they have the Internet on COMPUTERS now!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Excel Workbooks versus Excel Workbooks Ken Microsoft Excel Programming 3 23rd Oct 2006 01:05 AM
suddenly my excel workbooks are "shared workbooks" =?Utf-8?B?TWFnZ2llJ3MgbW9t?= Microsoft Excel Misc 1 28th Aug 2005 09:20 PM
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed Frank Jones Microsoft Excel Programming 2 15th Jun 2004 03:21 AM
Linked workbooks will not update without having all workbooks open =?Utf-8?B?S2F0aGVyaW5l?= Microsoft Excel Misc 0 26th Feb 2004 06:16 PM
Workbooks.Open closes other workbooks S. Daum Microsoft Excel Programming 1 21st Aug 2003 07:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:55 AM.