Copy data from SAP CRM Questionnaire to Excel

[Zumba]

Hi all,

I did some searching around here, but I didn't manage to find the issue that I'm having...
I'm trying to record a script that does the following things:

1. Open Tcode: CRMD_ORDER (DONE)
2. Open an id entered in an inputbox (wscript) or certain cell in Excel (DONE)
3. Go to Questionnaire tab (DONE)
4. Copy certain fields data and paste them in Excel (PROBLEM ...)

How do I select and copy the desired data?

The questionnaire is a web page...so..
I can't use the scripting wizzard to identify scripting objects.
I can't use right click -> Export to Microsoft Excel.

What can I do?
5. Attach file in attachment tab (if I manage to overcome step 4)
Any help is appreciated!

Zumba

[Portal]

Hi Zumba,

If you're in a position to look at 3rd party tools, try automation anywhere for this. You can record all of these actions without coding. Can perform the login, the screen scraping from web page, opening excel, pasting to excel, etc.
Let me know if you need more info.

Hope this is helpful.

Regards,
Portal

[Zumba]

Hi Portal,

Thanks for your suggestion, but I want to be able to do this without the use of any of third party apps.
Looking through other forum threads I noticed you recomended this app for similar situations, but installing such an app at work isn't possible. I tried this on my own computer and it really is a great app.

Regards,
Zumba

[Portal]

Hi,

That makes sense. Many situations do not allow third party apps. Glad you like it though--if you have any questions about it, feel free to contact me. Many people are using it to do things they normally struggle with.

Regards,
Portal