I have an app that gives a user an option to pull an online report into
Excel.
I have the rows formatted in a couple different colors, with a grey
header & footer.
No matter what colors the alternating (and regular) rows are between the
header & footer, they come out an off-white color.
Is there a way to programatically set the colors of cells when they're
exported to excel?
Second question - on the row above the header in the export page, I put
out a confidentiality message. Is there a way to have the background of
that cell a different color other than white? I want to do something to
highlight it or something, to make it stand out somewhat versus the rest
of the report.
Re: I love this forum! need help again! ... assume the header (you need headers for advanced filter) for the first names ... start in A3 and the names in A4, the last names and header starts in B3 ...Excel 95 - Excel 2007 ... of cells, which are contacts, that have the same first name, or last ... (microsoft.public.excel.worksheet.functions)
RE: Primer on exporting to specified range in existing Excel sprea ...Excel installed on the computer where you are doing the development. ... example of how to open a spreadsheet.... 'Set Up Recordset for ITM Header data... 'Format the ITM Name Cells... (microsoft.public.access.externaldata)
Re: Excel Headers ... Excel allows a user to create a header but the header is only displayed when ...Excel document that devoted the first seven rows to a header and then ... easily change and would require unneeded time to readjust the cells.... I am aiming for the column widths for the header and the column ... (microsoft.public.excel.misc)
Re: Excel Headers ... > Excel allows a user to create a header but the header is only displayed when ... I am trying to create an> Excel document that devoted the first seven rows to a header and then> remaining thousands of rows to a list of data. ... I do not want to merge cells as the header data could> easily change and would require unneeded time to readjust the cells. ... I am aiming for the column widths for the header and the column> widths for the table to be independent. ... (microsoft.public.excel.misc)
RE: exporting to excel via code ... from Access into Excel before? ... I have a series of tables that when combined make up a header file.... > loop until no headers are found (not sure how to phrase this start of the ... > entries for a single line header record.... (microsoft.public.access.modulesdaovba)
