-
mikerickson,
Thanks for the reply.
I'll look into the shellapp right away.
My users all have 2011. No activex.
The reason I mentioned InstrRev (somewhat the REVerse of the string function "Instr", but counts instead from the right), is it was said to be a known problem in Mac 2004.
Was wondering if it still is.
What about the paths on a 2011 Mac machine? Are they separated by colons instead of the backslash?
If so, then my routine to get the program file folder is also a problem.
Take a look:
[VBA]Public Sub GetPaths(Optional LL As Long)
With ThisWorkbook
L = Len(.Name)
LL = Len(.FullName)
Base_Path = Left(.FullName, LL - L - 1) & "\"
ArchiveFiles_Path = Base_Path & "Archive Files" & "\"
End With
End Sub[/VBA]
I know your time is important,
Thanks again.
mauryb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules