getfile

Is there a way to create a list of files in a folder including subfolders and then display the title/description and Author? I have to update the metadata in lots of pdf files and it's taking forever to do this manually. I know there are ways to use VBA to get a list of files from a...

Hi all! I'm new to this forum and I'm not quite an expert in VBA, but I'm trying. I use this function to get the filedate time from a file: Function GetFileDateTime(R As Range) Set R = R.Cells(1, 1) GetFileDateTime = format(filedatetime(R.Value), "dd-mm-yyyy hh:nn") End Function This works...

Hi All, I found some code to select a file to open. This works really well. I'm trying to build a macro that will switch to this file later on. Windows (fNameAndPath).Activate But I keep getting an error, I've tried to add " but no joy. Can someone help please? Original code: Sub GetFile()...

Hi, I need to copy data from one workbook to another workbook. but macro will be run from third workbook. The following code is throwing an error saying subscript out of range. Can somebody help Private Sub CommandButton1_Click() ' macro is run from command button from other workbook Dim...

Hi, I tried my best to run the following code, but could not success. This code will be run from separate workbook. where all the macros are placed. it is throwing an error "Run time error '9', Subscript out of Range". I Guess somebody could help Private Sub CommandButton1_Click() Dim...