$$Excel-Macros$$ Re: Import CSV - Prompt for File - Adjust for Formulas and Totals Row?

2009-01-21 Thread macrojunkie
.LineStyle = xlNone ActiveWindow.SmallScroll Down:=-78 Range("A1:H1").Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyl

$$Excel-Macros$$ Import CSV - Prompt for File - Adjust for Formulas and Totals Row?

2009-01-21 Thread macrojunkie
I have a workbook with 3 tabs. Right now, I am working to make this a template that I can import 3 csv files into for a given report. What I lack is a way to make this automated. I set this up with a small set of data. Each tab has the follow standard format: + First row has headers + A total