Microsoft Excel Questions and Answers
Microsoft Excel Questions and Answers: Submit Your Question
Be the First to add answer.
Post Your Answer Now
|Is This Answer Correct?||91 Yes||19 No|
|Is This Answer Correct?||36 Yes||14 No|
* The general tool in SAP for data upload is the Batch input / call transactions
In the batch input file you specify screen by screen and field by field the input to SAP.
SAP has a recorder to create the sample file. Just run trans SHDB. Within this transaction, you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel. Manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.
|Is This Answer Correct?||18 Yes||5 No|
|Is This Answer Correct?||30 Yes||2 No|
|Is This Answer Correct?||32 Yes||4 No|
|Is This Answer Correct?||12 Yes||3 No|
In olden days we have Lotus 123, it is also having spread sheets for using accounts purpose. Now excel having spread sheets not only accounts purpose but also for various types of formats with calculations.
|Is This Answer Correct?||8 Yes||2 No|
* Select your file through the file open box (CTRL+O)
* Now at the bottom you may notice an ARROW BOX next to the OPEN button (in fact, it is a drop down box)
* Click the arrow and select OPEN AS COPY.
* Now you could be having a copy of the original version of the file.
|Is This Answer Correct?||3 Yes||4 No|
You can access this file through the path D:/Copy(1) of test.xls. You can always rename and copy your file somewhere else but by default Excel saves the copy of the file in the same drive. Also, Excel duplicates the original file and whatever is in the original file, it is copied including formats, formulas and other functionalities.
|Is This Answer Correct?||3 Yes||1 No|