Got a support call from an associate who is receiving the message "Excel cannot complete this task with available resources. Choose less data or close other applications" when trying to Insert Columns.
I am familiar with this issue from previous versions and have tried the following things to correct it, but to no avail. If you have any other suggestions it would be greatly appreciated:
Here's what we've tried:
1. Closed all other open applications and re-opened the Excel File.
Pressed Ctrl-End to see where the active area ends. It ends in MC (2 rows from the bottom of the worksheet). Tried deleting columns from MC through the end of the worksheet. Got same error message
2. Tried clearing All formats/data for the cells to the right of column MC - same issue
3. Tried re-saving the file under a different name. Reopened the file and tried again with no success.
3. Went to the Visual Basic Editor for the active sheet ant in the Immediate Windows typed ActiveSheet.UsedRange to try to reset the Active area. When we pressed ENTER in the VBE window we got the "Microsoft Excel has Encountered an Error" message and the worksheet closed.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
A query can call a function, and a function can call Excel, even though we are in Access. This is Part 2, and steps you through the VBA that "wraps" Excel functionality so we can use its worksheet functions in Access.
The declaration statement de…