DV Addin - Calling Alt-F9/DVUpload from a macro

DV Addin - Calling Alt-F9/DVUpload from a macro

Dear Developer Divas,

I have a macro.  It is a fine and cunning macro.  I want to Alt-F9 my Datavision formulas from my macro.  I want to DVUpload from my macro.  How can I do this?

Signed
Just Jamming with Jamacros

Dear Jamanda,

Excellent question!

In 3.9.x version of the addin, Alt-F9 can be reached from a macro by using:

      Application.Run “DVCalculate”

As of 3.9.30, the DVUpload can be reached form a macro by using:

            Application.Run “DVUpload”

Best of luck with your VBA

Signed
Developers of D'addin.

    • Related Articles

    • DV Addin - Alt-F9 doesn't Calculate on new install

      Dear Delightful Development Divas, Recently I was setting up some initial reports on a brand new server.  The latest version of the Addin was installed, regular F9 is working and individual formulas are working, but Alt F9 just shows the calculate ...

    • DV Addin getting an error for SSPI Context

      Hi all, So, you are getting an error about the SSPI Context in your addin, and you want to know what to do next. First check that users are not in a different domain. Cross domain authentication may cause the SSPI context error. Second, check if the ...

    • DV Training Webinars

        http://www.datavisiontech.com/webinar.htm We find it useful if you open a session of Excel on one screen and the webinar on a secondary screen.  This allows the user to follow along with the exercises on the screen with your data in the Excel ...

    • DV Server - Windows password updates

      Update the password in all Services running under this user Update the stored password in all Windows Scheduled Tasks (running whether logged in or not) For DVmarket Web properties, update the password stored in \programs\DVmarket\web.config If SQL ...

    • Clearing 'stuck' data writes in DVUpload Status

      Get a list of what is currently outstanding:   select * from DVENTERPRISE.dbo.StagingRequests where StatusId < 4   Fail those currently outstanding records   Update DVENTERPRISE.dbo.StagingRequests Set StatusId = 5 where StatusId < 4