User Profile

Collapse

Profile Sidebar

Collapse
Murdockj
Murdockj
Last Activity: Nov 26 '14, 06:22 PM
Joined: Nov 26 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Murdockj
    replied to Help adding code to export column headers to Excel
    in Access
    I am not sure where or how I am to put this in the code? Working on this for so long I am getting lost.

    Here is the code to write to the spreadsheet:
    Code:
      With objSht
      .Range(.Cells(1, 1), .Cells(conMAX_ROWS, _
          intLastCol)).ClearContents
      .Range(.Cells(1, 1), _
        .Cells(1, rs.Fields.Count)).Font.Bold = True
      .Range("A2").CopyFromRecordset rs
    ...
    See more | Go to post

      Leave a comment:

    • Murdockj
      started a topic Help adding code to export column headers to Excel
      in Access

      Help adding code to export column headers to Excel

      I have been looking for a while to export a crosstab query from Access to an existing Excel spreadsheet. The data in the query is very dynamic as is the column count.

      I did find code on the net that will do exactly what I am looking to do. The only issue is that it does not transfer the column titles to the spreadsheet. I cannot post the code here as it is not allowed. I can post the link to the code however. The code I am using is the...
      See more | Go to post
      Last edited by Murdockj; Nov 26 '14, 04:17 PM. Reason: Spelling Corrections
      No activity results to display
      Show More
      Working...