Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why is my variable assignment not working?
Sub ShowFileAccessInfo(filespec) Dim fs, f, fn As String Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.GetFile(filespec) fn = f.Name CheckFileNames fn End Sub f.Name is showing " Summary.xls" but fn is showing "'. I can't figure this out. This same snippet of code works fine in other macro that I used it in. Is there something i am doing wrong but can't see' Help!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Variable assignment | Excel Discussion (Misc queries) | |||
Offset not working with variable | Excel Programming | |||
Variable not working | Excel Discussion (Misc queries) | |||
Variable not working as email address | Excel Programming | |||
range value with variable not working? | Excel Programming |