VB Access to Excell - Visual Basic .NET

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?

Aug 7 '06 #1

Subscribe Post Reply

939

Scott M.

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.
<co******@students.rowan.eduwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

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?

Aug 7 '06 #2

Similar topics

MS Access => MySQL

by: DD | last post by:

hi there, I don't think it's possible, but I'll try the question. A friend of mine mailed me a access database (.mdb), but I only use Linux (RH 9.0) . Is there anyway that I can open the...

MySQL Database

How to create graphs and print reports from access

by: banderas | last post by:

Just wondering if it is possible to use access to create grpahs and even print reports? Is it possible to link excell with access so one can be the date base and when graphs and analytical reports...

Microsoft Access / VBA

Download/Importing a single Access record from a removeable data media ie 3.5" disk or USB drive

by: S. Graefner | last post by:

I have been unable to locate anywhere the answer to my problem. I would like to be able to download/import a single record. This record is stored in many different related (one to one) tables. I...

Microsoft Access / VBA

Is there any known procedure to move the data from an excell sheet to a well designed DB in Access ?

by: Hi5 | last post by:

Hi, I have designed a databasewhich is now able to store all data from my client's Excel sheet.Now I am looking for a good way to move their data into this Db. If I want to do this myself will...

Microsoft Access / VBA

MS Access And Excell data access through c++(API ,Connector,etc)

by: shahoo | last post by:

Hi there , can anyone please tell me how I can access the data stored in a MS Access & Excell through c++ ? I have searched this group for a similar topic ,but they use VC++ and MFC.I want...

C / C++

Excell Interop Problem

by: Delforce | last post by:

Hi all, My application allows you to create a new excel file and then double click it in the list view to start it in excell. If the excell file is an existing one then I can start it now...

.NET Framework

Excel sheet in Access

by: Zerin | last post by:

I have to develop a database in access and VB 2005 will be in front view. Some results are send to this software in .csv format and .jpg format and I have to store it in the database.Now, for .csv...

Microsoft Access / VBA

How to post data from MS-Access to MS-Excell using ASP !

by: Aniasp | last post by:

hi Please let me know the procedure to post data from MS-Access to MS-Excell using ASP ! as well as Excell to Access ! Plz ! Thanks.

ASP / Active Server Pages

Fetching Data from Excell Sheets...

by: Ali Rizwan | last post by:

Hi all, I m creating a database. The data for database will fetched from an excell sheet. Now how can i read an excell sheet and update my database with that excell sheet. Or I want to show...

Visual Basic 4 / 5 / 6

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General