September 5, 2008 08:58pm pdt

1. capricorn1 837,755
2. LSMCons... 448,361
3. boag2000 416,712
4. DatabaseMX 323,032
5. peter57r 295,165
6. harfang 264,026
7. jimhorn 170,911
8. matthews... 135,645
9. TextReport 130,246
10. MikeToole 114,323
11. omgang 97,947
12. frankytee 91,914
13. koutny 90,035
14. angelIII 79,170
15. Rick_Ric... 71,927
16. GRayL 70,880
17. eghtebas 65,987
18. ee_rlee 62,522
19. irudyk 62,160
20. LennyGray 61,992
21. rorya 61,932
22. hnasr 59,055
23. cactus_d... 55,098
24. jefftwilley 54,222
25. wiswalld 53,743

1. capricorn1 1,458,600
2. LSMCons... 680,480
3. DatabaseMX 625,757
4. peter57r 532,674
5. boag2000 456,624
6. harfang 445,574
7. jimhorn 366,901
8. jefftwilley 350,437
9. matthews... 284,909
10. mbizup 241,400
11. frankytee 227,167
12. stevbe 220,614
13. MikeToole 219,373
14. omgang 170,182
15. GRayL 156,686
16. rockiroads 151,183
17. LPurvis 135,020
18. TextReport 130,746
19. angelIII 122,228
20. JDettman 120,940
21. ragoran 112,130
22. koutny 105,060
23. Rick_Ric... 95,527
24. eghtebas 93,562
25. dqmq 89,656

01.27.2008 at 05:34AM PST, ID: 23114529

	[x] Attachment Details

MS Access vba how to select excel sheet following docmd.transferspresdsheet

Asked by downehouse in Access Coding/Macros

Hi, Having just executed a do.cmd transferspreadsheet called say "My_New_Sheet" how can I select the sheet to start formating it. I can open a new workbook and sheet with dim and set obj etc.
the line syntax I need is maybe something like
set objExcelSheet = objExcelWookbook.Worksheet ???? name??
Help!Start Free Trial

Keywords: MS Access vba how to select excel s…

	Title
1	VBA code to join sheets in Excel
2	Can we search a text in multiple sheet…
3	A protected sheet is causing mis-calc…
4	Blocking the "SELECT SHEET" dialog …
5	VBA to copy columns from many sheet…
6	VBA: Open multiple, uniquely-name…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

MS Access vba how to select excel sheet following docmd.transferspresdsheet

Asked by downehouse in Access Coding/Macros

About this solution