| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Data In a Macro
When I try and save down a sheet the has a pivot table in it using the
following visual basic I get the following error "Excel cannot complete this task with available resources. Choose less data or close other applications". Any suggestions? ChDir Path ActiveWorkbook.SaveAs Filename:= _ Name, FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a spreadsheet without saving the Macro | Excel Programming | |||
| Macro Forces a Check of Data Validation Before Saving or E-mailing | Excel Programming | |||
| Saving worksheet as CSV after pulling data from an external data source | Excel Programming | |||
| Saving data with macro | Excel Programming | |||
| Writing a macro so that when saving a spreadsheet the data cannot be changed | Excel Programming | |||
Threaded Mode
