MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need help with macro

  Asked By: Ludwig    Date: Sep 19    Category: MS Office    Views: 1865

I want to write a macro which will create a new .xls file and using
data from original file file some of its cells and put a chart



2 Answers Found

Answer #1    Answered By: Lu Fischer     Answered On: Sep 19

Well, there's not enough info here to give you much guidance, but there seems to be nothing you couldn't get coded automatically by using the Macro Recorder.

Answer #2    Answered By: Alfonso Martin     Answered On: Sep 19

I would start with a workbook.add command to get the new workbook, then just use copy and paste commands to get the cells  you want copied.

As for the chart, I'm with Ray in that we'd need more information to help  you on that one.

Didn't find what you were looking for? Find more on Need help with macro Or get search suggestion and latest updates.