vba

81 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.

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 January 17, 2010

with the push to leverage visual studio and dotnet with office based solutions, especially excel, where is the best article or information on how…

thumb_up 18 trending_up 10

Solved December 14, 2009

I'm not talking about calling a VBA COM from C#... the other way around! What I would like to do is call a C#…

thumb_up 6 trending_up 5

Solved December 4, 2009

I have two tables in my access database that I want to be able to export to excel. I can do it by opening…

thumb_up 26 trending_up 10