Re: macro to move from directory to directory

From: Dave Peterson (ec35720_at_netscapeXSPAM.com)
Date: 02/02/05 

Date: Wed, 02 Feb 2005 17:10:42 -0600

The first code looked for the folder names in column A and the workbook names in
column B.

But read my follow up post if the names of the workbooks varied.

davegb wrote:
>
> I've now created this macro and done some test runs. I can't get it to
> find the files in the folders. I'm not even sure it's finding the
> folders. It just places "Missing" in column c. How do I tell it where
> the folders are? I did change the default location to save Excel files
> into the first of the directoriew to see if I could get it to find
> them. But I'd rather do it with a macro command than change the default
> where Excel files are saved.
> When I step through the macro, I get a message that "C:\" cannot be
> found. So I'm guessing that the macro is looking in the root directory
> rather than where the files are stored.
> Any ideas?
> TIA 

-- 
Dave Peterson

Relevant Pages

  • RE: Files and Folders check
    ... Curt ... >>> I have developed a workbook that relies on information from other Files and ... >>> Another macro when it is run will update the current workbook from another ... >>> So I need a code that can check that all the files and folders are in place ...
    (microsoft.public.excel.programming)
  • Re: programatically change source of multiple links for multiple files
    ... You actually have to use the "LinkSources" method on the workbook ... If strOldLink strNewLink Then ... These .xls files link to master.xls and to other .xls files within ...
    (microsoft.public.excel.programming)
  • Re: programatically change source of multiple links for multiple files
    ... You actually have to use the "LinkSources" method on the workbook object ... Dim I as long, aLinks as Variant, strOldLink, strNewLink, strOldPath, ...
    (microsoft.public.excel.programming)
  • RE: getting worksheetnames as links.
    ... you can find my answers below.nearly everyday a workbook is added to the ... folders or a worksheet is added to a workbook in the shared path in the ... can the workbook names and worksheet names be placed in adjacent columns? ... Dim i As Integer ...
    (microsoft.public.excel.programming)
  • Re: programatically change source of multiple links for multiple files
    ... You actually have to use the "LinkSources" method on the workbook object to ... Dim I as long, aLinks as Variant, strOldLink, strNewLink, strOldPath, ... with one or more .xls files within each of those three folders. ...
    (microsoft.public.excel.programming)