Hi
How can i with a command buttom stating
another program not excel.

Hope someone can help

alvin

Alvin

Use Shell. Help should be available in vba help.

Cheers, Jari


"Alvin Hansen" kirjoitti
...
Hi
How can i with a command buttom stating
another program not excel.

Hope someone can help

alvin

If someone knows how to open a file in another program, I would be grateful.
For example open a certain xxxx.txt file in the Notepad.
Regards, Jari


"Alvin Hansen" kirjoitti
...
Hi
How can i with a command buttom stating
another program not excel.

Hope someone can help

alvin

Hi jari
its the same i want to
I have try call shell but that only working with a exe fil
if i have maby a mdb(access) file
name c:\grub.mdb i want to open this file with access

if i try that with call shell i get a error

alvin


"Jari Toukkari" wrote:

If someone knows how to open a file in another program, I would be grateful.
For example open a certain xxxx.txt file in the Notepad.
Regards, Jari


"Alvin Hansen" kirjoitti
...
Hi
How can i with a command buttom stating
another program not excel.

Hope someone can help

alvin

Sub ABC()
Shell "C:\Windows\Notepad.exe 'C:\Myfolder\Myfile.txt"
End Sub

worked for me.

--
Regards,
Tom Ogilvy



"Alvin Hansen" wrote in message
...
Hi jari
its the same i want to
I have try call shell but that only working with a exe fil
if i have maby a mdb(access) file
name c:\grub.mdb i want to open this file with access

if i try that with call shell i get a error

alvin


"Jari Toukkari" wrote:

If someone knows how to open a file in another program, I would be
grateful.
For example open a certain xxxx.txt file in the Notepad.
Regards, Jari


"Alvin Hansen" kirjoitti
...
Hi
How can i with a command buttom stating
another program not excel.

Hope someone can help

alvin

Thanks
its working
Maybe you can help more?
If the file name is in a txt file
how can i get this filename?

Best ragards
Alvin


"Tom Ogilvy" wrote:

Sub ABC()
Shell "C:\Windows\Notepad.exe 'C:\Myfolder\Myfile.txt"
End Sub

worked for me.

--
Regards,
Tom Ogilvy



"Alvin Hansen" wrote in message
...
Hi jari
its the same i want to
I have try call shell but that only working with a exe fil
if i have maby a mdb(access) file
name c:\grub.mdb i want to open this file with access

if i try that with call shell i get a error

alvin


"Jari Toukkari" wrote:

If someone knows how to open a file in another program, I would be
grateful.
For example open a certain xxxx.txt file in the Notepad.
Regards, Jari


"Alvin Hansen" kirjoitti
...
Hi
How can i with a command buttom stating
another program not excel.

Hope someone can help

alvin

You can open a text file with low level io and extract the file name:

http://www.applecore99.com/gen/gen029.asp
File I/O Using VBA
Applecore pages on Microsoft Access

http://support.microsoft.com/default...62&Product=xlw
Working with Sequential Access Files


then construct a string which forms a proper argument to the shell command.

You can also manipulate Access using OLE Automation. You might look at the
Automation help file:
http://support.microsoft.com/?kbid=167223
OFF97: Microsoft Office 97 Automation Help File Available



--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Thanks
its working
Maybe you can help more?
If the file name is in a txt file
how can i get this filename?

Best ragards
Alvin


"Tom Ogilvy" wrote:

Sub ABC()
Shell "C:\Windows\Notepad.exe 'C:\Myfolder\Myfile.txt"
End Sub

worked for me.

--
Regards,
Tom Ogilvy



"Alvin Hansen" wrote in message
...
Hi jari
its the same i want to
I have try call shell but that only working with a exe fil
if i have maby a mdb(access) file
name c:\grub.mdb i want to open this file with access

if i try that with call shell i get a error

alvin


"Jari Toukkari" wrote:

If someone knows how to open a file in another program, I would be
grateful.
For example open a certain xxxx.txt file in the Notepad.
Regards, Jari


"Alvin Hansen" kirjoitti
...
Hi
How can i with a command buttom stating
another program not excel.

Hope someone can help

alvin