Exporting to excel

[icekube88]

In exporting database(im using VB connected to a Access DB) to excel how can i format the cell to fit the text when exported.

e.g.
cell A1
------------------
| Some text here |
------------------

what happen when i exported it is like

-----------
| Some tex|
-----------

some word cant be read.

 

[HarleyQuinn]

Hi,

The Excel macro recorder is your friend in these situations.

The code:

'Cells.Select 'can be included but isn't necessary
    Cells.EntireColumn.AutoFit

Should do exactly what you want.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[SkipVought]

Just to be a bit more rigerous, you must also reference the appliation.workbook.sheet for the range you are formatting.

Skip,
[sub]
[red][/red]
[/sub]

 

[HarleyQuinn]

Agreed Skip, that should avoid any problems with multiple sheets.

Cheers

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[icekube88]

in macro how do you determine the cellname of the cell
e.g. cells(1,1)


what should appear is not the value of the cell but the name which is A1

 

[strongm]

I think this second question has been answered in thread222-1275184