Re: Controlling free Excel reader with VB or VBA?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Stefan Berglund (keepit_at_in.thegroups)
Date: 03/30/04


Date: Mon, 29 Mar 2004 22:03:15 -0800

On Mon, 29 Mar 2004 16:23:24 -0700, "Ed"
<ed_millis@removethis.hotmail.com> wrote:
 in <eLv#4SeFEHA.3548@TK2MSFTNGP10.phx.gbl>

>"Matt Williamson" <ih8spam@spamsux.org> wrote in message
>news:OoEMXQdFEHA.3032@TK2MSFTNGP09.phx.gbl...
>> Ed-
>>
>> I'd import the Excel file into an Access database and write the user
>> interface for that in VB. I'd use ADO, but anything will work.
>
>
>Matt - I'm not at all familiar with ADO (I'm just getting my feet wet with
>VB). Is there perhaps a web page with a brief description? Or a
>recommended book that will give me a basic learner's tutorial?
>
>Thanks for the help.
>Ed
>

In addition to what Matt has said, your users won't need Excel or
Access installed if you use ADO.

---
Stefan Berglund
first shift-minus last a t m s n d o t c o m


Relevant Pages

  • ADO connection Open failure
    ... At some point in the code I'm using ADO to export an Access dataset. ... Access database on the shared drive; ... The Excel file is using the following references: ... Microsoft Office 11.0 Object Library ...
    (microsoft.public.excel.programming)
  • Re: Controlling free Excel reader with VB or VBA?
    ... >> I'd import the Excel file into an Access database and write the user ... >> interface for that in VB. ... I'd use ADO, but anything will work. ...
    (microsoft.public.excel.programming)
  • Re: Controlling free Excel reader with VB or VBA?
    ... "Matt Williamson" wrote in message ... > I'd import the Excel file into an Access database and write the user ... > interface for that in VB. ... I'd use ADO, but anything will work. ...
    (microsoft.public.excel.programming)
  • Re: Controlling free Excel reader with VB or VBA?
    ... "Matt Williamson" wrote in message ... > I'd import the Excel file into an Access database and write the user ... > interface for that in VB. ... I'd use ADO, but anything will work. ...
    (microsoft.public.vb.general.discussion)
  • connect to an excell line chart: how to do it?
    ... I need to create a line chart in excel and then use my VB application to ... connect to the excel file. ... I'm using ADO to connect to my existing Access database ...
    (microsoft.public.vb.database.ado)