Previous Topic Next Topic

Updating Excel that has Macros

Closed
VLS Posts 2 Registration date Wednesday December 19, 2012 Status Member Last seen December 19, 2012 - Dec 19, 2012 at 09:00 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 20, 2012 at 09:30 AM
Hello,

How can you easily update an Excel workbook that already is using Macros? I need to insert two columns but once I do, I receive errors. There is about 90 pages of 'behind the scenes' programming for the Macros. The author of the file is no longer available.

Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 19, 2012 at 12:18 PM
Hard to answer without knowing how macro is written and are being used.
Perhaps most easy approach that might work would be add the new columns at the end of the existing columns.
0
Answer 2 / 2
VLS Posts 2 Registration date Wednesday December 19, 2012 Status Member Last seen December 19, 2012
Dec 19, 2012 at 01:00 PM
Unfortunately, a macro establishes an area and adding a column is contained inside this area and returns an error. This worksheet is to match column headers in another worksheet. I added same column headers in all worksheets to be consistent, yet it still returns an error. Thanks for the reply and idea!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 19, 2012 at 09:58 PM
if you can upload a sample file at some public file share site like speedyshare and post back link to file back here, one can see what can be done
0
VLS
Dec 20, 2012 at 07:39 AM
I won't be able to sanitize this file to save on a public site. Thanks for your help! I may just go ahead and recreate another workbook to do the same this one does. Happy Holidays.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 20, 2012 at 09:30 AM
Well see if posting a book with headers/ sheets names and macro is possible without the data itself. If not, well then good luck with your issue and Happy Holidays to you too
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses