Solved

Macro to replace old codes with new codes II

Posted on 2015-02-12
10
43 Views
Last Modified: 2015-02-14
0
Comment
Question by:ceneiqe
  • 5
  • 2
10 Comments
 
LVL 11

Expert Comment

by:jkpieterse
ID: 40607561
I would move your code into a separate workbook and save-as this workbook to an add-in. See:
www.jkp-ads.com/articles/distributemacro00.asp
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 40607780
Here it is
Put this file in you XLSTART folder
open any Excel file that you need to process macro MapData.

Activate the sheet that you want to convert codes,
select this macro from the Macro list (the one that is prefixed by Personal.xlsb) and run it. It will act on the sheet and provide a conversion codes.

Let me know
gowflow
Personal.xlsb
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40609635
@eenookami

Thank you as it is sometimes ... a real challenge to understand what is required and also is sometimes a mission impossible as we spend several threads before we imagine what is  needed.

Not sure if I hit it in this question but is only because I had participated in the previous one that I was able to propose something but for sure if we look at the question how it is ask, then you need to be fortune teller to guess the outcome needed.

I take this opportunity and suggest to site managers that we should have a kind of question/answers or evaluation when one subscribe to this site and as long as they did not pass the test they cannot be members this should help a lot productivity at all levels and right from the start.

Being Moderator yourself surely know better than me the channels to get this kind of proposal channeled properly.

Regards
gowflow
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 29

Expert Comment

by:gowflow
ID: 40609721
This is what makes this site the best and by far, the only best.
gowflow
0
 

Author Closing Comment

by:ceneiqe
ID: 40609914
I thought it is obvious when i asked the question in http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28610069.html#a40602548

So i was wrong. If there is any logic on code, i would have stated it.
anyway, lesson learnt for me and i did what you asked, raised a separate question.
As for the personal.xlsb part, there was a change in some procedures and having a general macro in personal.xlsb is the best way.

I always do my best to be as clear as possible in my questions and i bet i am not the only one get "picked".
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40609943
don't take it personal, but we had a very rough time on the past 3 questions of yours. I think high experts participated in your questions and were all completely not understanding what you wanted. Anyway again maybe it is the nature of what you are requesting that makes it challenging. So my suggestion for you is to put yourself in the shoes of someone who does not know what you know and simply go step by step explaining it then reading again your question as if you don't know what you know and see if what you mean and what you want is getting explain and across this would be maybe a good place to start.

to go back to this question what do you mean by:

As for the personal.xlsb part, there was a change in some procedures and having a general macro in personal.xlsb is the best way.

Did the solution proposed worked for you ??? pls do not accept a solution unless it is 100% working and satisfying.

gowflow
0
 

Author Comment

by:ceneiqe
ID: 40609947
It worked. Thanks.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40609953
and for the "picked" it is random check that are probably done to make sure all questions are clear anyhow you can click on the Request Attention that was generated for this question to know what triggered all this.

Again nothing personal.
gowflow
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question