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

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