Hi,
I want to basically fetch historical data of stock markets -
derivatives - from the website of NSEINDIA.COM, when i manually go to
the site and try to fetch data for a data, the URL generally comes
like
eg:
http://www.nseindia.com/content/historical/DERIVATIVES/2009/MAY/fo06MAY2009bhav.csv
You may use the following code instead of last one. In place of msgbox you
can call some macro which you wish to run when "Enter" is pressed. The
present code assumes column 3 as having the data instead of column 4 which
you need.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Di
Dear All
i want to wirte macro for attach NAV calculation. i want when i click on
button
the macro will calculate the results,steps are mention in sheet, please find
the attach sheet.
--~--~-~--~~~---~--~~
---
Hi All,
Please help me out with an Ebook on excel.
Thanks & Regards
Prateek Pahwa
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and
Dear All,
Kindly suggest how to start with. i am updating leaves for employees. if
they applied in system no problem, if they not applied i need to apply on
behalf of them.
there wiil be lot leaves to be applied. it was major problem in
consolidating leave data., so i need to automate the proc
Thank you for the response.
The problem with this code is that the macro run as soon as the cell
is selected. I want the macro to wait until the user presses "Enter".
I don't want the macro to run if the user every time the user clicks
on or goes to the cell.
On May 8, 12:14 am, Akhilesh Karna
Try using "BeforeSave" rather than "BeforeClose"
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As
Integer)
Worksheets("test").Visible = xlSheetVeryHidden
end sub
On May 6, 12:05 pm, sa_bear wrote:
> Hi,
>
> I need to hide a worksheet on closing the workbook.
>
hi Aindril
as i am trying to calculate the lowest average sale week and the
average highest week, there is sporadical data in there, usually just
one to 2 weeks worth of sales that his rock bottom but these are not
at the beginning or the end of the year so in order for me to get this
info would
Hi,
Please help me on doing below macro
I want an Excel spreadsheet put together where employees can log their hours
worked ie - Started at 9am and finished at 7:30pm. It is to be a fortnightly
timesheet. I want the spreadsheet to populate the penalty rate hours
(normal/1.25/1.5/2) with the f
Put your code on Worksheet_onEnter event hope that would be able to
solve your problem.
On May 8, 9:14 am, Akhilesh Karna wrote:
> The following code may be of help:
>
> open excel
> open visual basic editor
> double click sheet1 (or any other sheet) under microsoft excel objects
> Add the follo
Hi Group ,
Members working on Oracle E business Suite 11i would be aware that the
report generated in oracle is saved in “txt” form.
My requirement is with regard to the General Ledger Report generated under
request type “ Account Analysis – (180 Char).
For analysis purposes , the text f
11 matches
Mail list logo