7/1/2010How to use Proper Case Function in Excel Macro VBA

In this example I will tell you how you can use Proper Case Function in Excel Macro VBA. Application.Proper(Cells(r, 1)). [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 7/1/2010 at 11:32 AM
Tags: , , ,
Categories: VBA Macros
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed

5/25/2010How to extract the first 100 characters from a excel cell using vba

Say Call A1 has the value In this example I will tell you how you can extract the first 100 characters from a excel cell using vba In Cell B1 write the function =MID(A1,1,100). [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 5/25/2010 at 5:38 PM
Tags: , , ,
Categories: Software Testing | VBA Macros
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed

5/25/2010Using Excel VBA Trim function with xpath in selenium

The text in the excel cell had a space at the end of the string and this was causing the scripts to fail as the string did not match with the text on the webpage. I then used the trim function to remove the space at the begining and end of the string. [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 5/25/2010 at 2:05 PM
Tags: , , , , ,
Categories: Software Testing
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed