+ Reply to Thread
Results 1 to 1 of 1

Generate line with Marker graph from multiple csv files, then save to different files

  1. #1
    Registered User
    Join Date
    08-28-2014
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    1

    Generate line with Marker graph from multiple csv files, then save to different files

    HI

    Dynamic graph a chart from multiple files and save them to the new files ?

    I am a newbie to VBA, I hope that someone here can help me with the VBA excel to dynamic generate chart from multiple files

    what my expectation is,
    1. click to open select folder where the files located
    2. automatically open those files and pickup datas from column A,B,C and generate a a line graph(with maker style prefered),
    3. then save the graph with same file name, but to a different folder by clicking selelct a different folder for files to be saved

    Here the data in csv files, every files contain pretty much the same thing, I want the code to automatically pickup the data from column A, B, C and chart it and save it to different or the same file name

    A5(date), B5(time), C5(temperature)
    3/2/2012 9:07:57 0
    3/2/2012 9:15:00 3.78
    3/2/2012 9:30:00 3.84
    3/2/2012 9:45:00 3.78
    3/2/2012 10:00:00 3.72
    3/2/2012 10:15:00 3.81
    3/2/2012 10:30:00 3.78
    3/2/2012 10:45:00 3.69
    3/2/2012 11:00:00 3.72
    3/2/2012 11:15:00 3.75
    3/2/2012 11:30:00 3.69
    3/2/2012 11:45:00 3.78
    3/2/2012 12:00:00 3.72
    3/2/2012 12:15:00 3.69
    3/2/2012 12:30:00 3.75
    3/2/2012 12:45:00 3.75
    3/2/2012 13:00:00 3.63
    3/2/2012 13:15:00 3.69
    3/2/2012 13:30:00 3.75
    3/2/2012 13:45:00 3.66
    3/2/2012 14:00:00 3.81
    3/2/2012 14:15:00 3.88
    3/2/2012 14:30:00 3.75

    Please help me :'(

    thanks, I appreciate it!
    Best
    Kwizard
    Last edited by kwizard; 09-11-2014 at 01:17 PM.

+ 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. Macro to open multiple files, remove header and save multiple files in a new format
    By twocircles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 05:24 PM
  2. IMPORTING TEXT FILES TO EXCELL - Multiple Multi line text files
    By Toxicca in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-12-2014, 09:56 AM
  3. Marker and Line Color Options in Excel Line Graph
    By Slmoore in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-21-2013, 12:55 PM
  4. [SOLVED] Insert Marker in a Line Graph
    By mgs in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-30-2013, 05:25 PM
  5. [SOLVED] Split Large Excel file to multiple excel files and possible save the files
    By EnzioL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-20-2012, 03:28 AM

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