How to read multiple excel sheets from a single excel file
at once????

Answer Posted / rajesh

First you have to split the excel sheets and write the
program in macros and use the dde triplet.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difficulties u faced while doing vital signs table or dataset?

1933


explain the key concept of sas? : Sas-administrator

559


What is the work of tranwrd function?

665


What are the 3 components in sas programming?

725


Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1205






How would you identify a macro variable? : sas-macro

532


What is the function of Stop statement in a SAS Program?

642


How do you connect the desktop application to metadata server? : sas-grid-administration

580


How do you add a number to a macro variable? : sas-macro

545


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1770


explain the difference between proc means and proc summary?

670


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

4912


what is the use of sas management console? : Sas-di

613


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

798


how does sas handle missing values in a merge? : Sas programming

551