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

[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:

>
> Hello experts,
>
> I have large data of around 10,000 drainage pipe segments and 10,000
> junctions in ArcGIS layer
>
> The problem is: due to some reason certain junctions could not be accessed
> for survey, thus 1,000+ entries are missing for pipes (up stream and d/s
> invert elevation) and junctions' surface elevation
>
> Logically, interpolation should work here. (based on slope, u/s tag invert
> level or two junction u/s tag invert level or likewise)
>
> Tried to do it manually in excel, but quite tiring and with less
> confidence (unprofessional too)
>
> ASSETID LENGTH US_INVERT DS_INVERT US_TAG DS_TAG
> *196939 76.51 0 40.42 7772 7771
>
> *197048 34.77 42.98 0 7773 7772
>
> 196938 10.45 40.61 40.46 7783 7771
>
> 196939 76.51 0 40.42 7772 7771
>
> 196940 8.26 39.88 39.84 7735 7734
>
> Drainage pipes data
>
>
> Above, I have put * to just two rows which are involved in calculations
> out of the whole data from 10,062 rows (Row 3 to Row 10,064)
>
> 1. To calculate US_INVER (US_TAG) elevation we need to find an asset where
> 7772 is under column heading DS_TAG
> 2. That is ASSETID 197048
> 3. After finding it (through some function/formula), we have got on US_INV
> and one DS_INV
> 4. Now we want to know elevation of a point in between two known
> elevations: which are +42.98 and +40.42 and total distance b/w these two
> points is length of Asset ID 196939(76.51m) and 197048(34.77m)=111.28m
> 5. The point is located 34.77m downstream of +42.98 and 76.51m upstream
> from of +40.42
> 6. We have just created a right angle triangle where Perpendicular is
> 42.98-40.42=2.56m and Base is 34.77+76.51=111.28
> 7. To calculate the angle of drainage pipe tan Ѳ = 2.56/111.28, Ѳ=1.317
> 8. After knowing the angle of pipe we can easily know the elevation of any
> point along the hypotenuse
> 9. So, US_INVERT (US_TAG) = 42.98 - tan (1.317) * 34.77 = +42.18
>
> Alternatively
> 1. After step 5. we have another choice; by dividing value of
> perpendicular with base and multiply with distance from upstream and
> subtracting from upstream elevation i.e. 42.98 - (2.56/111.28)*34.77 =
> +42.18 again
>
> This is the value we require at US_INVER (US_TAG) of Asset ID 196939
>
> And
>
> DS_INVERT (DS_TAG) of ASSETID 197048
>
> Also, something similar would be require to fill in the missing data under
> column DS_INVERT
>
> There are around 1000 missing values, if we know the formula we Ctrl+H
> (find and replace “0”) to save time and effort
>
> Also, sometime one asset upstream we wont get any value (“0”again), in
> that case we can go two steps up (but, if it is not possible we can leave
> it for manual calculation)
>
> The main challenge here, in my understanding is finding a function which
> could find US_TAG value of row (in question) in a DS_TAG column and start
> calculating by taking values from that row and row in question.
>
> Note: the DS_TAG value could be found in multiple rows, in that case
> priority should be given to a row with least value in LENGTH column. (again
> if it is difficult, any of row could be taken)
>
> It seems we are pushing MSEXCEL to its limits from where C++ programming
> starts,
>
> The complete file in excel format is uploaded at
>
> http://www.mediafire.com/?uniy9cic1gvxytp
>
> http://www.mediafire.com/?uniy9cic1gvxytp
>
> Thanks for your time reading and efforts to solve it
>
>
> Regards
> Yogananda Muthaiah
> Ph : 973 123 7267
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

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

[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 change column A with format cell option
> but does the same
>
> could you pls help me how to resolve the problem
>
> Regards
> V.Kiran Kumar
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


date_format.xls
Description: MS-Excel spreadsheet

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

[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, Philehof  wrote:

> 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 = CreateObject("internetexplorer.application")
> ie.Visible = True
> url = "http://www.un.com";
> ie.navigate url
>
> End Sub
>
> Greetings,
> Rune
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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 = CreateObject("internetexplorer.application")
ie.Visible = True
url = "http://www.un.com";
ie.navigate url
  
End Sub

Greetings,
Rune

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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 ends)

Thank you.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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 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 in provinding code .
>>
>> i am attaching sop and files in download zip.
>>
>>
>>
>> thanks,
>> rekha
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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 in provinding code .
>
> i am attaching sop and files in download zip.
>
>
>
> thanks,
> rekha
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Future Inv Date_ Open Invoice Report-Markets.xlsm
Description: Binary data

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

[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 concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[♥ . • : *¨¨* : • . ♥ . • : 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 2012 22:25:06 +0200
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ seeking help on Date format
>
> 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 change column A with format cell option
> but does the same
>
> could you pls help me how to resolve the problem
>
> Regards
> V.Kiran Kumar
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



--

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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":"\/live_market\/dynaContent\/live_watch\/get_quote\/GetQuoteFO.jsp?underlying=JUBLFOOD&instrument=FUTSTK&expiry=23FEB2012&type=-&strike=-","otherSeries":["EQ"],"lastUpdateTime":"13-FEB-2012
 
16:00:13","tradedDate":"13FEB2012","data":[{"extremeLossMargin":"5.36","bcStartDate":"13-AUG-11","change":"-0.70","buyQuantity3":"-","sellPrice1":"999.75","buyQuantity4":"-","sellPrice2":"-","priceBand":"No
 
Band","buyQuantity1":"-","deliveryQuantity":"2,11,877","buyQuantity2":"-","cm_adj_low":"467.10","sellPrice5":"-","quantityTraded":"10,95,536","buyQuantity5":"-","sellPrice3":"-","sellPrice4":"-","open":"1,005.30","cm_adj_high":"1,049.70","low52":"484.50","securityVar":"13.65","marketType":"N","pricebandupper":"No
 Price 
Band","totalTradedValue":"11,010.58","faceValue":"10.00","ndStartDate":"-","previousClose":"1,000.40","symbol":"JUBLFOOD","varMargin":"13.65","lastPrice":"999.70","pChange":"-0.07","adhocMargin":"-","companyName":"Jubilant
 Foodworks 
Limited","averagePrice":"1,005.04","secDate":"13FEB2012","series":"EQ","isinCode":"INE797F01012","indexVar":"-","pricebandlower":"No
 Price Band","totalBuyQuantity":"-","high52":"1,049.70","purpose":"ANNUAL 
GENERAL 
MEETING","cm_adj_low_dt":"10-FEB-11","closePrice":"999.75","recordDate":"-","cm_adj_high_dt":"10-FEB-12","totalSellQuantity":"379","dayHigh":"1,021.15","exDate":"11-AUG-11","sellQuantity5":"-","bcEndDate":"20-AUG-11","ndEndDate":"-","sellQuantity2":"-","sellQuantity1":"379","buyPrice1":"-","sellQuantity4":"-","buyPrice2":"-","sellQuantity3":"-","applicableMargin":"19.01","buyPrice4":"-","buyPrice3":"-","buyPrice5":"-","dayLow":"984.25","deliveryToTradedQuantity":"19.34","totalTradedVolume":"10,95,536"}],"optLink":"\/marketinfo\/sym_map\/symbolMapping.jsp?symbol=JUBLFOOD&instrument=-&date=-&segmentLink=17&symbolCount=2"}
 



Yahoo
  999.75 Down0.65(0.06%) 5:28AM EST 
  Add to Portfolio  
  Prev Close: 1,000.40 
  Open: 1,005.30 
  Bid: 999.10 
  Ask: 999.75 
  1y Target Est: N/A 
  Beta: N/A 
  Next Earnings Date: N/A 
  Day's Range: 984.25 - 1,021.15 
  52wk Range: 484.50 - 1,049.70 
  Volume: 1,095,536 
  Avg Vol (3m): 1,059,540 
  Market Cap: N/A 
  P/E (ttm): N/A 
  EPS (ttm): N/A 
  Div & Yield: N/A (N/A) 


Don Guillett
SalesAid Software
dguille...@gmail.com

From: sharad jain 
Sent: Sunday, February 12, 2012 10:37 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Price Download from NSE - Urgent

Hi Experts,

Can anyone suggest a way to directly download the prices from NSE website? I 
can provide ticker in a cell.

I am talking about downloading the latest price following url:

http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD

Please treat this as an urgency.

Thanks,
Sharad




-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Error Code

[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* twice


On Mon, Feb 13, 2012 at 4:22 PM, NOORAIN ANSARI wrote:

> 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 do
>>
>> ** **
>>
>> 
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>> *Thanks&Regards*
>>
>> * *
>>
>> *   **Veerendra.Vanam*
>>
>>   *TOC TEAM*
>> * *  *Bhagyanagar Electrical & Contractors**
>> ****H.No-5-9-286/65,Plot No-65
>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>>   Hyderabad-500072,-Andhra Pradesh
>> **   **91-9177-444-840**,*
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/* 
> *http://excelmacroworld.blogspot.com/*
>
>
>


-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ Error Code

[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 do
>
> ** **
>
> 
>
>
>
> --
>
>
>
>
>
> *Thanks&Regards*
>
> * *
>
> *   **Veerendra.Vanam*
>
>   *TOC TEAM*
> * *  *Bhagyanagar Electrical & Contractors**
> ****H.No-5-9-286/65,Plot No-65
> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>   Hyderabad-500072,-Andhra Pradesh
> **   **91-9177-444-840**,*
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

$$Excel-Macros$$ Error Code

[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,Near Andhra Jyothi Press,IE-Kukatpally,
  Hyderabad-500072,-Andhra Pradesh
**   **91-9177-444-840**,*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

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

[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 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 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 the prices from NSE
> website? I can provide ticker in a cell.
>
> I am talking about downloading the latest price following url:
>
>
> http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD
>
> Please treat this as an urgency.
>
> Thanks,
> Sharad
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --

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

[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 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 the prices from NSE
 website? I can provide ticker in a cell.

 I am talking about downloading the latest price following url:


 http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD

 Please treat this as an urgency.

 Thanks,
 Sharad




 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't pos

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

[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
>  On Error GoTo 0
> End Sub
> *
>
> Regards,
>
> MARIES.
>
> On Mon, Feb 13, 2012 at 9:59 AM, Ashish Bhalara  > wrote:
>
>> Dear expert, is there any macro code to transfer value only selected cell
>> by running the code?
>>
>>
>> On Fri, Feb 10, 2012 at 6:59 PM, Sam Mathai Chacko wrote:
>>
>>> This does exactly what you need
>>>
>>> http://www.ozgrid.com/forum/showthread.php?t=144212
>>>
>>> Regards,
>>>
>>> Sam Mathai Chacko
>>>
>>>
>>> On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad 
>>> wrote:
>>>
  Divide from lac  =165221/10 (1.65221)**


   *From:* Ashish Bhalara 
 *To:* excel-macros@googlegroups.com
 *Sent:* Friday, 10 February 2012 5:34 PM
 *Subject:* $$Excel-Macros$$ Transfer number in unit Rs.Lacs

 Dear expert,

 I require the macro to transfer the number in unit Rs.Lacs.
 For example the cell which contain number of 165221 then run macro for
 selected cell and its value transfer to 1.65221

 Thanks & regards

 Ashish Bhalara
 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>
>>>
>>> --
>>> Sam Mathai Chacko
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --

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

[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://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 the prices from NSE
>>> website? I can provide ticker in a cell.
>>>
>>> I am talking about downloading the latest price following url:
>>>
>>>
>>> http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD
>>>
>>> Please treat this as an urgency.
>>>
>>> Thanks,
>>> Sharad
>>>
>>>
>>>
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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 the prices from NSE
>> website? I can provide ticker in a cell.
>>
>> I am talking about downloading the latest price following url:
>>
>>
>> http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD
>>
>> Please treat this as an urgency.
>>
>> Thanks,
>> Sharad
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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
chandru

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

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

[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
>> (Rupees).
>>
>> I have enclosed macro related to Dollar value but i need the same for
>> Rupees.
>>
>> Kindly help regarding the same if possible.
>>
>> Regards,
>> VENUS
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/* 
> *http://excelmacroworld.blogspot.com/*
>
>
>


-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com