format an excel column from within access?

[Eric]

I'm looking for way to format a column in an excel
spreadsheet to Category = Currency and and Symbol = ?
Dutch(Belgium). I'm quite sure that this can be done
using VBA but I don't know the correct syntax.

Any help is most appreciated.

 

[Douglas J. Steele]

My usual approach is to record a macro in Excel that does what I want, then
take that VBA code, modify it appropriately (can't use ActiveWorksheet,
ActiveWorkbook and that sort of stuff) and use it in my Access modules that
use Automation.

If you're not familiar with Excel Automation at all, take a look at
http://www.mvps.org/access/modules/mdl0006.htm at "The Access Web"

 

[Guest]

Thanks very much Dough!!!

-----Original Message-----
My usual approach is to record a macro in Excel that does what I want, then
take that VBA code, modify it appropriately (can't use ActiveWorksheet,
ActiveWorkbook and that sort of stuff) and use it in my Access modules that
use Automation.

If you're not familiar with Excel Automation at all, take a look at
http://www.mvps.org/access/modules/mdl0006.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)





.