5/20/2010Microsoft Visual Basic Error - Methord or Data member not found

Microsoft Visual Basic Error - Methord or Data member not found. This error is generated when you call a function that is set a private. To resolve the issue change the function from Private to Public. [More]

Be the first to rate this post

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

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

3/7/2010Working with excel vba check boxes

I have created a check box on a spread sheet and then named it AU from "Check Box 1". If I have selected AU checkbox then I am executing a command If ActiveSheet.Shapes("AU").OLEFormat.Object > 0 Then execute the command End If [More]

Be the first to rate this post

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

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

2/25/2010How to run or execute a dos file or command using excel macro

You will have to create a macro something like this: Sub RunTest () Dim ReturnValue ReturnValue = Shell("""C:\selenium\GoogleTest.bat"" ""G:iDO Messagingttermpromacrosbdf.ttl""", 1) AppActivate ReturnValue End Sub [More]

Be the first to rate this post

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

Posted by: wiki
Posted on: 2/25/2010 at 11:56 AM
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