Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003
This is the forum to discuss the Wrox book Professional VB.NET 2003 by Bill Evjen, Billy Hollis, Rockford Lhotka, Tim McCarthy, Jonathan Pinnock, Rama Ramachandran, Bill Sheldon; ISBN: 9780764559921
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 7th, 2003, 09:38 PM
Registered User
 
Join Date: Oct 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need help with Excell and VB Macro

I know this is not really Visual Basic.Net stuff but I would like help with one of my Excell spreadsheet ... it does have a visual basic macro in it

The excell spreadsheet was passed onto me by my boss and the person who has written it has departed ...

I am trying very hard to try to make scense of the formulas but I am not successful at it ...

Can someone please help me try to make some scense of this spreadsheet ...

It is not that complecated ...

It does have one visual basic macro that uses the goalseek function ...

I am also trying to find out how the write get the value for the Cell C23 ... for the "Gross" value ...

Can someone please help me out here ???

I will email the excell spread sheet to you ...

My email addresses are

I will greatly appreciate it if someone can help me convert this spreadsheet into Visual Basic.Net !!!

kheemeng@lycos.com
and
Andy_Yeo@lycos.co.uk



  #2 (permalink)  
Old February 10th, 2004, 03:29 PM
Registered User
 
Join Date: Feb 2004
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok, the type of VB that is used in Office is VBA (Visual Basic for Applications). Similar in that it uses the BASIC structure of code (top to bottom read, until VB came out), but different in that it has a lot of different stuff you can do that pertains directly to the Office suite.

My advice to you:

There is a forum here for Excel VBA, however it looks all but dead (quiet). It can be located here:
http://p2p.wrox.com/forum.asp?FORUM_ID=30

Another option is http://www.tek-tips.com on their VBA forum (they have a very active VBA forum) for the information you are looking for. This seems to be your best bet, but I would try the local forum first just incase. Make sure to post the code that you are looking at ;)

As for the value of a cell, I believe it's Cell(#).Value . I'd have to look at the few VBA macros I've created to be sure.

  #3 (permalink)  
Old February 10th, 2004, 03:31 PM
Registered User
 
Join Date: Feb 2004
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Forgot one link, it's to the actual Excel VBA (not a specific book) forum here:
http://p2p.wrox.com/forum.asp?FORUM_ID=72



Similar Threads
Thread Thread Starter Forum Replies Last Post
Web access from VB Macro in Excel beta_leonis VB How-To 0 August 3rd, 2007 11:30 AM
VB Macro Excel mateenmohd Excel VBA 6 January 4th, 2006 05:27 AM
vb macro for excell shachar BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 0 November 30th, 2005 07:14 AM
vb macro output file to excel mateenmohd VBScript 0 March 21st, 2005 12:34 AM
AppActivate in a VB macro - Excel 2002 andycub Excel VBA 0 April 7th, 2004 10:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.