Solved

Read from Excel

Posted on 2000-03-07
4
163 Views
Last Modified: 2010-05-02
Is there a way to make VB read whatever is in Excel and posting it onto a form. After reading it can it save it on an Access database by a click of a button??
I need the answer ASAP please.

Any help is appreciated thanks!
0
Comment
Question by:hello_200
  • 2
  • 2
4 Comments
 

Accepted Solution

by:
mbarreto022800 earned 25 total points
ID: 2595385
Here's a small example:

Dim Excel As New Excel.Application

Excel.Workbooks.Open "C:\ola.xls"
Excel.Application.Visible = False

MsgBox Excel.Application.Cells(1, 1).Value
0
 

Expert Comment

by:mbarreto022800
ID: 2595397
By the way you will need the Microsoft Excel 8.0 Object Library on your project (I'm not sure if there is a difference between versions).
0
 

Author Comment

by:hello_200
ID: 2607050
It is giving me an error message
"Invalid outside procedure"..plus the results will appear on a msgbox can't i put them in a text box?
0
 

Author Comment

by:hello_200
ID: 2607225
I have followed a different way of reading the information from excel and putting them in textboxes.
But thanks for your help!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Window placement 17 75
Write data from SQL to CSV file - position 1 52
Excel VBA, find a string in a column, update a cell 7 65
Excel Automation VBA 19 30
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now