I agree DDE should be more flexible - the tip from JRL about CTRL gave me an idea. We can use CTRL+G and then I can type in the name of the tab. Thanks for the help !!! You guys are great.

Hi - I am pulling my hair out trying get data out of an excel workbook with many worksheets. Here is what I have tried.

DDERequest>Excel,[filename],Sheets(Resources).R%r%C1,field_1,10

but I guess this is incorrect because it just hangs up the macro scheduler.

Has anyone figured this out?