absolute path

Hi all, I am trying to create a macro in excel for extract file names (with extension) and their absolute path, from one main path (always a local path), but I am afraid I am not able to. My idea is to insert in cell C2 the main path, where there are files, folders and subfolders (with files...

Hi all, I am trying to set up a financial accounting system that involves linking a central spreadsheet to various source spreadsheets (salaries, receipts) in different Dropbox folders. This is simple enough when working from my own computer, but the system needs to be accessible and editable...

Hi, I have a spreadsheet that has some values in cells A1:E1 (let's call these base values 1) The values in cells A2:A10 are calculated using the base values in A1:E1 So, the formulas is A2:A10 might look something like this... A2 = ($A$1 + $B$1 + $C$1 + $D$1 + $E$1) * 1 A3 = ($A$1 + $B$1 +...

This is a frequent problem for me. When I save a macro-enabled workbook that contains function procedures into a new file name, when the workbook attempts to use the function procedures, it is looking for the function procedures in the old workbook name, not the new one. Borrowing some...

Hi everyone, in Excel 2003 absolute paths were not case sensitive, in Excel 2007 they are. Hope this can save you time troubleshooting recently converted spreadsheets (from 2003 to 2007). Specifically, for VLookup to network files you get a '#N/A' error