SAP download using VBA

[learningkid0808]

Hello All,

I am trying to automate report generation from SAP t.code using VBA excel. I am facing some issues below,
1. couldn't select the coloumns one by one.
2. trying to select only 3 coloumns and I am trying to compelete this task using Loop function and download the same in the specified location.

I have attached my coding.... kindly help on this.