Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ina ina is offline
external usenet poster
 
Posts: 120
Default Problem on openning a program via Excel

Hello guys I would like to open this program throught Excel and I have
this code

Option Explicit

'This code allows me to open PLaunch
Public Sub OpenPLaunchShell()

Dim appPack As String
Dim BoPack As Boolean


On Error Resume Next


If Err < 0 Then


BoPack = True ' if no error PLaunch is open
Err.Clear
'If the program open already MsgBox "Packhedge is not open"
appPack = "C:\Program Files\Packhedge\Packhedge.exe"
Shell appPack

Exit Sub


Else

'If the program is already open I do not open it.
MsgBox "found PLaunch open already"
Exit Sub


End If


End Sub

but the program is launching twice everytime and I do not know why?

Ina

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Openning spesific file in Excel Farhad Excel Discussion (Misc queries) 1 November 29th 07 02:11 PM
Problem to launch a program from Excel ina Excel Programming 2 May 9th 06 04:31 PM
openning Access via Excel Huaqin Excel Programming 3 September 14th 05 04:00 AM
How to start a macro when openning Excel pinguino2005 Excel Programming 4 May 30th 05 01:28 AM
Having a problem getting Excel to work from my .Net VB Program AustinTXMike Excel Programming 0 October 14th 04 05:33 PM


All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"