I am trying to import from xls file using 'Import External Data' in Excel, but some data is missing. No matter what settings I tried, there will be missing data. Thus, I am seeking help for a macro to do the import. I suppose it should be a simple coding. Thanks.