PGS62
commented
2 years ago Hello Lincoln-Hannah
Currently JuliaExeLocation first searches the path for a folder containing julia.exe and then searches in child folders of C:\users\<user_name>\AppData\Local\Programs. I was a bit surprised by the location of julia.exe on your PC, but when I get a chance I will change the code to also search where you suggest.
An immediate fix for you is to make sure that the julia executable is on the path. If you're using the windows installer then there's a checkbox for that. The (soon to be official) Julia installer juliaup certainly arranges for julia.exe to be on the path.
As for your second suggestion, I think it has quite a serious drawback. It would mean that JuliaExcel.xlam would reside on differently-named folders on each PC that it was installed on. That's a recipe for "Excel Change Links" nightmares. i.e. workbooks using JuliaExcel that function correctly on machine A won't work on machine B until after one has grappled with the (quite confusing) Excel change links dialog.
Lincoln-Hannah
Hi Philip. Thanks so much for creating this. Looks like a great tool.
My Julia is located at C:\Users\l123456\AppData\Local\Julia-1.7.2\bin and so I get the error that it cant be found in subfolders of AppData\Local\Programs.
Can it be changed to search subfolders of AppData\Local\ instead of AppData\Local\Programs ?
Also the install script that copies the the ExcelAddins to C:\Users\Public\JuliaExcel is blocked on my work machine. Though I'm able to copy them manually with Admin rights. Would it be easier just to point Excel at the original versions in C:\Users\l139418.julia\packages\JuliaExcel\BZ7cp\