insert a row into an excel book

[jnewl]

there are master books by region that are in excel books but do not have a
header.

each time i process a region, i want to save the master books as an excel
book called inputfile. i will then import that spreadsheet into access and
create a table. then do several queries and updates from that point.

i want a constant header on the inputfile. how can i in vb, insert a row,
as the first row into the inputfile for the 5 fields, and then execute the
transferspreadsheet command.

the 5 fields are code, modifier, rate1, rate2, term date

thanks for your help

 

[fredg]

there are master books by region that are in excel books but do not have a
header.

each time i process a region, i want to save the master books as an excel
book called inputfile. i will then import that spreadsheet into access and
create a table. then do several queries and updates from that point.

i want a constant header on the inputfile. how can i in vb, insert a row,
as the first row into the inputfile for the 5 fields, and then execute the
transferspreadsheet command.

the 5 fields are code, modifier, rate1, rate2, term date

thanks for your help

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using. I would suggest you include your Windows and Office version
number in the message.