path/filename

Hi, A couple of days ago I found a VBA Macro to gather a list of all Folders, Subfolders and Files in a directory, which works just fine (VBA to List all Folders, Subfolders and files in a directory). However, when I try to use it now on a different folder I only receive the main folder name...

Hi all, I have the following code, but this saves my workbook to C:/Documents.. is there a way to make it save to the same folder, my original file is in? I have this Workbook full of macros and code which allows data manipulation efficiently sort of a 'Raw data converter', and this last macro...

Below is an extract of some code that fails because there are spaces in the pathname and the filename (e.g. "AR timesheet.xlsm". I have tried various options such as Chr(34), """"" and %20 but can't seem to get it to work. If I take out the spaces in the path and filename then the code works...

I have code below to save my workbook file as WriteResPassword, but is there any way to get current workbook's path in the interface from Application.GetSaveAsFilename? For now saving as interface displays document folder, so it requires 5-10 more clicks to get where I wanted. Sub...

Hello! I'm pretty new to VBA and was hoping someone could give me good practices for how to reference workbooks. My main concern is that if I write a lot of code that references different workbooks with a full file name path, if I were to have to move these workbooks to another folder, I would...

Hi guys, I am trying to create a macro that change the connection direction after searching for a file that starts with "filename", for example, and the xtension for it is .xlsx and also the path will change because it goes into the C:\Users"username"\SharePoint\ folder and the username is...