> 1. define "bells and whistles"
2. play with Excel Macros
3. Check the Excel NG
Sorry, I should have defined "bells and whistles". From my VBA code I
can resize the columns to AutoFit. I want to do other formatting like
making the header row bold, add additional tabs to the Excel document,
etc. Below is the code so far.
You know when you press the period (".") on a control it will pop up
the methods and properties for that control. I do not get that to
give me the properties that I can change.
I would like a website that would show the properties that I can use.
Anybody know of a good one?
CODE:
----------
DoCmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel9,
"DailyFollowUpForCash",
"H:\Temp\DailyFollowUpForCash.xls",
True
Set objExcelApp = CreateObject("Excel.Application")
objExcelApp.workbooks.Open "H:\Temp\DailyFollowUpForCash.xls"
objExcelApp.Visible = False
objExcelApp.Columns("A:G").EntireColumn.AutoFit
objExcelApp.ActiveWorkbook.Save
objExcelApp.workbooks.Close
objExcelApp.Quit
Set objExcelApp = Nothing