Excel VBA pulling data from Pastel


Does anyone have a sample of VBA code for pulling data from a Pastel database?

Can you use VBA to run specific Pastel reports that open in Excel?

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
I haven't worked with Pastel, but if you have drivers on your machine, you should be able to connect to Pastel and manipulate it like any other database.

Try going to tab Data then select the Get External Data item then the From Other Sources item and follow directions to connect.

With that connection (or even without), you should be able to run Pastel reports as long as they have public APIs to access them. Again, I don't have access to Pastel so at best I could tell you how to find the things you need but they often get challenging when working with APIs, depending on how they're written.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.