how to specify the excel sheet you wanted while using Active X 
Author Message
 how to specify the excel sheet you wanted while using Active X

could anyone tell me how to name or append to specific the excel
sheet? i do not know where and how to set the path for it.


Fri, 20 Aug 2004 17:29:53 GMT  
 how to specify the excel sheet you wanted while using Active X
if you want to name a workbook, you need a reference to it, and then
use saveas method to give it a name and path. If you want a sheet in a
specific point, you can use add method, and set which page you want
after or before you are adding. You can use move to move a sheet from
one position to another.
I recommend you to record a macro and watch the code for help.

Hope this helps



Fri, 20 Aug 2004 17:39:39 GMT  
 how to specify the excel sheet you wanted while using Active X
Hi Gorka, could you describe a bit more, on the setting of page before
or after adding? Do you use a string or numeric to set the parameter,
and if i want the datas to be set to say, workbook (project.xls),
sheet 2, how would you set it? I tried to use index, rather than add
method, and when i set the index to 0, the datas will be at sheet 1,
and for other index numbers, there would be an error of code 1.


Fri, 20 Aug 2004 23:51:31 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. changing active excel sheet

2. How to make a certain work sheet in Excel active with DDE

3. Q: How to fill an excel sheet with data from tcl using DDE

4. Error using active-x with excel in win xp

5. Help wanted using ISE's EiffelCOM with Excel

6. Saving Excel Sheets to CSV etc...

7. Excel Sheets

8. DDE - Create new sheets in Excel

9. Accessing EXCEL sheets via ODBC

10. Put array into Excel-sheet

11. Excel 2000/97 multiple sheets

12. writing data to different sheets within the same Excel file

 

 
Powered by phpBB® Forum Software