VB Access to Excell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

corvoc58@students.rowan.edu - 07 Aug 2006 20:08 GMT

Can anyone help me find a programmatical way to avoid having an excel
workbook be hidden when data is transferd. I have created an MS Access
Database that can transfer various information into excell
spreadsheets, but when the spreadsheet file is opened the info is
hidden. Other then manually going and clicking unhide is their any code
that i can use to permenetly solve this problem?

Reply to this Message

Scott M. - 07 Aug 2006 21:01 GMT

If you want to work with Excel data, just make a project reference to the
Excel COM Library and program with the Excel object model. The actual excel
application will not become visible to the end user unless you instruct it
to.

> Can anyone help me find a programmatical way to avoid having an excel
> workbook be hidden when data is transferd. I have created an MS Access
> Database that can transfer various information into excell
> spreadsheets, but when the spreadsheet file is opened the info is
> hidden. Other then manually going and clicking unhide is their any code
> that i can use to permenetly solve this problem?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...