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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem updating via macro
You can try being more explict - although I don't know if that will help:
Workbooks.Open Filename:="\\NLxx\BI Office reports\040\COM\Sales statistics IND.xls", ReadOnly:=False -- Regards, Tom Ogilvy "Erik" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem updating via macro
Thanks Tom but I tried this allready, no change whatsoever. :-(
Tom Ogilvy wrote: You can try being more explict - although I don't know if that will help: Workbooks.Open Filename:="\\NLxx\BI Office reports\040\COM\Sales statistics IND.xls", ReadOnly:=False -- Regards, Tom Ogilvy |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem updating via macro
Got it.. There was a share on top that apparantly in win2003 are
read-only by default. Erik 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 |
Reply |
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 |