program links

For users or potential users.
Post Reply
enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

program links

Post by enamelrod » Sun Nov 20, 2016 12:55 pm

I wanted to know if there is a way t?o set up a program link to open 1 particular excel file. not just open excel.

Now if only I could get the word merge feature data to merge into an excel sheet. :?
Last edited by enamelrod on Sun Nov 20, 2016 10:47 pm, edited 1 time in total.

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: program links

Post by wjstarck » Sun Nov 20, 2016 10:19 pm

Sure!

Make a new program link, add Excel as the program to open, then the path to the file you want to open

More info on Excel from the command line here:

https://www.windows-commandline.com/run ... for-excel/

Like so:

Image
Last edited by wjstarck on Sun Nov 20, 2016 10:53 pm, edited 1 time in total.
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: program links

Post by enamelrod » Sun Nov 20, 2016 10:44 pm

I tried that . it took me a moment but it seems all you have to have is the file extension at the end of the file. no need for the excel part. .xslx

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: program links

Post by wjstarck » Sun Nov 20, 2016 10:56 pm

Correct you can also just put the full path to the file as you suggested.
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: program links

Post by jsalmon » Mon Nov 21, 2016 9:18 am

enamelrod wrote:I tried that . it took me a moment but it seems all you have to have is the file extension at the end of the file. no need for the excel part. .xslx
As an FYI for users browsing this forum, doing the above will cause Open Dental to act on your behalf as if you double clicked on the file mentioned. Thus if you have a program (like Excel) set to open .xslx files by default, it will launch the file with said program. If you have multiple softwares that support .xslx then you'll get the "Open With..." dialog or if you have none that are not currently set to open them by default.

Doing things the way wjstarck suggested is the guaranteed way to get Excel to open your file along with other optional commands that they specifically provide.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: program links

Post by enamelrod » Mon Nov 21, 2016 6:37 pm

yes after reading it closer I changed it to meet the syntax standard

Post Reply