AppActivate in a VB macro

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
AppActivate in a VB macro - Excel 2002

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

April 7th, 2004, 10:34 AM

andycub

Registered User

Join Date: Apr 2004

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

AppActivate in a VB macro - Excel 2002

Hi,

I've created a Macro in Excel 2000 to export information to Microsoft Paint, but after updating to Excel2002 the macro throws the error 'Invalid procedure call or argument' in the instruction AppActivate. This is the portion of the code with problems:

    MyAppID = Shell("mspaint.exe", vbNormalFocus)
    AppActivate MyAppID
    SendKeys "^n"

Anyone know what is the problem?

Thanks

Andres C

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Web access from VB Macro in Excel	beta_leonis	VB How-To	0	August 3rd, 2007 11:30 AM
control Excel VBA macro with a VB 05-designed UI	dgr7	VB How-To	0	December 29th, 2006 05:59 PM
VB Macro Excel	mateenmohd	Excel VBA	6	January 4th, 2006 05:27 AM
Excel 2000 vs Excel 2002 Macro Issue	williadn	Excel VBA	1	July 14th, 2005 09:09 AM
vb macro output file to excel	mateenmohd	VBScript	0	March 21st, 2005 12:34 AM