get filename

Dear All I have and excel file includes records which in column H as range H1 = 360001 H2 = 360002 H3 = 360003 ETC I asked my clients to save a document in shared folder names with what mentioned above, as a copy of invoice for 360001 named 360001 and the same with the rest all what i need to...

The macro currently has the following ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "V:\ingrid\Book9.pdf", Quality:=xlQualityStandard, IncludeDocProperties:= _ True, IgnorePrintAreas:=False, OpenAfterPublish:=False I want this to be changed as such that it...

Hi, I am trying to import data from multiple workbooks onto this master workbook and then have the imported document name entered onto a list starting vertically from C9. I have the code to import the files but have not figured out how to get the name of the doc onto the list from C9. This is...

Hi.. I needed some help..i just wanna copied just filenames (one or more) that i've selected to the cell that i wanted as a list..then adding a hyperlink to that filename so i can get to just open the folder of that file (not opening the file itself just the folder place of that file) while i...

Hi I have code that will open a text file (don't know the name it will be but will be the only one), but I need to figure out how to get that file name so that I can use it to close the file later on. Workbooks.opentext Filename:="*.txt", Origin:= _ xlMSDOS, StartRow:=1...

Hi all. I have a macro (see code below) that copies a worksheet (Sheet1) from a closed workbook into Sheet1 of the active workbook. So far, so good but I need the path to the closed workbook to be taken from a cell in the active workbook which is populated by a drop-down combo box. I have named...

Hi All, I have a service report form which pre-populates certain fields depending on which task is to be done. The task is selected by a drop down box in one of the worksheets. I realized a risk is that if a person selects a task which will pre-populate the fields, completes the form and then...