Excel VBA

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

Solved May 25, 2012

VBA WebBrowser capture full screen

Would like to do this within the confines of VBA (other users have no other development tools to modify). Am aware of 3rd party…

thumb_up 10 trending_up 8

Solved May 25, 2012

I don't think there is something wrong with the codes. Can you help me? I need help. Thank you! from xlrd import open_workbook wb…

thumb_up 7 trending_up 6

Solved May 11, 2012

I have a VBA macro that copies rows from one worksheet into another based upon finding values in cells in 3 columns. The macro…

thumb_up 21 trending_up 12

Solved May 11, 2012

I'm looking for a way to convert xlsx files to csv files in linux, i do not want to use PHP/Perl or anything like…

thumb_up 96 trending_up 108

Solved May 9, 2012

SCENARIO A word document is embedded in Excel 2011 file. I need to save it as a pdf. Had it been Excel 2010 then…

thumb_up 5 trending_up 7

Solved May 2, 2012

Is there a way in C# to switch off macros in excel before loading an excel file. I am loading the excel file using…

thumb_up 8 trending_up 3

Solved May 1, 2012

So I have two columns in excel with column A containing nearly the exact same data as column B. I need a way to…

thumb_up 7 trending_up 7

Solved April 30, 2012

I have an open Excel file and using VB Script, I need to search only column "A" in the Excel sheet until it matches…

thumb_up 15 trending_up 8

Solved April 29, 2012

I currently have 2 worksheets in my excel file. The first sheet is known as the Summary page, which displays an summary result of…

thumb_up 9 trending_up 8

Solved April 27, 2012

I want to create an add-in (a ribbon precisely) for MS Excel by using Visual Studio C# 2010 Express. I have searched and read…

thumb_up 8 trending_up 4