VBA code to search for specified Zip folder to extract.

Hi Everyone,

i hope someone may be able to shed light on my issue.

I am trying to use vba code to look for a Zip folder with specific tiltle and extract this to a specified folder.

i have got it all to work except for get it to register the file.zip name.

the code i am using is:

Please Login or Register  to view this content.

I have put in the title for the "application.getopenfilename" but this still makes me select the folder i am wanting to extract.

any thoughts?

thanks!

yes, GetOpenFilename forces the user to select an item.
don't use it if you already know the file name/path.