View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Verity Verity is offline
external usenet poster
 
Posts: 3
Default Importing from CSV over multiple sheets

Hi,

I have a CSV file that has approximately than 520 fields (yes, I know, it's
terrible) that I need to import into Excel. I have found a macro that will
let me import up to 510 fields but it cuts off the last 10. That macro can
be found he http://support.microsoft.com/default...b;en-us;272729

I have only very limited VB skills and I was wondering if one of you kind
people could have a look at the code and tell me where I can change it to let
it import over 3 worksheets instead of 2?

Thanks very much in advance.
Cheers,
Verity