Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
renaming folder from db objects
I am trying to zip a folder, but yes the variable 'zipFile' is declared before hand. I have commented out the set statement as per previous instructions: 'Zip the folder Dim FolderToZip 'Set FolderToZip = CreateObject("N:\Alternative_Service_Concepts\Doc_Extractor\Docs\" & "CE_" & Value2 & "_"... -
renaming folder from db objects
Mmmm, neither of those seem to produce a different result. Still getting the object required error. Would there be any other methods I should try? -
renaming folder from db objects
Hi PHV, I'm getting a error from the zip.CopyHere(Fol.Items) line stating: Object required Code 800A01A8 Any ideas? -
renaming folder from db objects
Hi guitarzan, I was hoping you'd be able to help me with one more thing. I am trying to zip the folder, but I'm getting an ActiveX component error with the code: 'Zip the folder Dim FolderToZip Set FolderToZip = CreateObject("N:\Client\Doc_Extractor\Docs\" & "CE_" & Value2 & "_" & Value1 &... -
renaming folder from db objects
Thanks for the help guitarzan. It was throwing some errors while trying to write to a log so I just too that part out. Thanks again! -
renaming folder from db objects
Hi all, Any help would be greatly appreciated, but I am trying to rename a folder using a couple of DB object variables and I'm having a tough go at it. I have tried to convert the objects to strings, but have found out that that doesn't really work. My object variables are: Dim Value1: Set...
