I am writing a custom Access routine to populate a specific worksheet in an
Excel Workbook (the access transferspreadsheet and outputto will not let you
specify a specific worksheet). i've got this working. However, if the
worksheet I want to write to does not exist, I have to add it (no problem
here either).

However, I would like to add it as the last worksheet in the workbook, and
have not figured out how to do this. When I select the last worksheet, and
then add the new one, it inserts it before the last sheet rather than placing
it behind it. How can I, programmatically, change the order so the new sheet
becomes the last one in the workbook?

Dale,
Sheets.Add after:=Worksheets(Worksheets.Count)

"Dale Fye" wrote:

I am writing a custom Access routine to populate a specific worksheet in an
Excel Workbook (the access transferspreadsheet and outputto will not let you
specify a specific worksheet). i've got this working. However, if the
worksheet I want to write to does not exist, I have to add it (no problem
here either).

However, I would like to add it as the last worksheet in the workbook, and
have not figured out how to do this. When I select the last worksheet, and
then add the new one, it inserts it before the last sheet rather than placing
it behind it. How can I, programmatically, change the order so the new sheet
becomes the last one in the workbook?

Thanks,

I'll give it a try

"Toppers" wrote in message
...
Dale,
Sheets.Add after:=Worksheets(Worksheets.Count)

"Dale Fye" wrote:

I am writing a custom Access routine to populate a specific worksheet in
an
Excel Workbook (the access transferspreadsheet and outputto will not let
you
specify a specific worksheet). i've got this working. However, if the
worksheet I want to write to does not exist, I have to add it (no problem
here either).

However, I would like to add it as the last worksheet in the workbook,
and
have not figured out how to do this. When I select the last worksheet,
and
then add the new one, it inserts it before the last sheet rather than
placing
it behind it. How can I, programmatically, change the order so the new
sheet
becomes the last one in the workbook?