A very nice utility Sub CreateListOfSheetNames() Set wkbkToCount = ActiveWorkbook iRow = 1 With Sheets.Add For Each ws In wkbkToCount.Worksheets .Rows(iRow).Cells(1).Value = ws.Name ActiveSheet.Hyperlinks.Add Anchor:=.Rows(iRow).Cells(1), Address:=”", SubAddress:= _ ws.Name & “!A1″, TextToDisplay:=ws.Name iRow = iRow + 1 Next End With End Sub Posted in Macros, VB   Tagged: excel macro   

Following is a code to remove a child from a parent by passing it’s instance name as a string and parent as a display object import fl.controls.Button; //———– Draw a graphics on the stage ———- var t:Sprite = new Sprite(); t.name = “testSprite”; t.graphics.lineStyle(1,0×0000ff); t.graphics.beginFill(0xff0000); t.graphics.drawCircle(0,0,50); t.graphics.endFill(); addChild(t); t.x =100; t.y = 100; //———– Remove Child Function ————– function removeChildWithRef(spriteName:String, parentObj:*){ var t:DisplayObject = parentObj.getChildByName(spriteName); parentObj.removeChild(t); } //————- Add  a Button [...]

While reading a book i come to a very interesting topic which i would like to share here ———————– By default, The bitmap instances that reference a given BitmapData object are notified every time setPixel32( ) or setPixel( ) is called on that object. When setPixel32( ) or setPixel( ) are used in rapid succession within the [...]

The following code is solution to a problem where you need to make the accordion component’s MouseOver event to behave like a click event. The code will work only in the case if you have not given the names to the AccordionHeader explicitly. Check the solution out here <?xml version=”1.0″?> <mx:Application xmlns:mx=”http://www.adobe.com/2006/mxml”> <mx:Script> <![CDATA[ public function onMouseOver(evt:MouseEvent):void{ var strName:String = [...]

The post contains a solution for a case where you need to attach a Library symbol and you have to pass that class name as a string to the function. The approach followed here is by using the getDefinitionByName utility which interprets the string and convert it into a Class. Then you can use a new [...]

You can enable the hand cursor on a MovieClip by defining the following statement MovieClip.buttonMode = true; However the solution does not work in-case you have a dynamic textField in that movieclip. To enable hand in this case you have to additionally write the following statement MovieClip.mouseChildren = false; The reason is that the mouseChildren property determines whether or [...]

Adobe had released the Flash CS4 professional edition at a preorder price of $699. Following are the Some of highlighted features Object-based animation 3D transformation Procedural modeling with Deco and Spray Brush Metadata (XMP) support Authoring for Adobe AIR XFL support Inverse kinematics with the Bones tool Motion editor Motion presets H.264 support Check here for more details http://www.adobe.com/products/flash/features/?view=topnew&promoid=DRHWS Posted in AIR, Flash Player   Tagged: Flash CS4    [...]

I have developed this XMLUtility class in conjunction with a CustomEvent Class which returns me the loaded XML/String Data along with the complete event firing. You can download the sources from here. Following is the code you need to write when you want to load this class //———— Import Classes import com.flexcomps.utils.CustomEvent; import com.flexcomps.utils.XMLLoaderUtil; //——– Create instance of loader [...]

The post is regarding a solution in case you have some numeric data with commas, which is going to be shown in a datagrid with sorting enabled. If you use the Array.NUMERIC as an option on the DataGridColumn.sortOptions with values having comma the results are not as desired. So what we have done is use [...]

Here is a ScrollBar component class. The class takes a movieClip as a parameter and then attach the scrollbar to it. Following is the snapshot of same You can download the sources from here