halcyoneus
03-25-2003, 01:58 AM
Hello everyone,
I stumbled across this forum while searching for an answer to my saving a macro question. So I figured I would register and ask the experts here. So here is my question......
I currently have a report I use and update weekly at work. I created this report in Excel. I also have a HUGE VB macro I created to simplify many things for me. This macro saves me many hours of work each week. My problem is, the macro I created is way to big. I copied and saved the data into Word in case something happened to the Excel file. The Word document I now have is over 1400 pages long. Last time I checked, there are over 2.4 millions characters of code.
The problem I'm having is every time I go into the report and change something it takes over 10 mins to save the file when I'm done. Is there any way I can get the saving to NOT look at the VB code and only save the Excel sheet?
Thanks
~Hal
I stumbled across this forum while searching for an answer to my saving a macro question. So I figured I would register and ask the experts here. So here is my question......
I currently have a report I use and update weekly at work. I created this report in Excel. I also have a HUGE VB macro I created to simplify many things for me. This macro saves me many hours of work each week. My problem is, the macro I created is way to big. I copied and saved the data into Word in case something happened to the Excel file. The Word document I now have is over 1400 pages long. Last time I checked, there are over 2.4 millions characters of code.
The problem I'm having is every time I go into the report and change something it takes over 10 mins to save the file when I'm done. Is there any way I can get the saving to NOT look at the VB code and only save the Excel sheet?
Thanks
~Hal