var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Function to get the current path/directory
What is the function to get the durrent path/directory of where my file is?
I have an excel file in which cell (A1) should contain/display the current path or directory where this said file is saved? What is that function pls.?
Thanks a lot.
You can set it through VBA, use Application.Path
I think to get the directory of the Excel file running the code you need this
Application.Path returns the diectory of Excel.exe !!?
Yeah, you're right, you'll want to use ActiveWorkbook.Path. My bad.
You could also use the CELL function in Excel:
If you want the name and path of the active spreadsheet to be entered automatically in a cell, use the formula: =CELL("filename" )
if you want only the filename use :
=MID(CELL("filename" ,A1),FIND("[" ,CELL("filename" ,A1))+1,FIND("]" ,CELL("filename" ,A1))-FIND("[" ,CELL("filename",A1))-1)