How to specify a Sheet and Range

[FrankTimJr]

In the TransferSpreadsheet Action, I want to export a query to an existing
Excel spreadsheet to a specific sheet. In addition, I want the data in the
first cell / column in the query to be exported to a specific cell in the
sheet (not A1).

I've tried "Sheet1$A4" and I get an error. Is it even possible to specify
in the macro?
Thanks,
Frank

 

[Ken Snell [MVP]]

Sheet names must be separated from a cell address by the ! character:

Sheet1!A4

 

[FrankTimJr]

I still get an error: "Sheet1$A4 is not a valid name..." The Range has
Sheet1!A4, but the error shows the $ instead.

Does the spreadsheet type have anthing to do with it perhaps? I'm using
Excel 2003, and the type is set to Microsoft Excel 8-10.

 

[FrankTimJr]

It only errors out on me when I add the specific cell reference in the range.
If I take out the cell reference, the export will add an additional sheet
and puts the data into cell A1. I need to have it append the data in an
existing sheet and start in a specific cell.

Doesn't sound like this can be done.
Thanks.

 

[FrankTimJr]

I know this may not be the place to post this, but I figured out how to get
what I was looking for. I created a query in Excel to pull in the data from
the access database. You can create the query right on the cell you want
the data to be populated on. It's going in through the back way sort of, but
in the end, it's what I needed to happen.

Thanks for listening.
Frank

 

[Ken Snell [MVP]]

Sorry...I had misread your oriiginal post... I read "export" as "import" for
some reason.

TransferSpreadsheet does not support exporting to a specific cell, although
it's been posted by others that an undocumented feature is that it will
export to a specific sheet or named range. In your case, you're not doing
either of these options.