Assist with the below requirement...
Coding to run a report from SAP T-CODE with specific criteria and save the file as excel.
Once the excel has been saved formatting to be done as per needs.
- Sindhuja
Assist with the below requirement...
Coding to run a report from SAP T-CODE with specific criteria and save the file as excel.
Once the excel has been saved formatting to be done as per needs.
- Sindhuja
Ah well, that's nice and specific then!
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
The admin staff and members of these forums at vbaepress.com are always willing to have a go at any reasonable request, but this one is well outside the boundaries. Perhaps you need to rethink the request in greater detail before posting again.Originally Posted by sindhuja
Are you seriously asking us to supply the code requirement for a non documented "specific criteria" report? Please supply both the SAP-T CODE data that the report is generated from, and the "specific criteria" you have in mind. We are only human and do not have the powers to second guess your needs accurately enough. Bear also in mind that, in forwarding your request, that the members here operate on the basis of solving single issue requests. Should you have a multi issue request, you would be better off arranging a commercial agreement with a programmer.Coding to run a report from SAP T-CODE with specific criteria and save the file as excel.
And just what are these "as per needs" formatting that you require? Create a sample of both the before and after formatting and attach the workbook. At the moment your request is both obscure and inflammatory.Once the excel has been saved formatting to be done as per needs.
If you have a problem constructing a more polite request, and or supplying a sample workbook relating to this thread, then feel free to PM me and I'll assist you.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Blimey Ted, you took 204 words to say what I said in 7
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Google it...SAP to Excel!
Regards,
--------------------------------------------------------------------------------------------------------
Shrivallabha
--------------------------------------------------------------------------------------------------------
Using Excel 2016 in Home / 2010 in Office
--------------------------------------------------------------------------------------------------------
Let me explain in detail about my requirement.
Am using my SAP login SAP ECC in which i use TCODE Zcustum in which i will give the date range to retrieve the datas. Once the data has been retrieved i will export this data to excel and save in a specific path.
Hope i made my requirement clear.
- Sindhuja
True, but even with 204 words, the OP hasn't really fulfilled what is required to properly ascertain the "request".Originally Posted by xld
Maybe Winshuttle will be what the OP needs?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
I need the coding to link the SAP with the excel. I should have a excel with the coding. When i click on the macro button, the coding should be in such a way that it interacts with SAP with the already using session. New session to be open up to the TCODE Zcustum, then in the fields i should enter the date range. Upon execution i will get the results which needs to be saved in a path with the file name zcus with date i run the report.
on the saved excel file ex zcus 17052011, then i need to go column H and filter the values that has only 300 any where in that column. Then copy all those filtered values to a new sheet with the sheet name "17052011" with the total displayed at the end of row of column H.
Hope i made it clear now.
Sorry for the inconvenience..
-Sindhuja
Please attach a workbook as per my request, in pos #3
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
I have attached the sample sheet. ZCUST sheet was the raw data obtained from the report (from SAP). In column h i used the custom filter "contains /300" as criteria and copied all the rows to the new sheet re-named as Zcust 26.08.2011 with the total in the end of column H.
-Sindhuja