Access VBA vs Excel 5.0 
Author Message
 Access VBA vs Excel 5.0

hello !

with Access VBA how to select a sheet other than the first one within an
Excel 5.0 file ???


Thanks



Fri, 14 Jan 2000 03:00:00 GMT  
 Access VBA vs Excel 5.0

Thierry

I'm *very* new to Access, but fairly proficient with XL.  Providing you
have set up your  link to the XL app, then

obXlApp.worksheets(2).select or obXlApp.worksheets("Sheet3").select

should work.  First example uses the sheet index, whereas the second uses
the worksheet name.  (obXlapp should be replaced with your object variable)

FWIW It's seldom necessary to 'select' anything in XL to use it and it
stops any jumping, etc.

HTH and works!!
--
Nick Hodge
Oxford, England




Quote:
> hello !

> with Access VBA how to select a sheet other than the first one within an
> Excel 5.0 file ???


> Thanks



Fri, 14 Jan 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. vba access vs vba excel (alguien sabe?)

2. Excel 97 VBA vs Excel 2000 VBA

3. VBA code in Excel 97 vs Excel 2002

4. Word VBA vs Excel VBA

5. Running excel add-in (added into excel - not access) in Access VBA

6. VB6 vs Excel vs Access...

7. VB6 vs Excel vs Access...

8. Access97 VBA vs. VB 5.0

9. OLE;VB 3.0, Excel 5.0;ICON vs CONTENT

10. Access VBA Calling MSWord/Excel VBA?

11. VBA Analysis Tookpack- Excel In Access VBA

12. Excel 5.0 VBA - DIR command

 

 
Powered by phpBB® Forum Software