Excel import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Cyberspace,
I am attempting to write my Access query (3 cells) to certain cells on one
Excel spreadsheet but I don't know the syntax to specify the worksheet, only
the filename in the Output To field in the Macro box. Can one specify the
worksheet cell range in addition to the filename in this case? Thank you in
advance for your reply!
 
Hi Mary,

You can't do this with the OutputTo macro action, but give it a try with
TransferSpreadsheet. Set the Transfer Type to Export, and use something
like this for the Range argument:

Sheet1$A3:C3

Alternatively, define a named range in Excel covering your three cells
(which must be a contiguous rectangular block) and use the name of the
range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Access 2002 truncates text when linking to Excel 2002 1
Importing different worksheets from multiple Excel files 1

Back
Top