How do you perform CTRL & TAB together using Sendkeys with EXCEL VBA 2

[bkh]

Hi, can anyone help.
I need to be able to replicate the sendkeys command to perform the function of holding down the 'CTRL' key and 'TAB' key at the same time. I know that ^ is the CTRL and {TAB} is TAB but can't get the two to work together.
I am using Excel 97 on NT 4.0 and am trying to shell out to explorer select a file and it's properties and then get to the permissions. To do this I need to CTRL & TAB.
Does anyone have any ideas?

Many Thanks

Bryan

 

[JVFriederick]

One idea might be to use the ATTRIB and CACLS commands from the NT command line, redirect the output from the desired files to a text file, then process the text within Excel to post the results.

Seems like a lot of work ! !

 

[DarkSun]

Interaction.SendKeys "^{TAB}"