Inserting the file name in a cell
Inserting the file name in a cell
(OP)
Hi,
Probably a stupid question but...
Is there a command for inserting the file name into a cell within a workbook, in the same vein as inserting it into the header, &[FILE]?
Thanks,
GRo
Probably a stupid question but...
Is there a command for inserting the file name into a cell within a workbook, in the same vein as inserting it into the header, &[FILE]?
Thanks,
GRo





RE: Inserting the file name in a cell
CODE
Cells(1, 1) = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
End Sub
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376: Eng-Tips.com Forum Policies before posting
Steam Engine enthusiasts
Steam Engine Prints
RE: Inserting the file name in a cell
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Inserting the file name in a cell