Excel import and format

[vbridge]

I have an Access database that includes information that needs to go into an Excel workbook that is already created. I can import the information into an Excel spreadsheet, but it is nowhere near the format that I need it to be in. Is there a way, possibly using VBA, to get the information into the correct cells and in the correct format? I'd appreciate any help you can offer. Thanks!

Veronica

 

[AnotherHiggins]

Turn on the Macro Recorder in Excel and format the columns as you wish. Then observe the code to see how it was accomplished.

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.