Re: Automatische Makro-Ausführung
19.11.2002 14:27:57
Nina
Das wäre der Code...Private Sub Workbook_Open()
Dim Datum As String
Datum = Date
Application.DisplayAlerts = False
Application.ScreenUpdating = False
ChDir "u:\Photovoltaik\EAT-DV\Rohdaten"
Workbooks.OpenText Filename:= _
"u:\Photovoltaik\EAT-DV\Rohdaten\" & Datum & ".txt" _
, Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier _
:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:= _
False, Comma:=False, Space:=False, Other:=False, FieldInfo:=Array(Array _
(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8 _
, 1), Array(9, 1), Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1), Array(14, 1), _
Array(15, 1), Array(16, 1), Array(17, 1), Array(18, 1), Array(19, 1), Array(20, 1), Array( _
21, 1), Array(22, 1), Array(23, 1), Array(24, 1), Array(25, 1), Array(26, 1), Array(27, 1), _
Array(28, 1), Array(29, 1), Array(30, 1), Array(31, 1), Array(32, 1), Array(33, 1), Array( _
34, 1), Array(35, 1), Array(36, 1), Array(37, 1), Array(38, 1), Array(39, 1), Array(40, 1), _
Array(41, 1), Array(42, 1), Array(43, 1), Array(44, 1), Array(45, 1), Array(46, 1), Array(47, 1), _
Array(48, 1), Array(49, 1), Array(50, 1), Array(51, 1))
ChDir "u:\Testverzeichnis"
ActiveWorkbook.SaveAs Filename:="u:\Testverzeichnis\Aktuelle Messdaten.xls", _
FileFormat:=xlText, CreateBackup:=False
Charts.Add
ActiveChart.ChartType = xlLine
Und hier tritt der Fehler das erste Mal auf:
ActiveChart.SetSourceData Source:=Sheets("AktuelleMessdaten").Range("B3:B200,I3:N200"), _
PlotBy:=xlColumns
Please help,
Nina