Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Zip Unzip Files 2 < Zip Unzip Files | Billing Statements >
Back to Zip Unzip Files 2    Comments List
Problem with TXT Only Upload Images   Link   Email  
Sandra Truax         
3 months ago
Last post for a while, I promise.

Hoping someone can tell me what the heck I'm doing wrong. I am trying to extract one file like Richard demostrated in the Extended cut of Zip Unzip Files 2 at 11:56, and I get the status that it's done, but nothing is in the folder.  I have verified the name of the zip file, and the name of the file inside the zip file, but no luck.  

This is what I'm using:
UnzipSpecificFiles "D:\Computer Learning Zone\", "D:\TempFolder", "01.mp4"

To further clarify, when I use Richard's database, and  Zip works, Unzip creates the folder and unzips the file like it is supposed to, BUT when I hit TXT Only, it creates the folder, status shows done, but folder is empty. This is using the original database with NO changes to the code.
Richard Rost             
2 months ago
Hmmm..... what if you try just ".mp4" instead of the whole filename?

Case sensitive? (Shouldn't be, but you never know).

Spaces in the path? (Shouldn't be, but it's worth a try).
Sandra Truax         
2 months ago

I unzipped your download, moved the DB folder to my D:\ (D:\DB), and TXT Only still doesn't work. It makes the folder, but does not extract the file. Both the Zip and Unzip work. I even uninstalled 2019 and got a 365 subscription. Still doesn't work.
Richard Rost             
2 months ago
Well, that's weird. Ok. Add some MsgBox's at each line and check your variable values.
Sandra Truax         
2 months ago
Here is my MsgBox results
ODestFolder = TXTOnly
oSourceZip = MyZip
FileType = .txt
oItem = Null/blank/nothing
Sandra Truax         
2 months ago
I even update PowerShell to the newest version 7.4 and it still won't work.
Richard Rost             
2 months ago
How about oItem.Name
Sandra Truax         
2 months ago
MsgBox oItem.Name gave me Kirk, Picard, Sample
Sandra Truax         
2 months ago
Thank you once again, Richard.  I had my file extensions turned off in Windows File Explore .  It's working now!  Woo hoo!  Time to get back to work now. I 've spent nearly three days of doing nothing else but try to get this to work, first on my own, the because of one silly setting in File Explore.
Richard Rost             
2 months ago
Yeah, I was going to say I can only see the file name in your Source zip file. Got to have those extensions working.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Zip Unzip Files 2.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/15/2024 4:47:08 AM. PLT: 1s