Export wordage vertically

[Guest]

Hi everyone! Using A02 on XP. Not a programmer but lovin' learnin'.

I am exporting some data to an Excel file and can't seem to bore down to the
one record I want when running my Transfer Spreadsheet macro.

I have a form that has a parameter [What contract number?] inquiry on the
underlying query. [GP0013]'s data is showing on my form. I want to export
that info. I have written the query name qCensus1Main in the Table Name
Action Argument line but get the parameter inquiry again. If I remove the
parameter, I get 742 records instead of just the one I need. My contract
number field on my form is: [Forms]![fCensus1Conversion]![GPNum]. How can
I say to run the query and use the GPNum showing?

Thanks in advance for any help or advice!

 

[Guest]

Hi, wanted to add that I have figured out how to export just the one record
but the data is being placed in cells A:1, B:1, C:1, etc. Can I get it to
place in cells A:1, A:2, A:3, etc. These are instructions that need to be
viewable and each cell contains 50+ words. I want them to be readable in
Excel.

 

[John Nurick]

Hi Bonnie,

There's no way of getting Access to export a record into a spreadsheet
column rather than a row without doing some serious programming. If you
want to go that way, post back here.

First, though, go to the Excel sheet and try out the Transpose option in
Paste Special. This may be all you need.

 

[Guest]

Hello John! Glad to see your name. Actually, perhaps I should have included
this in my post: I have data that exports to Excel, works great. Of course,
a user asks, "Well, can you include the instructions and the contract name
and number in the file?" So, what I need to do is 1. export data to an Excel
worksheet (done) and 2. export a few paragraphs of text, one of which will
include the contract name and number.

My problem is when I export the text, it lands in cells A1, B1, C1, etc. and
they are only the default width (ugh!) and I want the text to be BLAM! right
there on the worksheet.

I've created a report that has just one field containing all the text and
variable data. But, don't know how to send the report to Excel with a macro,
can only run Tools, Office Links, Analyze with Excel. I just want to add it
to the file I've created with my data. I'm trying whatever I can.

If I export data to an existing 'shell' file, how do I change the name of it
from Access?

Any suggestions or advice? Thanks in advance!!!

 

[John Nurick]

The macro equivalent of "Analyze with Excel" is OutputTo.