Excel VBA

<p>Data processing, dynamic reporting, and workbook automation.</p>

Solved October 26, 2013

How to Call VBA Function from Excel Cells?

I am a VBA newbie, and I am trying to write a function that I can call from Excel cells, that can open a…

thumb_up 16 trending_up 7

Solved October 24, 2013

EDIT: Instead for my solution, use something like For i = 1 To tmpRngSrcMax If rngSrc(i) <> rngDes(i) Then ... Next i It is…

thumb_up 6 trending_up 8

Solved October 4, 2013

I'm trying to open all appropriate PDFs found in the same directory as my Excel workbook using VBA. I've added the Adobe Acrobat xx.x…

thumb_up 14 trending_up 4

Solved October 3, 2013

I am currently trying to make a macro that will go to a directory, open a workbook (there are 38 currently with an eventual…

thumb_up 9 trending_up 6

Solved September 30, 2013

probably could be a rare petition, but here is the issue. I am adapting an excel of a third-party to my organization. The excel…

thumb_up 11 trending_up 3

Solved September 26, 2013

I've been teaching myself Excel VBA over the last two years, and I have the idea that it is sometimes appropriate to dispose of…

thumb_up 22 trending_up 16

Solved September 26, 2013

I am working with cell values in a format of "XXXX-000-000-000". Everything before the first hyphen needs to be removed, which I can do.…

thumb_up 13 trending_up 4

Solved September 23, 2013

Good evening friends: I have in mind 2 ways for clearing a content in a defined range of cells of a VBA project (in…

thumb_up 8 trending_up 4

Solved September 12, 2013

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following…

thumb_up 44 trending_up 45

Solved August 28, 2013

I have text data in Excel worksheet in the cells B6:H14. Some rows will have 2 cells with contents while others have 4 and…

thumb_up 34 trending_up 2