Usually these problems are solved by formating the worksheet before the
importing is donw. For example make format the entire worksheet as textt
before you import. Press the gray button between the Column A and Row 1
(entire worksheet is highlighted). Then go to format menu and try diffferent
format before you import the file. Probably format as text wil solve the
problem (the default is general).

I usually skip the standard importing and write my own filters. I open the
file as text and then write code the reads the textt file and writes to the
spreadsheet. These macro are somtimes very simply and others can be very
complex. A simple one I wrote this week only red lines that had the word
"Active" in the line. I then ran in VBA TextotColumns which put the data in
the correct columns.

"SteveT" wrote:

Hi Wise Ones !,

My customer has very specific viewing requirements of a
report that is provided me in a CSV format.

I have a macro that converts information into required viewing format
1) Open XLS workbook
2) Copy CSV sheet
3) Paste sheet 1 XLS workbook
4) Advance filter into sheet 2 into correct rows specified by customer
5) misc other adjustments made with macro to suite customer

It works fine as long as the source range of advanced filter is fixed.
Unfortunetly this isn't always case. The rows & columns of source data
change regularly

I believe problem could be fixed if I could A) pinpoint the location of the
"Header Words" at the start of the macro,
B) Reference location sheet two ( A1= 'Sheet 1'! + Location found )
C) Then run advance filter

But I don't know how to find the reference row and location of the header
words.

Can someone help?

Thanks for any assistance !

Steven

Thanks Joel for your response .

I won't be doing the coversion and trying to apply macro for user friendlyness

appreciate what said below though. Brgds, Steven

"Joel" wrote:

Usually these problems are solved by formating the worksheet before the
importing is donw. For example make format the entire worksheet as textt
before you import. Press the gray button between the Column A and Row 1
(entire worksheet is highlighted). Then go to format menu and try diffferent
format before you import the file. Probably format as text wil solve the
problem (the default is general).

I usually skip the standard importing and write my own filters. I open the
file as text and then write code the reads the textt file and writes to the
spreadsheet. These macro are somtimes very simply and others can be very
complex. A simple one I wrote this week only red lines that had the word
"Active" in the line. I then ran in VBA TextotColumns which put the data in
the correct columns.

"SteveT" wrote:

Hi Wise Ones !,

My customer has very specific viewing requirements of a
report that is provided me in a CSV format.

I have a macro that converts information into required viewing format
1) Open XLS workbook
2) Copy CSV sheet
3) Paste sheet 1 XLS workbook
4) Advance filter into sheet 2 into correct rows specified by customer
5) misc other adjustments made with macro to suite customer

It works fine as long as the source range of advanced filter is fixed.
Unfortunetly this isn't always case. The rows & columns of source data
change regularly

I believe problem could be fixed if I could A) pinpoint the location of the
"Header Words" at the start of the macro,
B) Reference location sheet two ( A1= 'Sheet 1'! + Location found )
C) Then run advance filter

But I don't know how to find the reference row and location of the header
words.

Can someone help?

Thanks for any assistance !

Steven