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

1/28/2010How to call a procedure or module in another procedure or module VBA Excel

Here is the solution to call a procedure or module in another procedure or module VBA Excel. [More]

Be the first to rate this post

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

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