Excel Help???????

**kamirafiq2009** · 10th July 2009, 08:09 PM

aoa. Umed Ha Sub Members Thek Thak Hun Ge. Mujhay Xcel K Hawale Se 2 Chezen Pochne Han.

1. Macro Kya Chez Ha Or Kese Use Karte Han. Full Detail Den.

2. Excel Man Flash Games Kese Ate Han. Like Agar Ap Ne Bush Sheo Game Khela Ho Wo Excel Mani Hota Ha Ye Kese Hota Ha.

thnx N Regards

**anmol_kismat** · 11th July 2009, 04:05 PM

dear app yeh blog check karey shayad app key help ho jaye.. ahs main excel key vedios hai... yeh vedios dekhanay k bhad app ko kafi help mil jaye gi

**kamirafiq2009** · 11th July 2009, 04:55 PM

bhai link khan ha.

**kamirafiq2009** · 12th July 2009, 12:52 AM

chk ker k btata hun. thnx

**Mubashir Aziz** · 13th July 2009, 10:07 AM

Concept of Macro

Main aap ko aik example kay thru macro ka concept batanay key koshish karta hou ….. Iss kay liye hum Excel kay VB Editor main Aik marco likhtay hain …..

Aap below steps excel ko run kay kay karain ….

Open the VBE (Alt+F11)
Click Insert | Module
Copy the entire code from "Function to End Function" from my post

Code:

Function myadd(x As Integer, y As Integer)
    myadd = x + y
End Function

Paste it into the code pane (right-hand pane)
Press Alt+Q to close the VBE

Aab aap excel main kissi bhi cell main myadd=(A2,A5) (ya koi bhoi do cell , kay sath lihain gay to yah A2 aur A5 main mojoud cells ko aapus main add kar day ga.
Programming terminology main yah function kahlata hay aur Excel main hum issay macro kahtay hain.

Flash Object ko insert karnay kay liye do the below steps ……

1. Firstly, in Excel 2003 and below, open the control toolbox.
2. Choose "More controls", then "Shockwave Flash Object". Drag a rectangle to the size of your choice. Right-click, choose "Properties".
3. In the "Properties" dialog, scroll to the top and there should be a heading called "custom". In the box next to this, when you click it, a button with "..." should appear. Click this button. A window will appear.
4. In one of the boxes in this window you need to enter the full URL of your flash object, e.g C:\flashthing.swf
5. In the same window check Embeded Movie
6. Now In Properties Control box check the box next to "Embed Movie" as true
7. Click "OK", save the spreadsheet, close it and open it.

Your flash object will be running

**kamirafiq2009** · 20th July 2009, 02:09 PM

thnx bhai main chk kar k btata hun.

**smrat_boy** · 20th July 2009, 02:12 PM

Concept of Macro

Main aap ko aik example kay thru macro ka concept batanay key koshish karta hou ….. Iss kay liye hum Excel kay VB Editor main Aik marco likhtay hain …..

Aap below steps excel ko run kay kay karain ….

Open the VBE (Alt+F11)
Click Insert | Module
Copy the entire code from "Function to End Function" from my post

Code:
Function myadd(x As Integer, y As Integer)
myadd = x + y
End FunctionPaste it into the code pane (right-hand pane)
Press Alt+Q to close the VBE

Aab aap excel main kissi bhi cell main myadd=(A2,A5) (ya koi bhoi do cell , kay sath lihain gay to yah A2 aur A5 main mojoud cells ko aapus main add kar day ga.
Programming terminology main yah function kahlata hay aur Excel main hum issay macro kahtay hain.

Flash Object ko insert karnay kay liye do the below steps ……

1. Firstly, in Excel 2003 and below, open the control toolbox.
2. Choose "More controls", then "Shockwave Flash Object". Drag a rectangle to the size of your choice. Right-click, choose "Properties".
3. In the "Properties" dialog, scroll to the top and there should be a heading called "custom". In the box next to this, when you click it, a button with "..." should appear. Click this button. A window will appear.
4. In one of the boxes in this window you need to enter the full URL of your flash object, e.g C:\flashthing.swf
5. In the same window check Embeded Movie
6. Now In Properties Control box check the box next to "Embed Movie" as true
7. Click "OK", save the spreadsheet, close it and open it.

Your flash object will be running

ya correct ha

**mihmay** · 20th July 2009, 02:31 PM

Koi ek task jo aaap ek se ziada martaba karna chahtay hoon, same sheet main yaaa multiples sheet main..e.g cell A1 ko plus karna hoo Cell 2 se then graph chart banana hoo dn formating karni hooo, etc etc .....i hope thodi si hints se aap ko samajh aaa jai gi warna aaap batana main mazeed example day doon ga

**kamirafiq2009** · 20th July 2009, 03:33 PM

mihmay said:

Koi ek task jo aaap ek se ziada martaba karna chahtay hoon, same sheet main yaaa multiples sheet main..e.g cell A1 ko plus karna hoo Cell 2 se then graph chart banana hoo dn formating karni hooo, etc etc .....i hope thodi si hints se aap ko samajh aaa jai gi warna aaap batana main mazeed example day doon ga

REPLY KA SHUKRIA AGAR APP BHI KOI EXAMPLE DE SAKEN TO KYA BAAT HA.

**kamirafiq2009** · 20th July 2009, 06:08 PM

bhai main ne ap k kehne k mutabiq excel main flash object insert kya lakn is tarhan ki screen arahe ha. ye kya masla ha. mai ap ko file send karta hun ap use insert kar k btyan.file ka link ye ha.

http://www.4shared.com/file/11932273...uranflash.html

**kamirafiq2009** · 20th July 2009, 06:14 PM

Ye Bhi Btyan K Kisi Excel Ki File Mai Se Flash File Kese Copy Ya Cut Kar Sakte Han. Jaise Hum Insert Karte Han Wese He Cut Bhi To Kar Sakte Hon Ge Na?