Hi everyone:

I am tring to develop a product in MS Access. I have a query that uses VBA
programing to open an excel sheet and export data to it.

It works fine, except I would like to do some formatting like underlines and
bold and unfortunately I am getting application defined errors.

xlc.TextEffect.FontBold = True

I have not included the Excel 11 library in the reference, I am sure there
is where the goodies are, however, I am affaid if the user has a lower
version of Office what will occur, will it throw an error.

I have just called my objects in VBA like this to make it simple

Set xlx = CreateObject("Excel.Application")

Does anybody have any experience with this?

Thanks