Controlling free Excel reader with VB or VBA?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I've been asked to create a searchable database-type list for several
people. I can't guarantee they will all have compatible versions of Excel,
if they have it at all! So I was thinking of the free Excel reader. But
that still leaves the search functions. I'm going to assume the free reader
does not include VBA capabilities - if I'm wrong, this would help a lot! If
I'm correct, though, can the reader be controlled through VB? Am I trying
to make pigs fly?

Ed
 
I've been asked to create a searchable database-type list for several
people. I can't guarantee they will all have compatible versions of Excel,
if they have it at all! So I was thinking of the free Excel reader. But
that still leaves the search functions. I'm going to assume the free reader
does not include VBA capabilities - if I'm wrong, this would help a lot! If
I'm correct, though, can the reader be controlled through VB? Am I trying
to make pigs fly?
Click to expand...

What does this "searchable database-type list" look like? I'm asking "what
does the list itself look like". Are you mentioning Excel simply because you
want to use its built-in search capabilities, or does something else in your
project **require** that Excel be used? What I'm trying to find out is
"exactly what functionality are you ultimately after; not what you think you
might need to implement it".

Rick - MVP
 
Basically, it's just an index list. Think of store inventory, or meal
recipes - broad categories along with specific details. I'm thinking Excel
because that's what I've been using for the last year for a list I've built
at work that allows filtering, grouping, and searching. An Access database
would be nice, but fewer people would have Access than Excel. I'd like to
have a function that could add new items to the list, change existing
entries, and search for items matching certain parameters. Is there a
better way to do what I'm describing?

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

HTH

Matt
 
Matt Williamson said:
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.
Click to expand...


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
 
On Mon, 29 Mar 2004 16:23:24 -0700, "Ed"
in said:
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
Click to expand...

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