Search results

thanks, but i cant seem to find the edit thread anymore. maybe there is a time limitation

Thanks vletm and Marc. I have not write the code yet as of tuesday because I am still looking for solution that needed the least code length. Anyway, I decided to make the background square (n x n size) and then i look for the bigger number between the length and width. Then I resize the bigger...

Dear All I am trying to insert random image and resize it to match the picture place holder (just a square as background). I just want to make sure the image size is smaller than the picture background but still maintain the original aspect ratio, how do i approach this problem? I hope i make...

== SOLVED === just allow_interactivity = true Dear All Has anyone try interactive embedded workbook and succeded? I try using slicer yesterday, uploaded it and embed it on a small html file (in my drive) and it works. I dont know how but it works but now it does not work anymore. Looking...

Thanks Hui, it works now...

So, I just read http://chandoo.org/wp/2008/08/21/display-symbols-excel-chart/#comment-1192230 and try to copy the example but I cannot get webdings or windings to works. Only font with subsets. Any ideas how/why? Thanks in advance.

This may not be what you need, but this is what came to mind. I change the bussiness into modul A to J instead of 1 to 20 and its interactive, you can view the modul that you want (ex, only your bussiness/modul) Hope it helps.

Is this it? no macro, just change the value

Hi Rush, I would like to help but the thing is, i still don't understand your data and what you are trying to to do. Does question 1 and 2 are a pair? so does 3 and 4 and so on.... I attached a macro file which you can changed the intersection manually without going through axis format..

rush, are you trying to make a quadrant analysist..... Please look at the attachment... Btw, you need to adjust where the axis crossed manually.... if you have more than 1 graph, i suggest record a macro and modify it to your need.. Best wished

Thanks Hui.

thanks Misra and Hui... I solved it but I don't know how to edit the title. And Hui, thanks, it looks clean. [more knowledge for me - very nicely done Hui but I think it still has a flaw, the end date will not match with the requirement - the data in the end date will be over then requested]

[SOLVED] did not put full workbook right and I do not know how to edit the title ^^ Dear all, I tried to recreate a dynamic chart using named range in excel 2013. I've download the file from chandoo.org and been searching for quite some time for what I did wrong to no avail. I attached sample...

Hi Narayank, Just wondering, do you use shortest path algorithm from A to B or just basically look for nearest position from A (as long as it is not B), then look for another nearest position and so on. I always find path finding algorithm interesting.

Email sent. I run it again before I email it, and it is still the same. I give link to both macro so that you can notice the difference. Thanks

I cannot upload the file in public but I can email it to you.

Yes, that is exactly my point. I have tried to use break point on oPA.Quit and press F8, but does not seem to do anything and there isn't any error message as well. When i look at the powerpoint before oPA.Quit, there are no file open. Just an empty powerpoint app.

the sub module KopiPie, KopiTabel1,... only add new slide, copy some chart/shape and then return back to main module What is not working is that, the powerpoint app is not closing whereas in the second code it is closing (i did not see powerpoint still open when the code has finished). I hope i...

Option Explicit Dim sht As Variant Dim oPA As PowerPoint.Application Dim oPP As PowerPoint.Presentation Dim oPS As PowerPoint.Slide Dim sr As PowerPoint.ShapeRange Dim oShape As PowerPoint.Shape Dim NamaProv, NamaKab As String Dim NmFile, cnt, i, JudulSlide, j, k Dim AwalKab, AkhirKab Dim...

Hi all, I am trying to copy chart/shape from excel to powerpoint and save it as different files based on region. It is working fine, but somehow when I save it as a single file, the powerpoint app close, while in different files it is not. Here is the sample code that does not working Set oPS...

Dear All, Pardon for asking [out topic] outlook question here but perhaps someone been using outlook vba and can shed some light. I've been searching through the internet and still could not find the answer for my question regarding outlook. I plan to have an email base information server where...

DebraJ: Sorry, my internet is having problem. I mean I link to cells such as K1 - K5 which consist all the criteria Narayan : Thank you for the quick reply. I try to understand it first. Any idea on non array formula? My original data consist more than 100k record. I tried to avoid array...

Narayan: Is it possible to use non adjacent column with your formula? Because that is what I wanted to do. DebraJ : How do you add Blank to data validation list -- Nervermind... I just use cells for this... Thanks

Thanks alot Narayan. Can you explain why it failed to work before? Btw, I still dont understand why it works Why I cannot use ...

Dear all I am looking for (non array formula) alternative solution to sumif problem. I edited two solutions from my previous problem and so far only array formula that works. Any idea on what went wrong? I attached the sample workboook Thanks in advance