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

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -