VB Access to Excell

  • Thread starter Thread starter corvoc58
  • Start date Start date
C

corvoc58

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Microsoft Works to Microsoft Office 6
Hidden column becoming unhidden upon forwarding 2
Excel AddIn - Keeping windows form always visible while w/in Excel 0
Hidden Excel Workbook after automation 13
Cannot unhide the hidden rows in my spreadsheet 3
Exporting to Excel 1
Access #Error & Excel Pivot 0

Back
Top