+ Reply to Thread
Results 1 to 8 of 8

Excel Names in column to text files names to folder

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010, Excel 2007
    Posts
    57

    Excel Names in column to text files names to folder

    Hello excel gurus,

    I have a spreadsheet with names in column A, I need those names converted to text file names in a folder on the C:\ Annual report.
    My excel VBA is only beginning to intermediate and this is beyond my skill set.
    I would appreciate any help

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,277

    Re: Excel Names in column to text files names to folder

    Are the names in Column A workbook file names and you want these workbooks saved as text files?

  3. #3
    Registered User
    Join Date
    04-07-2013
    Location
    Pati, Jawa Tengah, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel Names in column to text files names to folder

    Assumed :
    this file : XLSForum-SaveFile.xlsm
    on Sheet1 :
    A1 : "Folder :"
    A2 : "Name :"

    B1 : you type complete path ( exp : C:\Annual Report\ )
    B2 : you type name of file you want ( exp. year2013 )

    Please Login or Register  to view this content.
    *I use excel 2007

  4. #4
    Registered User
    Join Date
    06-07-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010, Excel 2007
    Posts
    57

    Re: Excel Names in column to text files names to folder

    I want to just select names in column A and have VBA code use those names saved a text file names with .txt extension. The folder is already created on the c: drive as folder Annual Report. ( save to C:\Annual Report folder)
    Last edited by excelaron; 04-17-2013 at 09:31 AM.

  5. #5
    Registered User
    Join Date
    04-07-2013
    Location
    Pati, Jawa Tengah, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel Names in column to text files names to folder

    Oh, sorry to miss understanding.. I'll try to modify this VBA.. if this is not like your wish.. I'm sorry again..

    First step : just highlights the name file on column A ( put the pointer on the cell contan the name file ) and then run this VBA

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    06-07-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010, Excel 2007
    Posts
    57

    Re: Excel Names in column to text files names to folder

    column A
    1 Name1
    2 Name2
    3 Name3

    In Folder C:\Annual Report\ Name1.txt, Name2.txt, Name3.txt

    I select the names in column A then VBA code uses names in column A then saves names in folder as text files on C: drive

  7. #7
    Registered User
    Join Date
    04-07-2013
    Location
    Pati, Jawa Tengah, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel Names in column to text files names to folder

    what file did you want to save as a text file? file that contain the name file on column A or another workbook?

  8. #8
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,277

    Re: Excel Names in column to text files names to folder

    This will loop through Column A and save the workbook as .txt with the name found in column A.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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