Re: how to create a new folder through a macro ??

On Error Resume Next
Mkdir "C:\downloaded files\file " & Format(date,"dd.mm.yy")
On Error goto 0

--
Regards,
Tom Ogilvy


"furbiuzzu" <furbiuzzu@xxxxxxxxx> wrote in message
news:1136053020.365587.191160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> hi guys..
>
> i've a little problem i can't solve.
>
> i want a macro to download some files from the web (work already done)
> and save them inside a new folder to create at the moment.
>
> the " root folder" is "downloaded files" and inside folders should be
> named as:
>
> "file" & " actual date" >>>>
>
> file 31.12.05
> file 01.01.06
> file 02.01.06
>
> etc etc
>
> inside this folders i want to save my downloaded files day by day...
>
> thanks and sorry for my english !
>


.

Relevant Pages

  • Re: Searching for a root directoty
    ... Tom Ogilvy ... >> Hi, I have a file in wich a Autoopenmacro was writed, the ... >> is always saved in the same folder as the invent file, ... >> that the file registros.xls is in the same folder than invent.xls so ...
    (microsoft.public.excel.programming)
  • Re: Set the path
    ... Tom Ogilvy ... "Grace" wrote in message ... > careful to give those files the right names before starting the macro. ... > folder, ...
    (microsoft.public.excel.programming)
  • Re: Microsoft Common Dialog control, version 6.0
    ... Did you try it with a folder on the C: ... Kevin E. wrote: ... "Tom Ogilvy" wrote: ... Microsoft Excel opens the file dialog allowing the user to ...
    (microsoft.public.excel.programming)
  • Re: How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
    ... from a given folder. ... Here's the entirety of my first macro, ... I was able to install your macro. ... browse capability to navigate to a folder in which I wish to convert Works ...
    (microsoft.public.word.docmanagement)
  • Re: How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
    ... individual folder level, using built-in dialogs to enable the user to select ... It opens each file in the folder that matches the search string ... error trapping in the macro, it is not a good idea to include code to delete ... the dialog's browse capability to navigate to a folder in which I ...
    (microsoft.public.word.docmanagement)