Re: $$Excel-Macros$$ How to learn VSTO with excel.

Hi, MSDN library would help... see the below link:- http://msdn.microsoft.com/en-us/vsto/dd162436 Best Regards, DILIPandey On 6/22/11, Mr excel wrote: > hi all, > > I want to learn VSTO for excel.anybody please give me the notes,pdf or > urls for learning. > > thanks & regards... > > -- > --

Re: $$Excel-Macros$$ Macro causing drawing objects to be deleted

Just a thought, check if the object is locked (from object properties). I believe objects generally shifts up / down when you delete rows. Might be something happening between migration from / to 2003 and 2007 version. This is interesting and there are learners who wish to know the main cause of

Re: $$Excel-Macros$$ Need Tutorial for VBA

Hi Gagan, If you have already secured good knowledge of Excel, then I would suggest you to go for something like, crash course of Excel Programming. This will save definitely save your lots of time. You can get these types of e-books over internet. Thanks. Best Regards, DILIPandey On 6/23/11,

Re: $$Excel-Macros$$ Need Tutorial for VBA

Hi Gagan, Also refer below website, this website has some cool VBA videos. http://www.excelvbasql.com/Home.aspx Thanks, Rahim Sharieff. On Thu, Jun 23, 2011 at 6:53 PM, Gagan Singh wrote: > Hi, > > I've good knowledge of Excel. Now i wanna learn how to make macro's using > VBA. Can someone r

$$Excel-Macros$$ Re: VBA Tip # Calculate how long macro runs.

Just a note, the accuracy/resolution of this method is limited to 1 second. This is described in the link below as well as methods that provide greater accuracy (if required). http://support.microsoft.com/default.aspx?scid=kb;EN-US;q172338 A method of implementing this is described in the follow

RE: $$Excel-Macros$$ How To Change Properties Of Form Controls

Hi, Paste the following code into the sheet module : Sub test() For Each sh In Me.Shapes If sh.DrawingObject.progID = "Forms.CommandButton.1" Then Var = sh.Name Var = Mid(sh.Name, 2, 1) If Left(sh.Name, 1) = "B" And Mid(sh.Name, 2, 1) > "0" And Mid(sh.Name, 2, 1) < "5"

$$Excel-Macros$$ VBA Tip # Calculate how long macro runs.

Hello everyone, I have posted a small code to know the duration of macro code execution. This will tell you the difference between the start time and end time of macro. Here is the link. Macro Duration VBA Code

$$Excel-Macros$$ How To Change Properties Of Form Controls

Hi Guy's, I've 20 command buttons on a worksheet to be used for different purposes. I've write a code to disable and enable all of them accordint to situations. All the buttons have a common naming standard, e.g. "B1C1","B1C2","B1C3","B1C4","B2C1","B2C2". I've tried with the following code..

RE: $$Excel-Macros$$ Need Tutorial for VBA

You can Learn VBA From www.Ozgrid.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Gagan Singh Sent: Thursday, June 23, 2011 6:53 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Tutorial for VBA Hi, I've good knowledge of

$$Excel-Macros$$ Need Tutorial for VBA

Hi, I've good knowledge of Excel. Now i wanna learn how to make macro's using VBA. Can someone refer me some websites to tutorials or a pdf file.It would be great if you can refer some site with some pictures or examples which can be helpful.you can also send me the link or any tutorial file on ga

Re: $$Excel-Macros$$ I want customised web query in excel

Hi, Kindly disable the macro security to run the macros. I tired its working. Regards, IM On Wed, Jun 22, 2011 at 10:18 PM, sharad jain wrote: > I have alread tried that. > > I have put date range as 1-Jun-2010 to 21-Jun-2011. > > On Wed, Jun 22, 2011 at 9:17 PM, ashish koul wrote: > >> chag

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

You can use a flag, public boolean variable which should be set to true by default, the code in worksheets should run only if if the flag is true. When the copy code is executed the flag has to be set to false which will prevent the code from execution. After the copy code is executed the flag c

$$Excel-Macros$$ Re: I want customised web query in excel

Thanks dude But the data i got is for very shorter period if i want data from 01-01-2005 to Today than it is not geting fetched so if you can help me for that than it would e very great ful Once again Thanks Ketan yadav On Jun 22, 5:29 pm, "Ketan" wrote: > Dear Members, > > I have attached

Re: $$Excel-Macros$$ 2003 to 2007 : VBA Code

Thanks! :) On Wed, Jun 22, 2011 at 9:18 PM, ashish koul wrote: > try this > > http://peltiertech.com/Excel/Charts/ > > > On Wed, Jun 22, 2011 at 7:56 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Pleaase can I get 2007 code to get good looking chart as 2003. Thanks! >> >> On W

Re: $$Excel-Macros$$ Private sub selection-change preventing copy paste

Hi Vasant Thank you very much, excellent work. I posted the query two times before this but I din't get a proper answer on that time.but this time u did it well. I have one more problem in that file. this file is used for marking attendance of employees, I have an another page for the settlement of