VBA Analysis Tookpack- Excel In Access VBA 
Author Message
 VBA Analysis Tookpack- Excel In Access VBA

Could someone suggest how I might use Excel VBA Analysis
Toolpack functions in a Microsoft Access Database VBA
subroutine? Is there a reference to a Library that I must
Check?
Thanks, Alex


Mon, 18 Apr 2005 07:28:32 GMT  
 VBA Analysis Tookpack- Excel In Access VBA
You need a reference to Microsoft Excel.


Quote:
> Could someone suggest how I might use Excel VBA Analysis
> Toolpack functions in a Microsoft Access Database VBA
> subroutine? Is there a reference to a Library that I must
> Check?
> Thanks, Alex



Mon, 18 Apr 2005 07:36:57 GMT  
 VBA Analysis Tookpack- Excel In Access VBA
Adding to what Paul said, you do need to jump through a couple of hoops. Code at
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q198571.

--

Sco

M.L. "Sco" Scofield, MCSD, MCT, MCP, MSS, Access MVP, A+
Useful Metric Conversion #13 of 19: 3 1/3 tridents = 1 decadent
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Quote:

> Could someone suggest how I might use Excel VBA Analysis
> Toolpack functions in a Microsoft Access Database VBA
> subroutine? Is there a reference to a Library that I must
> Check?
> Thanks, Alex



Mon, 18 Apr 2005 14:21:10 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Loading Data Analysis Pack from Excel VBA

2. Access VBA Calling MSWord/Excel VBA?

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

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

5. Windows EXCEL VBA / MAC EXCEL VBA compatibility issues

6. Excel 97 VBA vs Excel 2000 VBA

7. Access 97 VBA v Access 2K VBA - different ?

8. Access 2000 VBA Handbook vis a vis Access 97 VBA Handbook

9. Edit Access Record in Excel, then send back to Access using VBA

10. VBA coding to call an Excel VBA macro from Outlook

11. Word VBA vs Excel VBA

12. NEW VBA'er(Excel) looking for other VBA'ers

 

 
Powered by phpBB® Forum Software