Forum Discussion
abby-12
Jun 24, 2020Copper Contributor
Macro creation involving external data plugin
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 s...
Zack Barresse
Jun 24, 2020Iron Contributor
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.
abby-12
Jun 25, 2020Copper Contributor
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 attemptZack Barresse
- Zack BarresseJun 25, 2020Iron ContributorIn cases like this I would request an API. Even a simple one isn't hard to make.