Using VBA .FieldNames in Excel 2007

[eoinymc]

Hi,

I was wondering if you can help me.

I'm trying to hide my field names while pulling a SQL query using VBA in Excel 2007.

I tried to use:

.FieldNames = False

However, it is giving me an error...

This works fine when I use it in Excel 2000...is there new code to use in 2007 or should this work?

If you need anymore information, please let me know.

Cheers,

Eoin