excel vba - Trying to access other files in same folder but getting files outside folder -

i'm trying access other files in same folder program wants go files in entire directory. that's i'm telling i'm still new vba , don't know syntax accomplish want. there way can current folder location program , have go through files in folder?

also i'd need solution doesn't use scripting.object stuff since i'm running issues needing downloading stuff , feel uncomfortable requiring people use tool download things since they'll on secure .mil computers (as opposed .com computers)

directory = activeworkbook.path 'also tried curdir() filename = dir(directory & "*.xl??") while filename <> ""    ...    filename = dir() loop 

try

thisworkbook.path  msgbox thisworkbook.path ' make sure right path... 

and

filename = dir(directory & "\" & "*.xl??")