Sendkeys not working Alternative code?

mpezzuto

New Member
Joined
Mar 8, 2018
Messages
3
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

Well-known Member
Joined
Aug 31, 2016
Messages
2,942
.
Application.SendKeys ("%srw") opens the SHARE WORKBOOK window here.

Curious, what does the command do there ?
 

Forum statistics

Threads
1,085,863
Messages
5,386,395
Members
401,997
Latest member
cizwiz

Some videos you may like

This Week's Hot Topics

Top