Export a query to Excel

[Simon]

Dear reader,

With the export command you can export a query to Excel.

By activate this command a form pop's up with the following text:

"The database object "Name.." already exist. Do you want to replace the
existing database object with the one you are exporting? If you want to
export this object without replacing the existing database object, click no.
You can then export the object again and rename it in the export dialog
box."

In case selecting [Yes] the Excel sheet with the same name will be replaced
and the other sheets in the Excel file remains unchanged. And this is watt I
want.

If I do the same with the following code:

DoCmd.OpenQuery "QueryName.."

DoCmd.RunCommand acCmdOutputToExcel

There is no warning that the Excel file exists and will be overwrite.

Is there code available with is doing the same as the "Export" command, only
replacing the Excel sheet with the same name as the query.

Thanks for any help.

Kind regards,

Simon

[salad]

Simon wrote:

Dear reader,

With the export command you can export a query to Excel.

By activate this command a form pop's up with the following text:

"The database object "Name.." already exist. Do you want to replace the
existing database object with the one you are exporting? If you want to
export this object without replacing the existing database object, click no.
You can then export the object again and rename it in the export dialog
box."

In case selecting [Yes] the Excel sheet with the same name will be replaced
and the other sheets in the Excel file remains unchanged. And this is watt I
want.

If I do the same with the following code:

DoCmd.OpenQuery "QueryName.."

DoCmd.RunCommand acCmdOutputToExcel

There is no warning that the Excel file exists and will be overwrite.

Is there code available with is doing the same as the "Export" command, only
replacing the Excel sheet with the same name as the query.

Thanks for any help.

Kind regards,

Simon

Don't know. But perhaps you could try TransferSpreadsheet instead.

Enter
TransferSpreadsheet
in a code module, highlight it, and press F1.

[Simon]

TransferSpreadsheet is for import (Excel to Access) I am looking for export
(Access to Excel)

"salad" <oi*@vinegar.comschreef in bericht
news:j6**************@newsread3.news.pas.earthlink .net...

Simon wrote:

Dear reader,

With the export command you can export a query to Excel.

By activate this command a form pop's up with the following text:

"The database object "Name.." already exist. Do you want to replace the
existing database object with the one you are exporting? If you want to
export this object without replacing the existing database object, click

no.

You can then export the object again and rename it in the export dialog
box."

In case selecting [Yes] the Excel sheet with the same name will be

replaced

and the other sheets in the Excel file remains unchanged. And this is

watt I

want.

If I do the same with the following code:

DoCmd.OpenQuery "QueryName.."

DoCmd.RunCommand acCmdOutputToExcel

There is no warning that the Excel file exists and will be overwrite.

Is there code available with is doing the same as the "Export" command,

only

replacing the Excel sheet with the same name as the query.

Thanks for any help.

Kind regards,

Simon

Don't know. But perhaps you could try TransferSpreadsheet instead.

Enter
TransferSpreadsheet
in a code module, highlight it, and press F1.

[Jeff Smith]

"Simon" <Sv********@Versatel.nlwrote in message
news:45***********************@news.tele2.nl...

Dear reader,

With the export command you can export a query to Excel.

By activate this command a form pop's up with the following text:

"The database object "Name.." already exist. Do you want to replace the
existing database object with the one you are exporting? If you want to
export this object without replacing the existing database object, click
no.
You can then export the object again and rename it in the export dialog
box."

In case selecting [Yes] the Excel sheet with the same name will be
replaced
and the other sheets in the Excel file remains unchanged. And this is watt
I
want.

If I do the same with the following code:

DoCmd.OpenQuery "QueryName.."

DoCmd.RunCommand acCmdOutputToExcel

There is no warning that the Excel file exists and will be overwrite.

Is there code available with is doing the same as the "Export" command,
only
replacing the Excel sheet with the same name as the query.

Thanks for any help.

Kind regards,

Simon

You mention about replacing the Excel sheet. Are you talking about the
worksheet (e.g. Sheet1, Sheet2 etc) or do you mean the Excel workbook (e.g.
C:\test\Book1.xls)?

If you mean you want to check if the workbook exists and prompt to replace
it, check out the "Dir" function in the VBA help file and write some code
using this function to check if the files exists.

You also replied to Salad that TransferSpreadsheet is for importing. I also
ask you to check the VBA help file for this command.

Jeff

[salad]

Simon wrote:

TransferSpreadsheet is for import (Excel to Access) I am looking for export
(Access to Excel)

That's new to me. You should be able to import, link, or export.

>
"salad" <oi*@vinegar.comschreef in bericht
news:j6**************@newsread3.news.pas.earthlink .net...

>>Simon wrote:

>>Dear reader,

With the export command you can export a query to Excel.

By activate this command a form pop's up with the following text:

"The database object "Name.." already exist. Do you want to replace the
existing database object with the one you are exporting? If you want to
export this object without replacing the existing database object, click

no.

>>>You can then export the object again and rename it in the export dialog
box."

In case selecting [Yes] the Excel sheet with the same name will be

replaced

>>>and the other sheets in the Excel file remains unchanged. And this is

watt I

>>>want.

If I do the same with the following code:

DoCmd.OpenQuery "QueryName.."

DoCmd.RunCommand acCmdOutputToExcel

There is no warning that the Excel file exists and will be overwrite.

Is there code available with is doing the same as the "Export" command,

only

>>>replacing the Excel sheet with the same name as the query.

Thanks for any help.

Kind regards,

Simon

Don't know. But perhaps you could try TransferSpreadsheet instead.

Enter
TransferSpreadsheet
in a code module, highlight it, and press F1.

[Kc-Mass]

Transferspreadsheet goes both ways.
"Simon" <Sv********@Versatel.nlwrote in message
news:45***********************@news.tele2.nl...

TransferSpreadsheet is for import (Excel to Access) I am looking for
export
(Access to Excel)

"salad" <oi*@vinegar.comschreef in bericht
news:j6**************@newsread3.news.pas.earthlink .net...

>Simon wrote:

Dear reader,

With the export command you can export a query to Excel.

By activate this command a form pop's up with the following text:

"The database object "Name.." already exist. Do you want to replace the
existing database object with the one you are exporting? If you want to
export this object without replacing the existing database object,
click

no.

You can then export the object again and rename it in the export dialog
box."

In case selecting [Yes] the Excel sheet with the same name will be

replaced

and the other sheets in the Excel file remains unchanged. And this is

watt I

want.

If I do the same with the following code:

DoCmd.OpenQuery "QueryName.."

DoCmd.RunCommand acCmdOutputToExcel

There is no warning that the Excel file exists and will be overwrite.

Is there code available with is doing the same as the "Export" command,

only

replacing the Excel sheet with the same name as the query.

Thanks for any help.

Kind regards,

Simon

Don't know. But perhaps you could try TransferSpreadsheet instead.

Enter
TransferSpreadsheet
in a code module, highlight it, and press F1.