Re: Exporting Access data into excel using vb6

From: MikeD (nobody_at_nowhere.edu)
Date: 05/28/04 

Date: Fri, 28 May 2004 16:54:03 -0400

"JD" <jk_50@hotmail.com> wrote in message
news:Opxoj8MREHA.1004@TK2MSFTNGP10.phx.gbl...
> Here's my situation:
> I have data in an Access database. I created the queries that I can
> export to Excel manually from Access. I have a VB App that everyone uses.
> Certain users need all the data in the queries exported to excel. I want
> them to click an export button and bring up a dialog box which they can
> specify the filename and location of the data without someone doing it
> manually every time.

Fine. Great. Try to write this yourself. You've been told the basic steps
necessary. If you encounter problems for some specific aspect of the task,
ask a specific question. You sound like you're wanting someone to write the
whole thing for you and that's not going to happen (unless you're willing to
hire a contractor). The newsgroups are for getting help with a problem.
They're not here to solicit someone to write your program for you. There
are plenty of talented people here will be more than happy to volunteer
their time to help you, but you need to to attempt to write this yourself
and then ask questions about problems you encounter while writing it.

Mike