topic Re: Create a url from a report program in Application Development and Automation Discussions

Create a url from a report program

Former Member — Tue, 31 Jul 2007 03:46:11 GMT

Hi All,

Could anyone please suggest me how do i generate a url from a report program. I need to use this generated url then, as a link in an excel sheet.

Thanks in advance,

Warm Regards,

Preethi.

Re: Create a url from a report program

Former Member — Tue, 31 Jul 2007 03:54:15 GMT

This thread will answer ur question

Reward if useful.

Re: Create a url from a report program

Former Member — Tue, 31 Jul 2007 04:10:12 GMT

Hi Preethi,

REPORT ZAZUURL .

DATA: BEGIN OF URL_TABLE OCCURS 10,

L(25),

END OF URL_TABLE.

URL_TABLE-L = 'http://www.lycos.com'.APPEND URL_TABLE.

URL_TABLE-L = 'http://www.hotbot.com'.APPEND URL_TABLE.

URL_TABLE-L = 'http://www.sap.com'.APPEND URL_TABLE.

LOOP AT URL_TABLE.

SKIP. FORMAT INTENSIFIED OFF.

WRITE: / 'Single click on '.

FORMAT HOTSPOT ON.FORMAT INTENSIFIED ON.

WRITE: URL_TABLE. HIDE URL_TABLE.

FORMAT HOTSPOT OFF.FORMAT INTENSIFIED OFF.

WRITE: 'to go to', URL_TABLE.

ENDLOOP.

CLEAR URL_TABLE.

AT LINE-SELECTION.

IF NOT URL_TABLE IS INITIAL.

CALL FUNCTION 'WS_EXECUTE'

EXPORTING

program = 'C:\Program Files\Internet Explorer\IEXPLORE.EXE'

commandline = URL_TABLE

INFORM = ''

EXCEPTIONS

PROG_NOT_FOUND = 1.

IF SY-SUBRC <> 0.

WRITE:/ 'Cannot find program to open Internet'.

ENDIF.

<b>Regards,

Azhar</b>

Re: Create a url from a report program

Former Member — Tue, 31 Jul 2007 04:32:29 GMT

hi,

use FM

CALL_BROWSER and pass the url to it

Rgds

Reshma

Re: Create a url from a report program

Former Member — Tue, 31 Jul 2007 04:58:21 GMT

Hi all,

Thanks a lot for your help, but my requirement is not to call a url, but to generate a url and use this url in excel using insert web query. Basically, I have a report that fetches updated data from database and i need to take all this data onto a web query and insert this updated data into excel, so that everytime, i open excel, i must get updated data from database.

Warm Regards,

Preethi.