Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding a column to an excel report

Status
Not open for further replies.

bobg4u

IS-IT--Management
Jun 3, 2003
46
CA
Hi,
I have a macro to open and save a report as Excel. I need to add a column to that Excel Spreadsheet.Can someone who has done that before tell me how to do that.

thanks
bob
 
It should just automatically save your columns to Excel. Where is the column you are adding coming from?


CP [cook]
 
I wanted to add an extra column which user needs to fill in.It is not a database column.
I thought I'd generate the spreadsheet and then from the macro add a column to it.But,I figured out that I could use a calculation column in the .imr, with a default value of blank,and this would come up as a column in the Excel spreadsheet.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top