var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Merging cells in excel from access
I do not know how to format this so that it works as this doesnt. I can't find any information through google and the help file doesn't sufficiently describe how to use. Any help would be appreciated..
exSheet.Range("A1", "Q1").Merge ()
Last edited by BigPaully; 08-28-08 at
Daft question, but have you set up a link to the Excel library?
Try recording a macro in Excel to merge cells, then copy the code to Access.
▲ Agreed, that's where I would start.
I can only suggest one correction here... "A1:Q1" would seem to be needed ... not ("A1" , "Q1"). As for the rest, not sure as I do almost zero communications with Excel from Access.
Owner and Manager of
. , Microsoft Access Development Specialists CypherBYTE
Microsoft Access . MCP
And all around nice guy! "Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "