Re: Enquiry for Ron de Bruin

Tech-Archive recommends: Fix windows errors by optimizing your registry

Working OK in Vista but not in win XP
I am trying to find out why ?

If I know more I post back



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"IanC" <me@xxxxxx> wrote in message news:GuT3k.116954$_c7.72993@xxxxxxxxxxxxxxxx
Hi Ron

I'm using XP (SP2) and Office 2k (SP3).

--
Ian
--
"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:e04zQeJyIHA.3680@xxxxxxxxxxxxxxxxxxxxxxx
Fast test

Working OK here

Vista and O 2007
No WinZip installed (only 7-Zip)

Test it tomorrow on a Win XP sysyem

What do you use (Windows and Office) ?



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:uQnnoQJyIHA.2208@xxxxxxxxxxxxxxxxxxxxxxx
Tomorrow I have time Ian to look good

I will reply tomorrow evening



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"IanC" <me@xxxxxx> wrote in message news:tsu2k.153433$cZ3.69272@xxxxxxxxxxxxxxxx
Hi Ron

MoveHere placed the target file in the destination directory, but did not remove the original from the zip. Could this be because you have WinZip installed and this is being used?

--
Ian
--
"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:eBs3oJ6xIHA.2064@xxxxxxxxxxxxxxxxxxxxxxx
Hi Ian

MoveHere was working in my test yesterday

Will play with it this weekend


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"IanC" <me@xxxxxx> wrote in message news:pZX1k.35866$cL6.10660@xxxxxxxxxxxxxxxx
Hi Ron. MoveHere still leaves the original file in the zip (ie it's no different to Copy Here)

I tried to Kill the file in the zip but it came up with no file found.

Looks like I'm on to a loser here.

Thanks for trying.

--
Ian
--
"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:%23cCBDqzxIHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
Btw: You can move it

oApp.Namespace(FileNameFolder).MoveHere oApp.Namespace(fname).Items.Item("ron.xlsm")

I will try to delete it in a zip file this evening

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:uLCfLkzxIHA.5620@xxxxxxxxxxxxxxxxxxxxxxx
I will play with it this evening and see if I can find a way

If you unzip first then you can do what you want but in the zip it is diffecult I think ?

Unzip
Do what you want in the normal folder
Zip it again


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"IanC" <me@xxxxxx> wrote in message news:qRV1k.70796$SA7.41401@xxxxxxxxxxxxxxxx
Thanks, Ron. I'm afraid I'm using the Windows XP zip facility. I may be able to persuade my employer to buy a copy of WinZip, but that still doesn't really get round the issue of the time involved (which could be considerable) and the dangers that introduces.

I think in this case I'll have to settle for some manual intervention. If only I could delete the extracted file from the zip (this doesn't appear to be possible with Windows zip), then I could probably look to see if the file exists in the zip instead of counting the files.

Thanks for your help.

--
Ian
--
"Ron de Bruin" <rondebruin@xxxxxxxxxxxx> wrote in message news:O5ZeALzxIHA.548@xxxxxxxxxxxxxxxxxxxxxxx
1: The WinZip code on my site can do that (see the parameters link)

But you can Delete the zip first before you create it with the VBA Kill command

2 : If you use WinZip I have code on my site that give you more control

See the note on the page

Warning :
It is not possible to hide the copy dialog when you copy to a zip folder (only working with normal folders).
Also there is no possibility to avoid that someone can cancel the CopyHere operation or that your VBA code will be notified that the operation has been cancelled.



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"IanC" <me@xxxxxx> wrote in message news:lcV1k.133588$UP6.75632@xxxxxxxxxxxxxxxx
Hi Ron

Many thanks for your help with unzipping a file with VBA. I now how 2 problems with zipping. I'm using your "Sub Zip_All_Files_in_Folder()" routine to zip a file to a zip which already contains a copy of the file.

1. I'm prompted that the zip already contains a copy of the file. Can I automatically overwrite the existing file without the prompt appearing?

2. Having asked for the file to be replaced, the code moves on to the Do...Loop and hangs up. I see now that this is because the code is waiting until the number of files in the zip matches the number in the folder. This will never happen as there's only 1 file in the folder and more than that in the zip.
Is there any way to detect that the compression is complete, rather than counting files? The only alternative I can see is to extract all the files, delete the zip, replace the file I need to, then recreate the zip.

As this is to be done over a VPN connection, the time involved and the chances of a problem with the connection increases greatly.

--
Ian
--






.

Relevant Pages

  • Re: Save into different "users" folder
    ... "Ron de Bruin" wrote: ... This folder only exist if you add a signature manual in outlook. ... save into different USER’s Signatures file ...
    (microsoft.public.excel.programming)
  • Re: XLStart in Office 2007
    ... "Ron de Bruin" wrote: ... See this page for a sheet template. ... where can I find the start folder XLStart as in the 2003 version? ...
    (microsoft.public.excel.misc)
  • Re: Delete file within a zip file
    ... Dim FName, vArr, FileNameZip As String ... > Thanks Ron, but a zip file doesn't behave like a normal folder. ... >> Regards Ron de Bruin ...
    (microsoft.public.excel.programming)
  • Re: Enquiry for Ron de Bruin
    ... "Ron de Bruin" wrote in message ... It is not possible to hide the copy dialog when you copy to a zip folder. ... Also there is no possibility to avoid that someone can cancel the CopyHere operation or that your VBA code will be notified that the operation has been cancelled. ...
    (microsoft.public.excel.programming)
  • Re: filename is too long or contains illegal caracters
    ... which version of Vista are you using? ... past told me they don't know anything about Publisher). ... Do you upload to a particular folder on ... Per you suggestion, I tried to Add a Network Location in "Computer", ...
    (microsoft.public.publisher.webdesign)