Seeking advice from advance excel gurus on this forum

[Corried]

Hello excel world.


I am seeking advice from advance excel gurus on this forum.


Here's the concern.


I found this code with its photo below searching online:


string strCountry = US; // Set country ( sheet name )
plotxy iy:=[Book1]strCountry$!(1,2) plot:=200 ogl:=[<new template:=LINE12>]; // Plot into graph template LINE12 that is pre-created.
plotxy iy:=[Book2]strCountry$!(1,2) plot:=200 ogl:=1;
layer -g; //Group plots

My problem here is this:


#1 How can I modify this code to automatically detect, the same worksheet names on each workbook. Example: Workbook (A) worksheet (United States) and workbook (B) worksheet (United States)


Now
Workbook (A) have 181 worksheets. (Each worksheet represent a country) And
Workbook (B) have 185 worksheets. (Each worksheet represent a country) Next.


#2 How can I modify the code to create a line and column chart automatically? Placing dates on the X axis and values from both workbooks using their prospective worksheets on both sides of the Y axis, beginning from the zero value.


How can this be done automatically, filling each worksheet with a chart, while extracting data from each workbook?

 

[Norie]

Where did you find the code?

 

[Corried]

I am sorry.

string strCountry = US; // Set country ( sheet name )
plotxy iy:=[Book1]strCountry$!(1,2) plot:=200 ogl:=[<new template:=LINE12>]; // Plot into graph template LINE12 that is pre-created.
plotxy iy:=[Book2]strCountry$!(1,2) plot:=200 ogl:=1;
layer -g; //Group plots

I found it on "originlab".

Hope I answer the question...

How do you want me to move forward?

Thanks in advance

 

[Fluff]

Cross posted Seeking advice from advance excel gurus on this forum

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Corried]

Ok. Thanks Fluff for the feed back. Would make the correction going forward.
What do you recommend me to do?

 

[Fluff]

Just ensure you let us know of all/any crossposts.

 

[Corried]

Just ensure you let us know of all/any crossposts.

No problem. Thanks.

I am not sure if you are open and willing to help me. I just don't know.

Is there any advice are you willing to share?

 

[Fluff]

I can't give any advice because, as far as I can see, it has nothing to do with Excel

 

[Corried]

I can't give any advice because, as far as I can see, it has nothing to do with Excel

Ok. I am sorry. It sounds like I misunderstand what I am asking.

I beg for your forgiveness. Please. If what you say is true. Are you open in pointing me to the right direction. I promise you wouldn't here from me on "this" topic no more, unless someone else respond.

Thanks in advance.

New Member

 

[Fluff]

I'm afraid I don't understand what you are saying.
You have asked a question about an app from OriginLab, which (AFAIK) has nothing to do with Excel.