In Access 2007, I am currently using the following code to generate an excel
file from a normal select query and it work fine.
In my code, I am building parts of the statement based on data that is
stored in tables.
"s" = a string that represents the name of the query
"p" = a concatenated string that represents the files Path, files Name,
and files extention

DoCmd.OutputTo acOutputQuery, s, acFormatXLS, p, False

My question is what would the code be if the query needed to have parameters
passed in?

Can anyone help me with this?

Here's one way:
http://www.datapigtechnologies.com/AccessMain.htm

Go to the bottom of the page and download this file: 'DataPig Access
Explosion'

Here's a video on how it works:
http://www.datapigtechnologies.com/f...explosion.html

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"mr3316a" wrote:

> In Access 2007, I am currently using the following code to generate an excel
> file from a normal select query and it work fine.
> In my code, I am building parts of the statement based on data that is
> stored in tables.
> "s" = a string that represents the name of the query
> "p" = a concatenated string that represents the files Path, files Name,
> and files extention
>
> DoCmd.OutputTo acOutputQuery, s, acFormatXLS, p, False
>
> My question is what would the code be if the query needed to have parameters
> passed in?
>
> Can anyone help me with this?

Almost forgot about this:
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

How could I forget about this??!!!!

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ryguy7272" wrote:

> Here's one way:
> http://www.datapigtechnologies.com/AccessMain.htm
>
> Go to the bottom of the page and download this file: 'DataPig Access
> Explosion'
>
> Here's a video on how it works:
> http://www.datapigtechnologies.com/f...explosion.html
>
> --
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''.
>
>
> "mr3316a" wrote:
>
> > In Access 2007, I am currently using the following code to generate an excel
> > file from a normal select query and it work fine.
> > In my code, I am building parts of the statement based on data that is
> > stored in tables.
> > "s" = a string that represents the name of the query
> > "p" = a concatenated string that represents the files Path, files Name,
> > and files extention
> >
> > DoCmd.OutputTo acOutputQuery, s, acFormatXLS, p, False
> >
> > My question is what would the code be if the query needed to have parameters
> > passed in?
> >
> > Can anyone help me with this?

Thanks for your help!
I found you app very interesting, and it gave me a lot of ideas, in
particular instead of gerneration mulipule spreadsheets that I would have to
then create attachments to an e-mail, create 1 spreadsheet with multiples
tabs 1 for each report. Then only have 1 attachment.
Thanks again
Mark

"ryguy7272" wrote:

> Almost forgot about this:
> http://www.accessmvp.com/KDSnell/EXCEL_Export.htm
>
> How could I forget about this??!!!!
>
> --
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''.
>
>
> "ryguy7272" wrote:
>
> > Here's one way:
> > http://www.datapigtechnologies.com/AccessMain.htm
> >
> > Go to the bottom of the page and download this file: 'DataPig Access
> > Explosion'
> >
> > Here's a video on how it works:
> > http://www.datapigtechnologies.com/f...explosion.html
> >
> > --
> > Ryan---
> > If this information was helpful, please indicate this by clicking ''Yes''.
> >
> >
> > "mr3316a" wrote:
> >
> > > In Access 2007, I am currently using the following code to generate an excel
> > > file from a normal select query and it work fine.
> > > In my code, I am building parts of the statement based on data that is
> > > stored in tables.
> > > "s" = a string that represents the name of the query
> > > "p" = a concatenated string that represents the files Path, files Name,
> > > and files extention
> > >
> > > DoCmd.OutputTo acOutputQuery, s, acFormatXLS, p, False
> > >
> > > My question is what would the code be if the query needed to have parameters
> > > passed in?
> > >
> > > Can anyone help me with this?

"ryguy7272" <(E-Mail Removed)> wrote in message
news:FD31EC3E-835A-48BC-9BCF-(E-Mail Removed)...
> Almost forgot about this:
> http://www.accessmvp.com/KDSnell/EXCEL_Export.htm
>
> How could I forget about this??!!!!

<BIG GRIN and CHUCKLE>

--

Ken Snell
http://www.accessmvp.com/KDSnell/