paths

Hi, I have a rather specific query i need help with. I have a spreadsheet which has a series of cell values that relate to daily files we receive from around the business. As part of a wider process i run a series of macros to copy and move these files from their source folders. I would now...

i have a text file that contains a list of file paths, how possible is it to populate the listbox with the file paths in a reverse range and that the listbox will show only the file name while the path to the file may be hidden in another column, so that i can use workbooks.open listbox1.value...

Hello, I need to open the file via VBA. After clicking on the red label, I want the file to open. I want to enter the file paths directly in the VBA code. Do you have any suggestions?

Hi all, I have several databases that make use of the mkdir function to verify that year and month folders are always created before storing reports. To save room and make my code more efficient, I wrote a function, CheckForPaths, that accepts two string arguments, and uses if functions to...

1. Algebra Practical I A fitness trainer wishes to design a custom field track by setting a number of straight paths and quarter circle turns (in meters). Create an Excel sheet which must contain the following. a) The user can input the value of one straight path length and one quarter circle...

We have a main payroll workbook that pulls data (a mileage total) from a closed workbook in a shared folder. Several of us take turns running payroll, and the reference paths fall apart if the payroll is run from a computer other than the one at which the formula references were entered. I am...

Hello, I don't really know where to start with something like this. I've got a spreadsheet that has a documents going down column C and the paths of these documents listed in column D. (example) What I need VBA to do is go through all of the various paths down column D and save a copy of that...

I have a spreadsheet with a Pivot Table. The Pivot Table is generated via Power Pivot, and the underlying data is from a set of CSV files (one per month) that are linked by way of the Queries and Connections interface. Here is how the directory structure is...

I have this code below... Sub GetFilePath() Set myFile = Application.FileDialog(msoFileDialogOpen) With myFile .Title = "Choose File" .AllowMultiSelect = True If .Show <> -1 Then Exit Sub End If FileSelected = .SelectedItems(1) End With Range("A" & Rows.Count).End(xlUp).Offset(1) =...

Hi All, I am confused on this type of path, The pathway C:\FilesUpload on sharepointtest.amnch.ie/ . the requirement is i need to store a file in this path, I am not sure whether it is shared path or web based path. I have a macro that saves a file to the network path but i am not sure what...

Hello, I have spent some time googling and searching in this forum for this answer, and I am sure it exists somewhere, but I am not clear on it, so I apologize in advance if this is a newbie question. I have a folder in Dropbox (important that it is stored there, it is shared with 15 people...