Macro to upload note pad (.txt) file in SAP (RR1)

[Ruma]

Hello,

Am using a macro to copy paste data from excel to note pad. This note pad is either saved on desktop or any share drive where the working file containing the macro is saved.

This note pad is manually uploaded in SAP currently, however now want to upload this directly y in SAP (RR1).

Could you please help me with the coding.

Current Code:

Public Sub CopyToNotepad()

Dim strPath As String: strPath = ThisWorkbook.Path & "\" & Range("E1").Value & ".txt"

Dim intFF As Integer: intFF = FreeFile()

Open strPath For Output As #intFF

Print #intFF, Join(Application.Transpose(Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row).Value), vbCrLf)

Close #intFF

End Sub

Regards,

Ruma

 

[Marc L]

Hi !

Your code just create a text file …

As SAP has an import function …
So better is to ask on a specific SAP forum
how to « directly import a text file » …

Do also an easy web search on this subject, some links !
​

 

[Chihiro]

Here

http://lmgtfy.com/?q=automate text file import to SAP

Ok, jokes aside, you need set up on SAP side and not on Macro side.

Typically, for flat files (text), you either need to manually add the file if file name varies.

Or create static named text file and add that to SAP then update the text file data (keeping file name same) to reflect it on SAP side.

 

[Ruma]

Thank you for the advise will do that

 

[Ruma]

yes the file name varies ..