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

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -