Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
Hi I am trying to write a Macro that opens another workbook (test.csv) and
copies the data from and places into the workbook with the macro (testenabled.xmls) which will run on a scheduled task. I keep running into this error run time error '9' subscript out of range Here is the code - I would really appreciate some help. Sub test() ' ' test Macro ' ' ChDir "C:\Users\j.dibble.CTS\Desktop" Workbooks.Open Filename:="C:\Users\j.dibble.CTS\Desktop\test.csv" Range("A1:B5").Select Selection.Copy Windows("Book1").Activate ActiveSheet.Paste Columns("A:B").Select Range("B1").Activate Application.CutCopyMode = False With Selection .HorizontalAlignment = xlLeft .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With Range("A2").Select Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:= _ "C:\Users\j.dibble.CTS\Desktop\testenabled.xls m", FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False Application.DisplayAlerts = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |