+ Reply to Thread
Results 1 to 2 of 2

Input Filename to copy, rename and save to directory

  1. #1
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Input Filename to copy, rename and save to directory

    I have search and found multiple entries on copying and renaming files but I cannot find one that meets the criteria I am looking for; so any assistance would be greatly appreciated. I need some code to open a user-form to allow me to enter a file name which is always from the same network directory "\\psjj\handling\", check the file exists (provide message if it doesn't), copy this file, rename it as "DSNUPdate.CMC" and put it in another network directory "\\psjl\running\". This directory is constantly monitored where this file is collected and then deleted.

    Many thanks in anticipation

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Input Filename to copy, rename and save to directory

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Copy Single Sheet From Multiple Books And Rename Using Source Filename
    By DeRo22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 12:09 PM
  2. Call in Variable File Directory and Filename from Cell into Save As Prompt
    By cyphus64 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2013, 09:37 PM
  3. VBA Save Filename As Directory Name
    By sanjeevpandey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-19-2013, 10:08 AM
  4. Replies: 2
    Last Post: 01-16-2013, 03:10 PM
  5. Replies: 3
    Last Post: 06-11-2009, 07:08 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