Need some simple code

  • Thread starter Thread starter Dave Neve
  • Start date Start date
D

Dave Neve

Hello

Sorry but I have never mastered VBA

I'd like to have a macro to open a program (see below)

What is the VBA code for this simple operation please?

Thanks

C:\Documents and Settings\Dave Neve\Application
Data\Microsoft\Outlook\Outlook.NK2
 
Sorry but I have never mastered VBA

I'd like to have a macro to open a program (see below)

What is the VBA code for this simple operation please?

Thanks

C:\Documents and Settings\Dave Neve\Application
Data\Microsoft\Outlook\Outlook.NK2
Click to expand...

That is not a program, it's an Outlook data file. Why do you want to
open it?
 
Hi

You're right. I didn't look at what I had pasted.

I should have said code to open

C:\Program Files\nicknameXP.exe

cos I need to get a handle on my nickname cache

Thanks

Dave Neve
 
You're right. I didn't look at what I had pasted.

I should have said code to open

C:\Program Files\nicknameXP.exe

cos I need to get a handle on my nickname cache
Click to expand...

You asked that question in June 2005 already, and Sue Mosher then
recommended the standard method of running any program from VBA:

Set objShell = CreateObject("WScript.Shell")
objShell.Run "C:\Program Files\nicknameXP.exe"

I myself recommended at the time:
Shell("C:\Program Files\nicknameXP.exe")

Did neither one work for you?
 
Back
Top