need simple import macro for xls file

[alvbnp]

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.

 

[alvbnp]

i could not understand your real problem. this thing can be done in a simple save as copy command. or move or copy to new book...

As I mentioned, I don't want to do the copy and paste, I want to automate everything, automate import, then automate formating and so on. All using macro. I am only missing the part of import it using macro.

Anyone can help? Just a simple macro to import xls file into xls file. Thanks.