generating excel sheets from access

[progressive7]

I want my users to be able to enter information in to an access form.

Once this information has been entered i want to be able to generate a number of sheets based on the information supplied. however it appears that access only does a raw dump of information in to excel and i am unable to control how this information is layed out either with commands from within access or by supplying a excel template.

does anyone have any suggestions

Thanks

 

[PaulBricker]

You probably need to supply us with more information to get a reasonable answer. You can run a routine that puts information into specific sheets if you want but but knowing how the info is set up will make a difference.

Paul

 

[progressive7]

basically the database is to be used for generating test script templates. the scripts break down in the following way

Module > Test Script > Variation > Extension

Module is the top level corrosponding to a section in the requirements document

Test Script is for a section with in the module

Variations and extensions are of the test script

so i want someone toenter detail all of the information that we include in the scripts namely title, description, member of, and number of steps involved.

as for the contents of these scripts that will be done manaually as the analyst writes them.

so i have a layout template for the module which is a workbook containing all of the scripts extension and varitions as seperate sheet. in effect what i am after is a way of controlling what information goes in to the cells that i tell it to

 

[PaulBricker]

So you need Cell as well as sheets. I would suggest you repost your question here.

forum707 There are some very talented Excel folks here.

Paul

 

[kpal29]

You can create one or more queries in access separating
the data you need. You can then setup your tabs in Excel
and get external data from data menu.
Choose Access as source and choose the query that
has the info you need. Then you can set the cell range
from here.