Need help on DDERequest on Excel

arkhilles · Post by **arkhilles** » Mon Apr 10, 2006 10:00 pm

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?

JRL · Post by **JRL** » Tue Apr 11, 2006 5:07 am

HERE is good help on DDERequest>

You can move through the sheets using ctrl + page up or page down.

Press CTRL
Press Page Up
Release CTRL

Hope this helps,
Dick

Me_again · Post by **Me_again** » Tue Apr 11, 2006 1:54 pm

JRL wrote:You can move through the sheets using ctrl + page up or page down.

Press CTRL
Press Page Up
Release CTRL

Hope this helps,
Dick

My experience is that regardless of which sheet is on top/active (which is what CTRL Page Up/Down selects in excel), DDERequest appears to always return the value from the first (leftmost tab), not the active, sheet in the workbook. The only way (I have found so far) to change which sheet is accessed is to move that sheet to be the first in the workbook with Edit, Move or Copy Sheet.

arkhilles · Post by **arkhilles** » Tue Apr 11, 2006 7:48 pm

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.