Excel 2010 VBA--Excel Connection to Access query

[ghcrazy8]

I've written an Excel macro to change the Access Query Excel is connected to. This worked perfected in Excel 2003, but in Excel 2010, Excel won't allow access to this macro. The file is a Macro-Enabled formatted file. I've looked at the Trust Center.

Any thoughts on what could preventing access to this macro?

Thank you for any input.

Leslie

 

[SkipVought]

hi,

Please post your code.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]