[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Macro to replace old codes with new codes II

Posted on 2015-02-12
10
Medium Priority
?
50 Views
Last Modified: 2015-02-14
0
Comment
Question by:ceneiqe
  • 5
  • 2
8 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 31

Accepted Solution

by:
gowflow earned 2000 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 31

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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 31

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 31

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 31

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

872 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