Macro creation involving external data plugin

%3CLINGO-SUB%20id%3D%22lingo-sub-1486875%22%20slang%3D%22en-US%22%3EMacro%20creation%20involving%20external%20data%20plugin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486875%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20create%20a%20macro%20which%20will%20allow%20me%20to%20automatically%20refresh%20the%20data%20in%20an%20Excel%20sheet.%26nbsp%3B%20The%20data%20is%20imported%20as%20an%20Excel%20file%20from%20a%20subscription%20data%20service.%26nbsp%3B%20The%20subscription%20service%20has%20an%20Excel%20plugin%20with%20a%20%22Refresh%22%20button.%26nbsp%3B%20The%20macro%20I%20am%20currently%20trying%20to%20create%20only%20involves%20recording%20this%20one%20refresh%20step%2C%20but%20I%20am%20hoping%20to%20be%20able%20to%20combine%20it%20with%20other%20steps%20to%20automate%20more%20complex%20processes%20in%20the%20future.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%2C%20I%20have%20successfully%20recorded%20this%20single%20step%2C%20but%20I%20don't%20believe%20it's%20working.%26nbsp%3B%20My%20thought%20is%20that%20since%20the%20command%20is%20connected%20to%20an%20external%20password%20protected%20data%20source%20it's%20currently%20not%20able%20to%20be%20completed.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20very%20appreciated!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1486875%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1487652%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20creation%20involving%20external%20data%20plugin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709245%22%20target%3D%22_blank%22%3E%40abby-12%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20there%2C%3C%2FP%3E%3CP%3EUnfortunately%20there%20isn't%20enough%20information%20for%20us%20to%20help%20you.%20We%20would%20need%20to%20know%20more%20specifics%20about%20how%20this%20data%20is%20accessed%2C%20or%20more%20importantly%20about%20the%20data%20source%20itself%2C%20to%20give%20any%20insight.%20Odds%20are%20yes%2C%20it%20can%20be%20done.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1488904%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20creation%20involving%20external%20data%20plugin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1488904%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20data%20source%20is%20Pitch%20Book.%26nbsp%3B%20I'm%20specifically%20downloading%20company's%20general%20and%20financial%20information.%26nbsp%3B%20I%20spoke%20with%20two%20of%20their%20support%20associates%20yesterday%2C%20and%20they%20both%20conferred%20with%20their%20team%20and%20said%20that%20it%20cannot%20be%20done.%20So%20I%20may%20be%20abandoning%20the%20attempt%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10842%22%20target%3D%22_blank%22%3E%40Zack%20Barresse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489833%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20creation%20involving%20external%20data%20plugin%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489833%22%20slang%3D%22en-US%22%3EIn%20cases%20like%20this%20I%20would%20request%20an%20API.%20Even%20a%20simple%20one%20isn't%20hard%20to%20make.%3C%2FLINGO-BODY%3E
New Contributor

I am attempting to create a macro which will allow me to automatically refresh the data in an Excel sheet.  The data is imported as an Excel file from a subscription data service.  The subscription service has an Excel plugin with a "Refresh" button.  The macro I am currently trying to create only involves recording this one refresh step, but I am hoping to be able to combine it with other steps to automate more complex processes in the future.  

So far, I have successfully recorded this single step, but I don't believe it's working.  My thought is that since the command is connected to an external password protected data source it's currently not able to be completed. 

 

Any help would be very appreciated! 

3 Replies

@abby-12 

Hello there,

Unfortunately there isn't enough information for us to help you. We would need to know more specifics about how this data is accessed, or more importantly about the data source itself, to give any insight. Odds are yes, it can be done.

The data source is Pitch Book.  I'm specifically downloading company's general and financial information.  I spoke with two of their support associates yesterday, and they both conferred with their team and said that it cannot be done. So I may be abandoning the attempt@Zack Barresse 

In cases like this I would request an API. Even a simple one isn't hard to make.