Solved
November 9, 2011
How to read table pasted in outlook message body using vba?
I need to read table of data as in picure using vba. I used Msg.Body to read the body text but actually i need…
thumb_up 6
trending_up 4
VBA Core
<p>General-purpose VBA techniques spanning the Office suite.</p>
Solved
October 24, 2011
Deleting Empty rows in Excel using VBA
I am trying to delete Empty rows by using below code: worksheet.Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete The code above is working fine, but giving run time…
thumb_up 12
trending_up 7
Solved
October 24, 2011
Run excel VBA function when sheet is clicked
I was wondering if there was a way to run a VBA script when I open a sheet in the workbook. For example, I…
thumb_up 7
trending_up 5
Solved
October 11, 2011
VBA Excel: Compile Error: Object required?
I get a VBA Excel 'Compiler Error: Object required'-Error in the marked line. I do not understand the reason. BTW: Wish Excel would support…
thumb_up 16
trending_up 9
Solved
October 6, 2011
how to split a string with multiple delimeters in vba excel?
I want to split a string with multiple delimeters using Excel VBA. One of the strings is: d1-d2 d3 d4 We have a dash…
thumb_up 20
trending_up 7
Solved
August 31, 2011
Is there a method for getting the Excel VBA IDE working with TFS 2010?
I have team members that need to be able to checkin VBA modules/classes created in Excel 2007/2010. I want to be able to use…
thumb_up 4
trending_up 14
Solved
August 26, 2011
Can I make Excel scroll smoothly without using middle-click?
I must work with nightmare Excel files. (I didn't create them, I just have to work with them). They were so big (more than…
thumb_up 6
trending_up 9
Solved
August 20, 2011
Office add-in ribbons: same tab with 2 addins
I'm trying to make two word add-ins' groups to appear in the same tab (Tools) but they both create unique tabs (there's two 'Tools'…
thumb_up 4
trending_up 7
Solved
August 8, 2011
Subtracting from a date in VBA?
I'm having big problems doing operation with the date in Excel VBA. I have a form that has a textbox where the user will…
thumb_up 18
trending_up 9
Solved
July 22, 2011
Editing MS Office documents from a web application: custom WebDaV implementation or …?
Following is our setup & requirement: There's a public web application accessible via SSL + Basic Authentication. Most of these applications are in ASP.Net;…
thumb_up 5
trending_up 8