Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JohanBS

    Is opening a CSV-file in Excel 2002 different from 2000 or 97

    When I open the .csv-file with VBA in a Excel spreadsheet (excel 2002) the files are not put in the right colums. When i open the file in Excel 97 or Excel 2000 there are no problems. I use the follwing code: Workbooks.Open Filename:= I have modified the code to Workbooks.Open Filename:= ...
  2. JohanBS

    Problems with opening a .csv-file in a excel spreadsheet

    When I open the .csv-file with VBA in a Excel spreadsheet (excel 2002) the files are not put in the right colums. The data in the file are separatet by semicolons, but when I open the file with the following codes: Workbooks.Open Filename:= or Workbooks.Open Filename:= , Format:=xlCSV...
  3. JohanBS

    Opening a CSV-file with VBA in a Excel spreadsheet

    When I open a csv-file with VBA in excel it dosn't comma separate. The are put in the wrong colums I have used the Open.Workbooks method. I think I can solve the problem by using the format and delimiter method parameters. But I havn't been able to specify the parameters correctly and maybe...
  4. JohanBS

    Opening a CSV-file in VBA

    When I open a csv-file in VBA it dosn't comma separate. I have used the Open.Workbooks method. I think I can solve the problem by using the format and delimiter method parameters. But I havn't been able to specify it correctly.

Part and Inventory Search

Back
Top