Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem updating via macro
Hi,
I have a macro that functioned fine in Excel 2000 but somehow is different in 2003. Now when trying to open the file to be updated is opened Read-Only and subsequently cannot save automatically. When opening the workbook manually it just opens. Any clues would be greatly appreciated. Thanks, Erik Top part of the vba: Sub Auto_open() ' ' Auto_open Macro ' ' Application.DisplayAlerts = False Workbooks.Open Filename:="\\NLxx\BI Office reports\040\COM\Sales statistics IND.xls" Sheets("Detailed").Select ActiveSheet.PivotTables("PivotTable1").RefreshTabl e ActiveWorkbook.Save ActiveWindow.Close |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem in updating all worksheets of a workbook using a macro that calls another macro | Excel Programming | |||
Problem with formulas updating | Excel Programming | |||
updating one spreadsheet with another problem | Excel Worksheet Functions | |||
Macro Formula Updating Problem | Excel Programming | |||
Updating worksheet problem | Excel Programming |