Recent content by seta42

Dear Chance12345, it works perfectly on my machine too :-). Thank you very much for your time. Seta42

Hi, Dim vrtSelectedItem must be Variant or Object Thaks Seta42

Hi Roel, It looks much more logical width vrtSelectedItem but, unfortunatelly, I still got the same error message: "ByRef argument type mismatch" Thanks Seta42 PS. runing XP Prof SP2 + Office 2k3

Hi Roel, this try to do something, but stops on inserted line Call Import(str_filename) in Main() macro with: "ByRef argument type mismatch" error message. Could the problem be in different file types? Dim vrtSelectedItem as Variant -in Main() macro Sub Import(str_filename As String) -in...

Dear Chance and Rofeau thanks for your lightning-fast responces, but neither does not work. 1) when I changed Sub import() to Sub Import(str_filename) I lost the import macro from macro list. I also changed Workbooks.OpenText Filename:="D:\import\OFFLINE.DAT", To Workbooks.OpenText...

Hi, as an nonprogrammer I recorded macro to import file from fixed position: Sub import() ChDir "D:\import" Workbooks.OpenText Filename:="D:\import\OFFLINE.DAT", Origin:= _ 852, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _...