Printable View
HI,
I've made a program that imports data from a database, makes a report and then exports them to excel to be printed. I've got this all working perfectly, but I have some problems arranging the lay-out in Excel from VB. I want some cells to have thick lines at their borders and I want text that's too big for a cell 'wrapped' to the next cell in the column(underlying cell). Can anyone help me? Even a correct objectmodel of Excel would help.
Thanx!!!
BaronQ
Hi!
I did not work much with it but you can try to record what you want to do in a macro of Excel and then edit the code of it. Take care to include the reference to the Excel Library and define an Object,which to work with.
Hope that helps.
Jaime.
I don't know if possible for your situation but, when I did as you have described, I used a template file with formatted cells, etc.
Thanx!! How stupid of me not to think of that myself. Well, all out of my problems now...
BaronQ
Thanx for the advice, but it's not an option in my case. It's for some sort of claimadministrationprogram which cannot be in a standardformat cause of thirdparty desires.
BaronQ
how did u go about doing that.
just help me out to import data from access and send it to excel (iam using version 2000).
and then can we imports charts from excel back to vb form
do reply
thanx