Results 1 to 9 of 9

Thread: Opening Files That Contain Specific Name And Format Certain Columns

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-22-2013, 11:27 AM #1
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    Opening Files That Contain Specific Name And Format Certain Columns

    I have several files which I export as CSV files.

    I would like to have a macro to open all CSV files where the name contains has the word JNL in the file name for eg BR1 JNL june 2013 in folder C:\Journal Templates and to format the values in Col B & C to 2 decimal places (not using thousand seperator)

    Where Col B & C both how zero values, then Row in CSV file to be deleted

    Your assistance in this regard is most appreciated
    Last edited by Howardc; 07-22-2013 at 12:32 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy Row To Another Sheet Depending On Existence Of Specific Value In Specific Column
    By peter renton in forum Excel Help
    Replies: 8
    Last Post: 07-01-2013, 03:52 PM
  2. Macro to copy data in specific Columns
    By Howardc in forum Excel Help
    Replies: 0
    Last Post: 04-19-2013, 10:42 AM
  3. Excel to Excel Data transfer without opening any of the files(source or target)
    By Transformer in forum Excel and VBA Tips and Tricks
    Replies: 14
    Last Post: 08-22-2012, 10:57 AM
  4. Macro for Opening files and copy the contents of the File
    By ravichandavar in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 09:17 PM
  5. Opening a Pdf file using VBA
    By littleiitin in forum Excel Help
    Replies: 2
    Last Post: 11-30-2011, 03:05 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
  •  

Forum Rules