Re: $$Excel-Macros$$ 1,000 missing survey data points to be fixed by interpolation

2012-02-13 Thread PrIyAnKa
Dear Yogananda Instead of sharing such details kindly send a input or output sheet As your details are too long to read and understand and then provide u any answer SO kindly share an excel with group On Tue, Feb 14, 2012 at 6:40 AM, yogananda muthaiah < yogananda.mutha...@gmail.com> wrote: >

Re: $$Excel-Macros$$ seeking help on Date format

2012-02-13 Thread Sanjib Chatterjee
please see the attachment, may be it can help you sanjib 2012/2/13 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ < vadnalaki...@gmail.com> > Dear Excel Experts > > I have a problem in excel date format in column A > whenever i enter the date dd/mm/ it changes to mm/dd/ > > I tried to chan

Re: $$Excel-Macros$$ internetexplorer.application add an alias to a link

2012-02-13 Thread NOORAIN ANSARI
Dear Philehof, Please try it.. Sub open_url() On Error GoTo xyz Dim ie As Object Set ie = CreateObject("InternetExplorer.Application") With ie .Navigate "http://www.un.com"; .Visible = 1 End With Do While ie.busy Loop Set ie = Nothing xyz: Exit Sub End Sub On Tue, Feb 14, 2012 at 1:42 AM, Phile

$$Excel-Macros$$ internetexplorer.application add an alias to a link

2012-02-13 Thread Philehof
Hi Group With the below code, it is possible to jump to the link. How would it be possible to add an alias to url. Eg. instead of www.UN.com, then it would display *Homepage of the UN*. Option Explicit private Sub Workbook_Open() Dim ie As Object Dim url As String Set ie = Crea

$$Excel-Macros$$ Pivot Table data range update

2012-02-13 Thread Awal
I have code to query a database and return data to the "data" sheet. The number of rows of data returned will vary. Through VBA code, how do I tell the pivot table to update the range of the source data (which is really to update the last row). (Selecting CTRL-End, goes past where the actual data

Re: $$Excel-Macros$$ Need pivot & subtotal code

2012-02-13 Thread rekha siri
hi Raj, Thanks for your macro but i am sorry this is not performing vlookup function inthis. can you please look into this On Tue, Feb 14, 2012 at 12:37 AM, Raj Mahapatra wrote: > Hi Rekha, > > Please find the attached file > > Go to View Macro and Run "Macro 1" > > data automatically will

Re: $$Excel-Macros$$ Need pivot & subtotal code

2012-02-13 Thread Raj Mahapatra
Hi Rekha, Please find the attached file Go to View Macro and Run "Macro 1" data automatically will give you your output for any further queries, please feel free to revert Thanks & Regards Rajesh Mahapatra On Mon, Feb 13, 2012 at 5:29 PM, rekha siri wrote: > hi experts, > > please help me

Re: $$Excel-Macros$$ Series and Justify in Excel 2010

2012-02-13 Thread Rohan
Thanks for the effort xlstime. But these are not what I am looking for in Excel 2010. I am looking for Home - Editing - Fill button(editing section). Please help me with any tutorial for this section if possible. Thanks !! Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ seeking help on Date format

2012-02-13 Thread ♥ . • : *¨¨* : • . ♥ . • : V . Kiran Kumar : • . ♥ . • : *¨¨* : • . ♥
Thanks a lot On 12 February 2012 22:28, wrote: > ** > Go to control panel and change date format in regional setings. > -- > *From: * .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:* ¨¨*:•. > vadnalaki...@gmail.com > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 12 Feb

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

2012-02-13 Thread dguillett1
Requesting “urgent” usually turns me OFF and results in me DELETING the message, but. You can use that url and get the prices but only like this so you would need to parse out the info.Instead try Yahoo. http://finance.yahoo.com/q?s=JUBLFOOD.NS&ql=1I can send a file. {"futLink":"\/liv

Re: $$Excel-Macros$$ Error Code

2012-02-13 Thread NOORAIN ANSARI
- Click on *Excel Office Button* - Click on the *Excel Options* button - Select the *Trust Center* tab - Click on the *Trust Center Settings…* button - Select the *Privacy Options* tab - Uncheck the *Remove personal information from file properties on save*box - Click *OK* twic

Re: $$Excel-Macros$$ Error Code

2012-02-13 Thread NOORAIN ANSARI
Dear Veeru, Check below link... http://winadminnotes.wordpress.com/2011/06/21/privacy-warning-this-document-contains-macros-activex-controls/ On Mon, Feb 13, 2012 at 4:07 PM, Veeru TOC wrote: > > > Dear Group > > > Below type of Error Code Display always what can > i d

$$Excel-Macros$$ Error Code

2012-02-13 Thread Veeru TOC
Dear Group Below type of Error Code Display always what can i do ** ** -- *Thanks&Regards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical & Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

2012-02-13 Thread PrIyAnKa
Sharad in Odin - Mkt watch -right click and select the option "OPEN IN MS EXCEL " you will get the watch list in excel with fluctuation of prices Note : This will be available upto MKt hour only On Mon, Feb 13, 2012 at 3:41 PM, sharad jain wrote: > Priyanka, > > Can you please explain in detai

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

2012-02-13 Thread sharad jain
Priyanka, Can you please explain in detail? Thanks, Sharad On Mon, Feb 13, 2012 at 3:20 PM, PrIyAnKa wrote: > Dear Sharad > > Do u use ODIN? if yes then recent prices can be get directly from there > > > On Mon, Feb 13, 2012 at 3:07 PM, sharad jain wrote: > >> Thanks Maries, >> >> However, I a

Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs

2012-02-13 Thread Ashish Bhalara
Thank you very much Maries On Mon, Feb 13, 2012 at 12:58 PM, Maries wrote: > Hi, > > Try this code: > > *Sub LacsChange() > On Error Resume Next > Dim MyCell As Range > For Each MyCell In Selection.Cells > MyCell.Value = MyCell.Value / 10 > Next >

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

2012-02-13 Thread PrIyAnKa
Dear Sharad Do u use ODIN? if yes then recent prices can be get directly from there On Mon, Feb 13, 2012 at 3:07 PM, sharad jain wrote: > Thanks Maries, > > However, I am not able to download any price data. > > Regards, > Sharad > > > On Mon, Feb 13, 2012 at 10:25 AM, Maries wrote: > >> http:

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

2012-02-13 Thread sharad jain
Thanks Maries, However, I am not able to download any price data. Regards, Sharad On Mon, Feb 13, 2012 at 10:25 AM, Maries wrote: > http://www.mrexcel.com/tip103.shtml > > > On Mon, Feb 13, 2012 at 8:37 AM, sharad jain wrote: > >> Hi Experts, >> >> Can anyone suggest a way to directly download

$$Excel-Macros$$ File open my Macro Not run Excell 2007

2012-02-13 Thread chandra sekaran
Dear all, I am using Excel 2007 when i open a file My Macro Not run any one help this Private Sub Workbook_Open() MsgBox "Hi, thanks for opening me", vbInformation, "Ozgrid.com" End Sub ''=or Private Sub Workbook_Open() Call My Macro End Sub Regards

Re: $$Excel-Macros$$ Help required-Macro to Convert numeric value to words in Excel

2012-02-13 Thread NOORAIN ANSARI
http://www.4shared.com/file/3WYWaW-Y/Indian.html On Mon, Feb 13, 2012 at 1:26 PM, NOORAIN ANSARI wrote: > Dear Vikram, > > Please find attached Converter. > > On Sun, Feb 12, 2012 at 8:00 PM, Vic Kumar wrote: > >> Hi, >> >> Please find enclosed macro to convert numeric value to words in excel >>