User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
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
Thu, 12/18/2008 - 7:02am
Hi,
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
Regards
Shailendra
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| how to create application status in peoplesoft campus solutions 8.9 version | PeopleSoft Functional | 05/17/2012 - 4:09am |
| horizantal text in charts | PeopleSoft Technical | 05/10/2012 - 4:57am |
| no current buffer context error | PeopleSoft Technical | 05/10/2012 - 1:19am |
| Integration Broker : Operating Instance/Pub Contracts/Sub Contracts | PeopleSoft Technical | 04/24/2012 - 11:05am |
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
Post new comment