how to write a macro that will execute a command for an excel add-in

[xcelnovice101]

I would like to add a command to my macro that will do one simple step:
Refresh all FDS Codes

FDS I believe is short for FactSet Data Series. FactSet is an add-in for excel we use at work. The FactSet menu button is in my ribbon and when I choose that add-in, there are a number of actions I can execute. One is to refresh all FDS which is to refresh all cells with formulas that pull in data from our FactSet database.

I tried recording this action but VBA does not show any key strokes from those steps so I think I just experienced one of the many shortfalls of recording macros. Is there a way to write the macro to execute this action? I would think since I am using a FactSet add-in, it would be possible but I don't know where to begin.

 

[RekkaWrecks]

You can get around it manually with the SendKeys method. The keyboard shortcut to refresh all FDS codes is Alt+S1+R+T. The Microsoft help pages list the syntax as Application.SendKeys("Key",Wait), which didn't work at all for me. I got it to work by assigning the following to a CommandButton: SendKeys "%S1RT", True