 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / January 2005How to specify a Sheet and Range
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 Sheet names must be separated from a cell address by the ! character: Sheet1!A4  SignatureKen Snell <MS ACCESS MVP> > 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 [quoted text clipped - 6 lines] > Thanks, > Frank 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. > Sheet names must be separated from a cell address by the ! character: > [quoted text clipped - 10 lines] > > Thanks, > > Frank 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. > I still get an error: "Sheet1$A4 is not a valid name..." The Range has > Sheet1!A4, but the error shows the $ instead. [quoted text clipped - 16 lines] > > > Thanks, > > > Frank 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 > 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 [quoted text clipped - 24 lines] > > > > Thanks, > > > > Frank 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. SignatureKen Snell <MS ACCESS MVP> >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 [quoted text clipped - 42 lines] >> > > > Thanks, >> > > > Frank |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.