VBA Project Help (Copying Sheet)

Need some help it a VBA project. I'm working on Excel for Mac 2011, although would appreciate any responses in Windows too.

I'm looking to create a VBA program that will:

1. Select a CSV from a pop up window
2. Copy it to be the second worksheet in the current file (the one the program will be in)
3. Make the header row (row 1) of the copied worksheet bold
4. Remove the gridlines
5. Save the file as a new file (to keep the original program file in tact)

If you have any suggestions of how this could be done in a more efficient way, please just go ahead. Thanks

Please Login or Register  to view this content.

will browse for CSV files and then copy the data into Sheet2.

As far as formatting is concerned, your best bet is to record a macro doing exactly what you want and use the code from that.