$$Excel-Macros$$ seeking MS documenation for OLEObject add button and OLE class definition

I am looking for detailed documentation on: ActiveSheet.OLEObjects.add(ClassType:="Forms.CommandButton.1") as well as the setting of ".onAction" which I can not set without error. I can not find base MS documentation for this OLEObjects.add construct, I can not find base MS documentation for the OL

$$Excel-Macros$$ status of msgroups.net / registration fails / most recent posts are 06/2010

Hello, I was just wondering if the msgroups.net moved here in a formal or informal fashion. There isn't any status at msgroups.net saying it is for archive access only --- clearly the registration (at least for me) is broken. Server Error in '/' Application. --

Re: $$Excel-Macros$$ Need a Macro

This worked perfectly! Thank you! Sent from my iPhone On Mar 10, 2011, at 10:12 PM, Karla Haman wrote: > I will give this a shot. Thank you so much. > > Sent from my iPhone > > On Mar 10, 2011, at 9:20 PM, Dave Bonallack wrote: > >> Hi, >> One approach is to insert a new blank sheet, call i

$$Excel-Macros$$ Align cells with same value - vba almost working - please help

Hi cyberspace, I have spent quite some time trying to make this work but at this point from adding many msgbox checks, using the watch window for variables values everything seems coherent to me. I have 2 columns with sorted identical and not identical numercial values in both columns, see belo

Re: $$Excel-Macros$$ Help on a simple question

Thousands sorry ashish koul, this was a draft mail i sent by mistake, it was previous to "$$Excel-Macros$$ Help on merging certain sheets to final workbook" > can you send the sample file of three reports with headers and final > output > > > > On Thu, Mar 10, 2011 at 6:32 PM, Jorge Marques wrote

$$Excel-Macros$$ coping cells from one workbook to another, printing, deleting.....

i am saving info copied into a workbook then paste certain cells from the same row into another work book using 'paste special'. then i would like to print it, delete the pasted cell and move to the next row in the original workbook, paste it, print it and move on to the next row until the original

Re: $$Excel-Macros$$ Help on a simple question

can you send the sample file of three reports with headers and final output On Thu, Mar 10, 2011 at 6:32 PM, Jorge Marques wrote: > I have a doubt dear friends, i have 3 reports i receive each month, so > every month i have to to an overall report of the 3 like a database, but the > format of

Re: $$Excel-Macros$$ Help on pivot table

hi jorge try this created a macro which will merge data from first 3 shees like in all data sheet you have to add the headers manually and run the macro also added pivot in last sheet see if that helps On Fri, Mar 11, 2011 at 2:23 AM, Jorge Marques wrote: > Hi, is it possible to do a pivot

Re: $$Excel-Macros$$ Solustion for Num2text formula

Just so you know... desibal? If that was "decibel", it would be a unit of sound. (a ratio, actually) "Decimal" is the number of digits after the "dot" in a number. Secondly.. the answer below: =round(sum(e23:e33),"0.00") will not work as expected. The second parameter for the round() function is

Re: $$Excel-Macros$$ Solustion for Num2text formula

try this =ROUND(SUM(E23:E33),"0.00") On Fri, Mar 11, 2011 at 6:30 PM, manhar prajapati < prajapati.man...@gmail.com> wrote: > Hi > > Thanks you for reply. > > But i Require the last amount is calcualte in 2 desibal it means if the > number is 100.5201 its calcualate only 100.52 so when i round o

RE: $$Excel-Macros$$ Shortcut query

HI Ansari, I need shortcut key i.e. any keys combinations from keyboard itself rather opening any dialog boxes. Regards, Vikram Ahuja From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com] Sent: Friday, March 11, 2011 5:05 PM To: vikram Cc: excel-macros@googlegroups.com Subject: Re

RE: $$Excel-Macros$$ Formula Query

Hi Manhar, Thanks for your help. I wanted a written formula or such rather than .xls file. Secondly,if there is no such formula then how I can use this .xls file for converting all numbers in text as mentioned below such as converting below sample data. 1000 2000 3000 4000 5000

Re: $$Excel-Macros$$ Solustion for Num2text formula

Hi Thanks you for reply. But i Require the last amount is calcualte in 2 desibal it means if the number is 100.5201 its calcualate only 100.52 so when i round of the amount as +.48 its comes 101. For more details please look Attach file Regards Manhar. On Fri, Mar 11, 2011 at 5:00 PM, NOO

Re: $$Excel-Macros$$ Pls Help me in the attached file

thanks to Thamu & STED (V) & always to this group On Sat, Mar 5, 2011 at 10:28 AM, §»VIPER«§ wrote: > Hi dharmesh > > simply it will convert text (which numbers in text formats) to values. > equivalent to (value) function. > > -- > *Thanks & Regards > > Thamu > * > > On Fri, Mar 4, 2011 at 1

FW: $$Excel-Macros$$ Import .csv & match records

Hi, Please add my email id to the group. Thanks! Regards, Kirpal From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dave Bonallack Sent: Friday, February 18, 2011 7:51 AM To: excel-macros@googl

Re: $$Excel-Macros$$ Playing Gif files in excel

Hi Sanjoy, Thanks for your early reply. Can you tell me how can I add the Gif file in Html and insert the same into the sheet. Regards Santosh On Fri, Mar 11, 2011 at 11:48 AM, Sanjoy Nath wrote: > > add the gif file in html and insert that html file to the sheet > > > On Thu, Mar 10, 2011 at 1

$$Excel-Macros$$ Re: कविता : महिमा SUMPRODUCT की

Noorain, You are always awesome and this poem is phenomenal. Regards Ayush Jain 2011/3/11 NOORAIN ANSARI > Dear Experts, > > I have tried to describe importance of sumproduct function in my poem > with example. > Please read and see attached worksheet. > > SUMPRODUCT है एक..लेकिन इसके रूप

$$Excel-Macros$$ Name AND CODE

Hi Experts Please find the attached file in the attaché file I have some Code and Name which are in one column. I want bifurcate this with two column one is Name & one is Code. Please confirm, if any specify formula for this . Regards Kailash --

Re: $$Excel-Macros$$ Solustion for Num2text formula

Dear Manhar, Please see attachment... On Fri, Mar 11, 2011 at 12:59 PM, manhar prajapati < prajapati.man...@gmail.com> wrote: > Dear all > > Please help me in attach file the problam are mention in attach file and > require the help for it. > > > Require help immediate. > > Thanks & Regards > Ma

Re: $$Excel-Macros$$ Formula Query

Hi Please look Sample File. On Fri, Mar 11, 2011 at 2:52 PM, manhar prajapati < prajapati.man...@gmail.com> wrote: > Dear Vikram > > Please use attach addins file. > > Regards > > Manhar Prajapati > On Fri, Mar 11, 2011 at 11:53 AM, vikram wrote: > >> Hi, >> >> >> >> Please help if anybody ca

Re: $$Excel-Macros$$ Formula Query

Dear Vikram Please use attach addins file. Regards Manhar Prajapati On Fri, Mar 11, 2011 at 11:53 AM, vikram wrote: > Hi, > > > > Please help if anybody can provide formula regarding below query: > > > > Whenever we type any amount i.e. in number such as Rs.1000.00 it converts > in words such

$$Excel-Macros$$ Solustion for Num2text formula

Dear all Please help me in attach file the problam are mention in attach file and require the help for it. Require help immediate. Thanks & Regards Manhar Prajapati -- -- Some important links for excel users: 1. F

Re: $$Excel-Macros$$ Playing Gif files in excel

add the gif file in html and insert that html file to the sheet On Thu, Mar 10, 2011 at 11:00 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi, > > Can anyone help me in playing a gif file in excel > > I am using excel 2003 and 2007 version. > > I want to play a gif file in work

Re: $$Excel-Macros$$ Need a Macro

I will give this a shot. Thank you so much. Sent from my iPhone On Mar 10, 2011, at 9:20 PM, Dave Bonallack wrote: > Hi, > One approach is to insert a new blank sheet, call it "END" and move it to > become the last sheet in the workbook. > Whenever adding new sheets, make sure they sit before