loading a csv file into Excel with Macro to color fields and Bold the first Col

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

Hi,
Is there a way to load a csv file (comma seperated text
file) into Excel with macro attached to color certain
fields and Bold the first column automatically.
 
Try turning on the macro recorder when you do it once by hand. Keep recording
while you're doing your formatting and you'll be pretty darn close when you're
done.
 
JJ,

Yes is the short answer. Without more detail, I can't provide a more helpful
one.

I suggest to you, that you record a macro to import your .csv file, and bold
the first column. If you get stuck, repost to the programming newsgroup.

Colouring fields is a little more difficult, and sounds like conditional
formatting. This would allow you to select colours depending on the values
in the fields. Again, this can be done programmatically, but more detail is
needed to proivde a helpful response.

Sorry

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV loading incorrect 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Macro to open CSV files 6
csv files 1
Keeping lead zeros in excel text format when saving as CSV file 1
.csv Commas ? 2
Creating a Macro to autofill and save 9
Auto format a csv file? 2

Back
Top