access vba - Invalid Qualifier when using System.IO.path in VBA -
i'm extremely new vba , feel have been falling down @ first hurdle morning. i'm trying path of access file doing following
sub getdirectorypath() debug.print (system.io.path.getfullpath()) end sub
however "invalid qualifier" error on system when try run it. i've tried adding 'system' reference says io not found. doing wrong?
vba environment has access com (and com visible) component.
forget importing usual .net namespaces.
but wrappers exists : [https://technet.microsoft.com/en-us/magazine/2007.01.heyscriptingguy.aspx]
instance works :
datalist = createobject("system.collections.arraylist")
btw, in order parse file full name in vba, can use filesystemobject.
Comments
Post a Comment