Hello,
I have an excel issue for BW. Presently we are extracting data from 8 excel files (for example 24 fields from all 8 files) to BW,
i.e we extract only 3 cells from each file Q62,Q72,Q114.
Instead of using 8 files, we want to put 24 fileds into a single file. So that we can use this single file in business instead of 8 files.
Please advise me step wise for the optimised solution in Excel side ?. ( Any VBA Macros..)
All files are in same format, same filed names.
NOw, we are doing it manually, using a single file .CSV format and using this single file in SAP BW.
But we are looking for a automatic process which brings all 24 fileds and automatically puts into a new CSV file.(I guess By writing VB Macros..etc.).
Please let me know step wise.
Thanks,
Sri
Configuration: Windows XP Internet Explorer 7.0
Cannot insert mp4 files into any video converter Combine 2 partitions into 1 Convertor text jpeg file into word document Excel open file into sheet How do you merge a number of cells vertically into 1 How to create folder and move file into another folder in vb6.0 How to insert gif file into excel How to install flash playerxpt file into firefox How to make a file into a iso If cell is blank then fill colour Inserting pdf file into website Macro to insert cell into 1 sheet excel Merge 3 cells with data into 1 Shell read text file into variable Split files into 2 unix Turn excel file into pdf Unix split file into parts Xls file into pdf file converter free download