Programming

Request help
I need to get the stock data from a wabpage (www.nseindia.com) which is generated dynamically. What is the best way to do it? If I use webquerry, how to locate the required table (since there is no table no and the url is the same as home page url). Regards, Shetty ... 17 Nov 2005 05:44

Code to get data from webpage into Excel
I am trying to programmatically download, copy, import or any other way cajole the contents of a specific web page onto an Excel Worksheet. I have previously had some discussion with Dysgraphia so if he's still out there apologies for this more specific re-posting. I have tried:- Dim webBk As Workbook Set w... 10 Nov 2005 14:35

SuDoku
Hi All, Is it possible to make randum SuDoku using Excel? For suDoku eg. www.websudoku.com Thanks ... 29 Sep 2005 04:53

loops
I am a beginner programmer and I am trying to understand looping to optimize a investment portfolio with 3 types of assets S, B & C. Does anyone have experience with such a routine? I want to find the optimal weights for this portfolio by changing each asset wieght. A portfolio cant hold more than 100%. In o... 28 Sep 2005 14:54

Excel and Outlook
Im looking for VBA code that opens up Outlook from Excel, fills in the subject line and fills in predetermined message. thanks. ... 28 Sep 2005 14:54

Protect multiple worksheets in a workbook at one time in EXCEL.
I'm going to give an example of what I have to hopfully give a better understanding of what I am trying to accomplish. I have a workbook with 40 worksheets. 30 of these work sheets need to have the same specific cells unprotected, while the rest of the sheets/cells need to be protected. I have tried to only ... 20 Sep 2005 23:39

SendMail error
I have a spreadsheet that works fine if opened locally (C: drive). If it is opened in Internet Explorer (http://www.xx.com/book1.xls), it generates the following error: Run-time error '1004': Show method of Dialog class failed. The only line of code in the Button_Click event is: Application.Dialogs(xlDialogSend... 19 Sep 2005 16:33

Popup calendar
Hi, I'm looking for a popup calendar that pops from the cell and returns the chosen value back into that cell. I'm sure it exists, looked around this workgroup and did not find anything. Can anyone direct me for this. Many thanks. Paul ... 16 Sep 2005 14:43

listbox
I have a listbox which I am listing cells a1:a1000 on a worksheet called "homes". I would like the ability to have the user highlight the item in the list box and execute a code that will go to that cell. Is this possible Thanks Greg ... 16 Sep 2005 18:51

vba excel fileopen
hi with vba; i've got an excel workbook open as readonly and i need to open the same as writable to write some data. Set XL_WB = XL_App.Workbooks.Open(FileName:=EXCEL_FILENAME, ReadOnly:=True) Set XL_WB_tmp = XL_App.Workbooks.Open(FileName:=EXCEL_FILENAME, _ ReadOnly:=Fa... 16 Sep 2005 13:39