Formatting of Excle during Export from VB

[ssripada]

hI ,

I am currently exporting data(Reports) from MSFLEXGRID to Excel .Is there a way to format the columns in the Excle sheet because the users have to each time drag a column to look at the headers .

Appreciate a quick reply (My job depends on this)
Thanks

 

[Abdc]

Try recording a macro.

Alternatively, have a look at http://www.vacancies.ac.uk/

 

[PaddyD]

what do you mean by "drag a column"?

Paddy

 

[Swamp Thing]

In VB, use GetObject after creating the new xl file to get a reference to the workbook. You can then manipulate the book's properties in your VB app. Alternately (early binding) set a ref. to the excel library in your VB app.

Even more impressive is to put an OLE container on a form and put in an excel spreadsheet (instead of flexgrid). Then you can populate the sheet and save it, all in your VB app.
This message was edited by Swamp Thing on 2002-09-03 20:57

 

[ssripada]

Probabbly I dint explain better,
I currently have the excel object instantiated and the data populates into the excel shett and all that is fine.

The problem is in the display of the data in the excel sheet .All the columns (headers)dont autofit and the user has to again reformat the Display .

 

[Swamp Thing]

<pre>
Columns("A:J").Select
Selection.Columns.AutoFit</pre>

 

[dspl]

On 2002-09-04 08:05, Swamp Thing wrote:
<pre>
Columns("A:J").Select
Selection.Columns.AutoFit</pre>

Which is the sort of thing that would have been obtained if Abdc's suggestion had been followed.

(Would suggest that the job vacancy link be kept handy!)

 

[ssripada]

All of you who were so courteous to my problem

THANK YOU !!!! I LOST MY JOB