Need some advice

[Guest]

I was trying to build a small utility macro using the =cell("filename")
function [I've found I am typing that quite a bit these days], but it keeps
getting hung up, so I'm coming to you good folk with hat in hand for some
much needed advice. Here is the 3 line macro - pretty simple, yet
aggrevating!
Sub FilePathName()
ActiveCell.Value = cell("filename")
End Sub
Ok - so what am I missing here!

Thanks for your help!

 

[Don Guillett]

try
Sub FilePathName()
'ActiveCell.Value = cell("filename")
ActiveCell = ActiveWorkbook.Name
End Sub

 

[Guest]

Cell is a worksheet function that is unavailable in VBS. The same information
can be had using

activeworkbook.path & "\" & activeworkbook.fullname

 

[Frank Kabel]

Hi Don
or maybe
ActiveCell = ActiveWorkbook.FullName

--
Regards
Frank Kabel
Frankfurt, Germany

try
Sub FilePathName()
'ActiveCell.Value = cell("filename")
ActiveCell = ActiveWorkbook.Name
End Sub


--
Don Guillett
SalesAid Software
(e-mail address removed)

I was trying to build a small utility macro using the =cell("filename")
function [I've found I am typing that quite a bit these days], but

it

keeps
getting hung up, so I'm coming to you good folk with hat in hand for some
much needed advice. Here is the 3 line macro - pretty simple, yet
aggrevating!
Sub FilePathName()
ActiveCell.Value = cell("filename")
End Sub
Ok - so what am I missing here!

Thanks for your help!