You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

How to run query in People soft ps query using Excel Macro

1 reply [Last post]
Guest's picture

I am working on a macro to run query in People soft ps query from excel and save the output at some given location.
Here are steps that I exactly want to do

1. Put all query name (not entire query) under column a in excel Sheet.
2. Run macro to open PS Query.
3. Run query (only private) in PS Query.
4. Output should be saving at given path in given format.

Primarily I am looking for some code that can call ps query from excel macro.

Please suggest me on this.
Thanks in advance


Lepa's picture
User offline. Last seen 2 years 25 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: How to run query in People soft ps query using Excel Macro

Personally, I haven't seen it done anywhere. Lunching PS Query from Excel, I would be very interested to hear back from you if you were able to figure this out.

On the other hand, if you are using online query, all you need is the URL to your query to run it. So if a user enters the query name in excel, you can easily write a macro to generate the URL and lunch the query. The user might need to log in before the query runs, but it ultimately gets you to where you need to be.

Good Luck!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog