cancel
Showing results for 
Search instead for 
Did you mean: 

Upload from Excel (again)

Former Member
0 Kudos

Hi all.

I know this topic was discussed many many times before. All solutions are dealing with the gui_upload function module, which is quite good but therefore the user has to login to SAP first and call some transaction or whatever.

I currently search for a VBA based solution to upload an excel worksheet into an itab. So the user can press a button directly in excel.

Any suggestions?

Kind regards,

Thomas

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Jens,

many thanks for your quick reply.

I will have a look at the link and the provided functions.

Regards,

Thomas

Former Member
0 Kudos

Hi Thomas,

you can use the RFC libary to communicate with the system without a visible SAP GUI.

There are some OCX for controling connections and calling function modules. As they are OCX, they can also be used in excel macros.

See docu at: http://help.sap.com/saphelp_46c/helpdata/de/77/39594b622f11d2804b00c04fada2a1/frameset.htm

But you need a remote enabled function module in your sap system, to recievie the data and set them into internal table of a structure you define. So some coding in ABAP is required.

Best regards

Jens