Hi Exper , I want to use the button to open file excel .

mootoon

I want to open file excel using button.

Marije_Brummel

Have you tried this download?

http://www.mibuso.com/dlinfo.asp?FileID=596

Marije_Brummel

What is it exactly you want to do? Populate an excelsheet with NAV data or open an existing excelfile from NAV?

mootoon

I want to open an exiting excelfile from navision.

Savatage

Is it always the SAME file or do want to choose?

please give as much detail as possible - it really helps when tying to answer a question.

Thanks.

mootoon

I just want to put the code which open an exiting excelfile. I dont know how to do that .

Savatage

One way is
Pop a Command button on your card
view the properties
Push Action would be RunSystem
RunCommand you'll use the shell

see here
remember this one Denster (Jan 2003) http://www.mibuso.com/forum/viewtopic.php?t=1391
or
http://www.mibuso.com/forum/viewtopic.php?t=9284

I would click on these properties too and hit F1 so you can become more familiar with them

While in designer you can goto Help->C/Side Reference Guide and look up SHELL and HYPERLINK

Hyperlink is great - but I don't know if you can get to the code behind the button.

You can also read the Application Designers Guide
If you don't have it (it's on the Nav CD) you can get it here
http://emiel.romein.googlepages.com/w1w1adg.pdf

Alex_Chow

Just call the explorer.exe from the shell and have explorer run any file you want.

Using the windows explorer will automatically choose the program to open the file with.

Savatage

It will also select a drive and path if you want.

runcommand: explorer.exe c:

will open your C drive for example.

Alex_Chow

Right, right.. The HYPERLINK function. #-o

Miklos_Hollender

If you don't use any processing, filtering, data in/out, whatever int the Excel then why not just add it to the Shortcuts menu of the users?

Miklos_Hollender

I thought of a common, shared Excel file - my guess is that it must be case here.