VBA Core

<p>General-purpose VBA techniques spanning the Office suite.</p>

Solved October 5, 2010

How to add tabs to PowerPoint 2010 that call macros

I have created a pptm file with macros that open certain pptx templates. I then created a new tab with buttons for opening the…

thumb_up 9 trending_up 5

Solved October 1, 2010

I can't find any way to do this. What I have now is that it copy the range as an image: Dim XLApp As…

thumb_up 7 trending_up 4

Solved September 16, 2010

the title exactly -- is there a way to call an r process from an excel macro?

thumb_up 11 trending_up 11

Solved August 5, 2010

Every now and then I come across a problem with an old system one of my colleagues has developed. They tend to have thousands…

thumb_up 9 trending_up 3

Solved July 25, 2010

I have an object and within it I wanna check if some properties is set to false, like: If (not objresult.EOF) Then 'Some code…

thumb_up 44 trending_up 21

Solved July 14, 2010

I'm trying to get a lazy evaluation with 'And' in my Excel macro by doing the following: If Not myObject Is Nothing *And* myObject.test()…

thumb_up 36 trending_up 26

Solved July 7, 2010

I developed a Access application using VBA. Everytime I open Access up, I get the following: I have to click Options -> Enable Content…

thumb_up 10 trending_up 7

Solved May 31, 2010

Is there any way that I can embed a .exe file in a .pdf, .doc, .xls, or .ppt file in such a way that…

thumb_up 10 trending_up 2

Solved April 16, 2010

I have a ASP.NET 2.0 web application that should upload a ppt file and then extract its slides to images. For that I have…

thumb_up 10 trending_up 5

Solved February 4, 2010

Now that Office also comes in a 64bit install, where in the registry do you find out if the version of Office installed is…

thumb_up 45 trending_up 44