Zipping file from folder containing name
I have a code that zips files from a folder that have a certain word in the filename. When I run the macro it seems to find the file okay but then it comes up with an error like "The file name you specified is not valid or too long. Specify a different file name" and I don't know why. Here's a snippet of my code:
The line that is problematic is coloured in red.
Please Login or Register to view this content.
Can you pls explain what this thread is different from this one?
http://www.excelforum.com/excel-prog...tton-name.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I've updated the code and the question that I have is completely different.
Why do you use array for FName if it is only one string?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks