Use Parenthesis in Filenames - workaround??
Andi,
This works for me:
Function InterfaceMacro(FileName As String)
MsgBox FileName
End Function
=InterfaceMacro("Process Detail(s).doc")
=InterfaceMacro("Process Detail.doc")
HTH
"Andibevan" wrote:
Hi All,
I have got some code that interfaces between an application and excel.
It processes files for a version managing system - I am encountering a
problem when handling file names with parenthesis.
E.g.
If I put the following in a cell
=InterfaceMacro(Process Detail.doc) works
whereas =InterfaceMacro(Process Detail(s).doc) does not work.
I have spoken to the support team for the version managing system and they
say their software can handly parenthesis (I am almost certain they are
correct). This leads me to believe that this is a possible limitation of
vba? Is there anyway I can get round this as I can't change my file names.
Thanks in advance
Andi
|