$$Excel-Macros$$ Re: Venn diagram creation

2009-02-07 Thread Aindril De
Hi Mark, Excel does not have a built-in ability to produce venn diagram charts. Although if I am not wrong!! Excel-XP had a venn diagram autoshape. I am not sure that it is linked to data in anyway though. I also read somewhere that: Excel 2k3 can create a Venn diagram using the menu Insert > Dia

$$Excel-Macros$$ Re: about if ...then with iserror

2009-02-07 Thread 2008ra...@gmail.com
THANK YOU VERY MUCH THAT IS REALLY PERFECT BUT CAN YOU EXPLAIN ME THAT ABOUT "VLOOK" AND "ON ERROR RESUMEN NEXT " .PLEASE GRACIAS --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send

$$Excel-Macros$$ Venn diagram creation

2009-02-07 Thread Mark Hanley
I need to create a Venn diagram with three circles and insert names into each section based on three sets of values. I'm wondering if the drawing API in VBA would be up to the job. I need to be able to position the names with x and y coordinates so that they are in the right section (i.e. I don't

$$Excel-Macros$$ Open a file into excel

2009-02-07 Thread brotherton.jul...@googlemail.com
I use the follwoing code to open files. What I require is to only show files called "stations.ODB" not all of the ODB files. I have tried altering GetOpenFilename("ODB_FILES (*.ODB),*.ODB") to GetOpenFilename ("ODB_FILES (stations.

$$Excel-Macros$$ excel fourmula

2009-02-07 Thread jaijindera
http://spreadsheets.about.com/od/datamanagementinexcel/ss/080608_database.htm please follow this link --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@goog