excel-vba

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

Solved May 18, 2013

How to break long string to multiple lines

I'm using this insert statement in my code in vba excel but i'm not able to break it into more than one line SqlQueryString…

thumb_up 17 trending_up 13

Solved April 30, 2013

I am opening spreadsheets using VBA and a couple of the workbooks contain code which starts executing when Workbook_Open() is called. How can I…

thumb_up 5 trending_up 5

Solved April 13, 2013

So in excel I'm trying to get rid of the blank cells between my cells which have info in them by using F5 to…

thumb_up 13 trending_up 8

Solved April 12, 2013

I need to issue an HTTP Get with a query string to a web service from Excel for Mac 2011. I've seen the answers…

thumb_up 16 trending_up 9

Solved April 10, 2013

I am trying to automate data population on some excel sheets that have some macros. Now the excel is protected and I cannot get…

thumb_up 12 trending_up 11

Solved April 9, 2013

Is there a way we can trigger a macro function on column filter in excel?? Please help Thanks.

thumb_up 9 trending_up 2

Solved April 3, 2013

I was hoping to write a Macro that does a very repetitive task for me but entering VBA is harder than expected. I will…

thumb_up 13 trending_up 6

Solved April 2, 2013

I am fixing a spreadsheet. The programmer made a macro for each sheet to fire when the sheet is changed. This is good because…

thumb_up 9 trending_up 4

Solved March 20, 2013

I have a thousands of cells in an Excel worksheet which are ComboBoxes. The user will select one at random and populate it. How…

thumb_up 4 trending_up 6

Solved February 19, 2013

I have seen a few posts on this, but I haven't seen any solutions so far. I have a .jar file that I'm converting…

thumb_up 10 trending_up 6