+ Reply to Thread
Results 1 to 2 of 2

Can't control directory file is written to.

  1. #1
    Registered User
    Join Date
    03-01-2014
    Location
    New Jersey, United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Can't control directory file is written to.

    The script below writes a ".csv" file to the same directory that contains the workbook the macro, "foo" is run from. I'd like help to change the script to always write the file to a separate directory which is: "c:\etc\upload"
    Please Login or Register  to view this content.
    Last edited by vlady; 03-02-2014 at 08:55 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Can't control directory file is written to.

    Hi,

    It appears to me that the directory that the file is being saved in is determined by the value of the cell F1 on the ActiveSheet. Can you please tell me what the value in F1 is?

    If the value does not include a directory, then change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    If it does, I will need to know what the value is so I can help provide you with a working solution.

    I hope this helps

+ 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. Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  2. Replies: 0
    Last Post: 01-27-2013, 12:13 PM
  3. Need VBA code to search file in directory and sub-directory and show result
    By johnchencanada in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2012, 11:13 PM
  4. Saving file in current directory after accessing file in another directory
    By vuxsa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2011, 11:37 AM
  5. Replies: 3
    Last Post: 06-11-2009, 07:08 PM

Tags for this Thread

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