Sendkeys not working Alternative code?

[mpezzuto]

I am trying to refresh and factset excel template with vba, I am trying to use sendkeys to use the hot keys that will kick off the refresh.

The code I am using is this

Application.SendKeys ("%srw")

which works by itself but not with other code. ( I am cycling through portfolios and getting data for it, then printing to pdf. )

Is there anyway to get this to work or an alternative?

Thanks

 

[Logit]

.
Application.SendKeys ("%srw") opens the SHARE WORKBOOK window here.

Curious, what does the command do there ?