Re: Calling Excel Functions from Access

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: SA (~fake.address_at_nspm.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 07:00:28 -0400

Matt:

Stop by www.mvps.org/access and look in the modules area. I know there's
an example of calling a function in Excel in that section. 

-- 
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
"Matt" <anonymous@discussions.microsoft.com> wrote in message 
news:5f0c01c42dfd$8b9acb90$a401280a@phx.gbl...
>I have a function in VBA in an Excel file.  I want to
> open up Excel programatically from Access and then run
> that function (and provide it parameters).  How do I do
> this?
>
> Thanks!
> -Matt

Relevant Pages

  • Re: Application.Calculation = xlCalculationAutomatic
    ... If you are using the function as a UDF by calling it from an Excel formula ... in a cell the statement will be ignored (because UDFs are not allowed to ...
    (microsoft.public.excel)
  • SQL server 2008 service: access to Excel object model
    ... We have a situation where a service, which is running as a domain user, ... We have already checked to make sure that Excel has been told to allow ... access to the Excel/VBA object model, ... The code that's doing the calling is C#. ...
    (microsoft.public.sqlserver.security)
  • Re: Running Excel in a console app
    ... RCW for the Excel automation class or is doing something else, ... macro and then saves the excel file with applied macro file. ... I added trace before calling the method and in the first line inside the ... void RunMacro() ...
    (microsoft.public.dotnet.framework.performance)
  • Re: Run-time error 5: Invalid Procedure Call or Argument
    ... Check the arguments your using when calling. ... the error started up and your version of Excel that might help. ... to save/exit I get the Run-time error above. ... Our Help Desk here at work ...
    (microsoft.public.excel.misc)
  • Re: i haev not used excel much this weeks, but it has just started to play up.
    ... > out of excel while excel is running. ... > "Frank Kabel" wrote in message ... >> jc calling wrote: ... >>> I am using Windows XP with Windows XP Pro installed on top. ...
    (microsoft.public.excel)