Excel Import Date Format
Hello everyone,i want to import an Excel-File ( xls ) with the Open() function. Here is my code:dt = Open( "path\file.xls", Worksheets( "worksheet1" ), Use for all sheets( 0 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 5 ), Data Starts ...
