Excel - SAP Interface

[anuvnkt]

I want to write a interface program using VB Macro, for updating the Excel Table values into SAP Tables.
Is there any macro that can do this work?

 

[WinteE]

You probably need a macro that writes Excel data into a text file.

Do you have any experience with VBA ?

 

[anuvnkt]

Yes. I am currently working in VBA based application only.

 

[WinteE]

This code will write to a text file

        Open targetFile For Output As #1    'targetFile is a variable that holds a path and filename
            
            Print #1, "19903001;" & varSH & ";" & Abs(Round(varAM, 2)) & ";;" & varPC & ";;;;;;;;;;;;"   'varSH, varAM and varPC are all variables
        
        Close #1

 

[anuvnkt]

Thanks WinteE

Sorry I dont need to update tables. What I need is to update into SAP transaction

Currently my macro will generate a CSV file and stored in SQL Table. ABAPERS trying to map those CSV files into SAP trans. Instead what I am thinking is there by anyway I can directly link my output files into SAP (either from values in sql Table or from excel).