Recorded Macro "Invalid procedure or call argument" Error

Hi,

I have recorded macro to automate some of the import wizard functions. So, Basically I imported text file (fixed with), then performed some editing (deleting rows columns and etc.). Then I stopped recording.

However when I try to run macro, it gives "Invalid procedure or call argument". The error is given on the 4th line i.e. .CommandType=0

Can someone help me, please?

Please Login or Register  to view this content.

Hi lilit2222,

Can you post a sample of your text file & the expected results in excel sheet after the changes you want to make so members could suggest some code for you