1 Replies - 2222 Views - Last Post: 30 August 2012 - 09:11 PM Rate Topic: -----

#1 achavez  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 8
  • Joined: 16-August 12

Opening CSV file and Placing it into Workbook - create macro

Posted 17 August 2012 - 02:03 PM

hi All!
I would appreciate some help!

My goal is to create a vba to import filtered data into a workbook.

Ex:

Open Workbook TREAS , create macro, open CSV file named "Notes.csv"
Once notes is open, delete row 2.
Select row 1 and filter this.
Select G1 and filter by A to Z
Once done, select all data in Notes.CSV "CTRL+SHIFT+END" which selects all data in this file.
Copy
Paste into Workbook Tab TREAS.xls starting V38
Close Notes.csv - do not save


I would appreciate any help, im new with vba.
Thanks very much in advance!

Is This A Good Question/Topic? 0
  • +

Replies To: Opening CSV file and Placing it into Workbook - create macro

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Opening CSV file and Placing it into Workbook - create macro

Posted 30 August 2012 - 09:11 PM

The only help I can give you is to try to do it yourself, and then post when you run into difficulties. We can't do much until you do something.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1