Using Excel workbooks and sheet from Access 
Author Message
 Using Excel workbooks and sheet from Access

I am using Access from Office XP Professional to develop
an application for distribution in run time. I have been
able to open the Excel application using a
Quote:
> command button, however, I want to open an Excel workbook
> and run Excel macros through automation. When finished I
> want to return to my Access application. Can this be

done?


Sun, 30 Jan 2005 20:25:45 GMT  
 Using Excel workbooks and sheet from Access
Check out MSKB article:

http://support.microsoft,co/support/kb/articles/Q198/5/71.ASP

The article is for A2K.  There may be an update for AXP.  Search the above
site to see if there is an update for AXP.

--
HTH
Van T. Dinh
MVP (Access)


Quote:
> I am using Access from Office XP Professional to develop
> an application for distribution in run time. I have been
> able to open the Excel application using a
> > command button, however, I want to open an Excel workbook
> > and run Excel macros through automation. When finished I
> > want to return to my Access application. Can this be
> done?



Sun, 30 Jan 2005 21:15:08 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VB or Excel VBA, accessing list of all the sheets in a workbook

2. Excel HRESULT: 0x800A03EC when using Workbooks.open or Workbooks._opentext in C#

3. I want to email excel sheets in a workbook

4. Word2000 Mail merge from selected sheet in Excel workbook

5. Selecting multiple sheets in an Excel workbook

6. Err 1004: Excel Workbook/Sheet Activate

7. Copy an Excel sheet without opening the workbook.

8. Somebody please help me to create an Excel Workbook w/sheets from VB4.0

9. Excel VBA: search multiple-sheets in a workbook

10. Write to, calculate, read from Excel workbook-sheet

11. ADO Connection to Excel - Finding the sheets in a workbook

12. OLE, VB3, access cells from many sheets in a single .XLW workbook

 

 
Powered by phpBB® Forum Software