VBA code to open and run SAP query

[Rowanhf12]

Is it possible to run macro code to do the following:

• Open up SAP
• Go to connections PR1
• Go to SAP query vf03
• (enter details in certain criteria fields)
• run the query
• export data to csv file

I've looked online and can't find anything, but would be great help if running SAP through excel macro was possible

Thank you for any help

 

[Rowanhf12]

I can open up Saplogon using a hyperlink, but can't figure out the script to 'logon' and then access a certain sap query (vf03 for example)

At the moment all I have is:

Written in cell A3: C:\Program Files (x86)\SAP\FrontEnd\SAPgui\saplogon

VBA code: Range("A3").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

So, as I say. All this does so far is open up the home logon page for SAP.

Please help