okeyuzosike
Programmer
I used fuction:"CopyFromRecordset" to move data from access file to excel spreadsheet. When I display/print the contents of the spreadsheet, the records are too far apart. Also, each cell size is very large. How can I get the records to display/print normally, like close enough: for example like this:
When the spreadsheet is displayed, the data in the spreadsheet should look like this:
"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh"
"ukkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk"
NOT like this:
"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh"
"ukkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk"
I tried using the "MergeCells" function, it diplays only the first line of record in the first cell.
I wish there's a way I could insert the spreadsheet so you guys can see it.
Thank you for your anticipated assistance.
okey.
When the spreadsheet is displayed, the data in the spreadsheet should look like this:
"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh"
"ukkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk"
NOT like this:
"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh"
"ukkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk"
I tried using the "MergeCells" function, it diplays only the first line of record in the first cell.
I wish there's a way I could insert the spreadsheet so you guys can see it.
Thank you for your anticipated assistance.
okey.