Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 13 of 13
Search took 0.01 seconds.
Search: Posts Made By: Wall st Guru
Forum: Excel VBA March 20th, 2006, 10:21 AM
Replies: 1
Views: 1,819
Posted By Wall st Guru
Extract Email into Excel

I am trying to somehow extract the info. from an email msg. directly into Excel for analysis. I would appreciate if someone could advice how to connect to the Email server for Outlook and how to read...
Forum: Excel VBA March 18th, 2006, 08:36 AM
Replies: 0
Views: 2,926
Posted By Wall st Guru
.Shapes.AddFormControl(xlListBox

I have created a List box using the following macro. But I'm clueless as to how to extract the selected value from the list:

Set lb = Worksheets("Sheet1").Shapes.AddFormControl(xlListBox, 1, 1,...
Forum: Excel VBA March 15th, 2006, 10:13 AM
Replies: 3
Views: 1,513
Posted By Wall st Guru
Actually, I'm trying to create a form which will...

Actually, I'm trying to create a form which will have 3 list boxes with 1st.Country, 2nd.State & 3rd.City. So when I first select the country list box, the state list should be populated with only...
Forum: Excel VBA March 13th, 2006, 01:07 AM
Replies: 3
Views: 1,513
Posted By Wall st Guru
Progressive list boxes

I have a table with cost of living for every city in a region. I am trying to create a form which has a list box for Country, State & City, with State and city list box being disabled at first. So,...
Forum: Excel VBA February 28th, 2006, 06:58 AM
Replies: 1
Views: 3,624
Posted By Wall st Guru
ListFillRange from another closed workbook

How do I create a drop down list from another excel workbook without opening it?

With Worksheets(1)
Set lb = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 100)
lb.ControlFormat.ListFillRange =...
Forum: Excel VBA February 28th, 2006, 01:50 AM
Replies: 2
Views: 229,012
Posted By Wall st Guru
ADODB.Connection user-defined type not defined

When I type

Dim cnn As ADODB.Connection

to connect to another excel from within excel I get the error

user-defined type not defined

I would appreciate if someone could help me on this.
Forum: Excel VBA February 27th, 2006, 09:46 AM
Replies: 0
Views: 810
Posted By Wall st Guru
Update info from Access

I have a access database of the list of expenses for a particular port every time a ship calls there. And I have an excel sheet formatted to do some analysis based on those expenses. I am trying to...
Forum: Excel VBA February 23rd, 2006, 07:46 AM
Replies: 1
Views: 4,409
Posted By Wall st Guru
Connect to Outlook Express email

I have an excel sheet where I monitor the performance of a small fleet of ships everyday. I get daily updates about say, the amount of cargo loaded/off-loaded everyday, amount of fuel consumed,...
Forum: Excel VBA February 23rd, 2006, 07:40 AM
Replies: 2
Views: 1,067
Posted By Wall st Guru
Thanks a bunch! That really helped.

Thanks a bunch! That really helped.
Forum: Excel VBA February 22nd, 2006, 06:46 AM
Replies: 2
Views: 1,067
Posted By Wall st Guru
Autoupdate multiple information

I have an excel sheet which contains details of several ships such as fuel consumption, speed, tons, no. of cranes etc. based on which I have to perform certain calculations. The above details are...
Forum: Excel VBA June 22nd, 2004, 03:15 PM
Replies: 2
Views: 1,636
Posted By Wall st Guru
Graph and Comments

Hi,

I have a graph with the ROE and stock price on a graph. I am trying to make the labels pop-up when someone moves the cursor over a point, just like adding comments to a cell. I would...
Forum: Excel VBA June 16th, 2004, 05:45 PM
Replies: 1
Views: 2,140
Posted By Wall st Guru
Excel and Bloomberg

Is there any way we can tell when Excel has completed downloading links to Quarterly data into excel from Bloomberg?

I would appreciate any advice.

Thanks
Forum: Excel VBA June 10th, 2004, 10:38 AM
Replies: 2
Views: 8,937
Posted By Wall st Guru
Update links in excel file

Hi,

I have an excel file which contains a financial model which I would like to use for all the stocks on the S&P 500. So, I have a masterlist of all the stocks on the S&P 500. I am trying to...
Showing results 1 to 13 of 13

 


All times are GMT -4. The time now is 08:21 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.