Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msAccess Report Header export to Excel
I have no excel skills, only msAccess. I can successfully automate the exporting of my access report to excel using a macro's OutputTo command, output format excel. The header is the problem. I want my excel header to look like my multi line access report header. Instead it breaks each object up into 1 line of continuous cells. It should look like this: Left Aligned Date: 6/5/09 My Centered Report Title Left Aligned Check No.: 154 My Centered Company Name Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
msAccess Report Header export to Excel
The issue may only be formating. try highlighting row 1 of the spreadsheet.
the go to worksheet menu format - cells - alignment - Wrap Text. "slickdock" wrote: I have no excel skills, only msAccess. I can successfully automate the exporting of my access report to excel using a macro's OutputTo command, output format excel. The header is the problem. I want my excel header to look like my multi line access report header. Instead it breaks each object up into 1 line of continuous cells. It should look like this: Left Aligned Date: 6/5/09 My Centered Report Title Left Aligned Check No.: 154 My Centered Company Name Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
msAccess Report Header export to Excel
That didn't work. Also, maybe I should have been clear to say I don't want the user to have to do anything in excel; I would like to automate the process so the worksheet comes over with no more formatting needs. "Joel" wrote: The issue may only be formating. try highlighting row 1 of the spreadsheet. the go to worksheet menu format - cells - alignment - Wrap Text. "slickdock" wrote: I have no excel skills, only msAccess. I can successfully automate the exporting of my access report to excel using a macro's OutputTo command, output format excel. The header is the problem. I want my excel header to look like my multi line access report header. Instead it breaks each object up into 1 line of continuous cells. It should look like this: Left Aligned Date: 6/5/09 My Centered Report Title Left Aligned Check No.: 154 My Centered Company Name Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
msAccess Report Header export to Excel
How good are you with VBA programming in ACCESS. the excel portion of the code isn't too complicated. You can run this macro from access. Yo can get each row of data from the access database and write the data to the workbook Sub OpenExcel() Set excelobj = CreateObject("Excel.application") excelobj.Application.Visible = True With excelobj Set bk = excelobj.workbooks.Add With .sheets(1) 'write header row .Range("A1") = "Number" For RowCount = 2 To 100 .Range("A" & RowCount) = RowCount Next RowCount End With End With End Sub "slickdock" wrote: That didn't work. Also, maybe I should have been clear to say I don't want the user to have to do anything in excel; I would like to automate the process so the worksheet comes over with no more formatting needs. "Joel" wrote: The issue may only be formating. try highlighting row 1 of the spreadsheet. the go to worksheet menu format - cells - alignment - Wrap Text. "slickdock" wrote: I have no excel skills, only msAccess. I can successfully automate the exporting of my access report to excel using a macro's OutputTo command, output format excel. The header is the problem. I want my excel header to look like my multi line access report header. Instead it breaks each object up into 1 line of continuous cells. It should look like this: Left Aligned Date: 6/5/09 My Centered Report Title Left Aligned Check No.: 154 My Centered Company Name Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Business Contact Manager - problems with export of report to Excel | Excel Discussion (Misc queries) | |||
Export excel data to create report in Word | Excel Discussion (Misc queries) | |||
Add Header/Footer to excel report from ASP.. | Excel Discussion (Misc queries) | |||
Add Header/Footer to excel report from ASP.. | Excel Programming | |||
Header in Report Manager Report | Excel Discussion (Misc queries) |