[RESOLVED] VB6, shell, and Windows 7

[Pasvorto]

I have some code

Private Sub Form_Load()

MsgBox "DAD Launcher - 10/19/2011 10:00"

Dim filefrom As String
Dim FileTo As String
Dim Command As String

filefrom = "Z:\DAD\TECHNI.EXE"
FileTo = "C:\PROGRAM FILES\TECHNI\TECHNI.EXE"

'first copy file

FileCopy filefrom, FileTo

'now fire up the program

Command = "C:\PROGRAM FILES\TECHNI\TECHNI.EXE"
Shell Command, vbNormalNoFocus

End

End Sub

Everything seems to be working fine. However, when the users try to log in to the database they get an error "Cannot initialize SSPI package".

I moved everything to a directory under the Program Files directory because W7 seems to get all upset about running programs from the C: root.

If I manually copy the executable to their desktop and run it, they have no problem.

So, what would be the code to copy the program to the desktop and start it?