+ Reply to Thread
Results 1 to 4 of 4

Zipping a folder which is placed on a server

  1. #1
    Forum Contributor
    Join Date
    11-05-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    155

    Zipping a folder which is placed on a server

    Good Morning All,

    I hope everyone is well.

    I'm using Ron De Bruin code (
    PHP Code: 
    https://www.rondebruin.nl/win/s7/win001.htm 
    ) for zipping a folder and it's contents but I cannot seem to get it to work. Any help would be greatly appreciated! The folder is located within a server rather than my own documents - I changed the path to my documents and I cannot get it to work from there either.

    The code creates the zip folder but it doesn't copy the document / documents in (only trying with one document at the minute but will be about 10 Excel files)

    Please Login or Register  to view this content.
    Last edited by Farley945; 09-14-2023 at 05:15 AM. Reason: Add. information

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,026

    Re: Zipping a folder which is placed on a server

    It's because you are using the variables passed to CreateZipFile directly.
    Try something like:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-05-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    155

    Re: Zipping a folder which is placed on a server

    Thank you ByteMarks! Works perfectly now

  4. #4
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,026

    Re: Zipping a folder which is placed on a server

    I found you can actually use your original code if you pass the variables by value. It seems it's the pointer of the default ByRef pass that the shell has problems with.

    Please Login or Register  to view this content.
    Last edited by ByteMarks; 09-14-2023 at 06:57 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Opening a folder created on FTP server
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2016, 04:06 PM
  2. Zipping file from folder containing name
    By mduff3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2014, 04:43 AM
  3. cannot copy folder on remote server
    By elulue in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2013, 09:40 AM
  4. Folder Permission:Access of server by different user
    By sugavanam in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2011, 08:24 AM
  5. Folder lock & unlock in the server
    By sugavanam in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2011, 09:40 AM
  6. need hyperlink to go to individual folder on server
    By phudson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2009, 01:11 PM
  7. How do I copy a folder from a server using a macro
    By macrowriter in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2005, 03:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1