#1
|
|||
|
|||
Storing and retreiving text from a separate workbook
Hi All,
First off, thank you in advance for your help. I’m working on a project for work and I’ve been stuck on this “issue” for the past few weeks so your input is much appreciated because at this point I’m stumpedL My workbook: I have a sheet in my workbook that contains 50 graphs with a text box beneath each graph (50 text boxes in total). The graphs show performance metrics for stores, and the text box contains notes. The idea is for a district manager to visit one of his/her stores, sit down with the manager to review the performance metrics (aka graphs), and then enter his or her action plan into the text box. The next time the district manager visits the store, he/she can sit down with the manager, pull up the previously entered action plan, and use it to check progress. My problem: My current set up for this involves a heavy amount of VBA, which is taking up too much space and causing the document to crash frequently. I currently have an edit button, which returns all previously saved notes and allows the user to enter new notes. With the notes pane open, a save button takes all of the notes (previously entered and new) and transfers them to the separate file. I’m using this system for each of the 50 notes panes, and it’s simply taking up too much space. Do you have any recommendations for how I can keep the functionality of my workbook while reducing the file size? Thank you, Benjamin |
#2
|
|||
|
|||
Hi,
Perhaps a redacted copy of your file would help. |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
Hi,
Thanks for the screen shots. But, if your problem is the file crashing because of the file size it could be a memory issue. If you can let us see the code so that we can see how to reduce it in size or revamp it. |
#5
|
|||
|
|||
Hi,
If you requested help on other sites it would be nice if you let us know. http://www.excelforum.com/excel-prog...-workbook.html http://www.mrexcel.com/forum/excel-q...ate-graph.html It will save our time as too whether we need to help you. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Code for storing new word | fahmiakbar | Word VBA | 2 | 02-13-2015 11:26 AM |
Convert Text To Table: Separate text at (Other)? | tinfanide | Word VBA | 2 | 01-12-2015 05:26 AM |
retreiving info from a meeting request | plhaws | Outlook | 0 | 07-09-2014 12:33 PM |
Retreiving a reoly from the Send Folder | Emerogork | Outlook | 2 | 06-16-2011 05:58 PM |
Separate body text from TOC heading text | Gordc | Word | 5 | 06-15-2011 04:17 PM |