Programming

How to evaluate VB constant name in string variable?
Greetings! Example: the value of vbOkay within the VBE is 6. {i = vbOkay} yields i = 6. Would like a construct where {sMyString = "vbOkay" : i = UnknownFunction(sMyString)} yields i = 6 TIA! George ... 13 Feb 2010 17:12

using lookup function in vba
I am trying to use the lookup function in my vba code. I'm using excel 2003. Here is what I have so far, but it isn't working. I'm getting the error "unable to get the lookup property of the worksheet function class" Dim name As String name = Range("e800") Dim Start As Integer Start = Application.Workshe... 10 Feb 2010 23:35

Automate Copy and Paste?
I am using Microsoft Office Excel 2003 at work and Microsoft Office Excel 2007 at home. Using either one of these programs I need to transfer more (a lot more) than 1000 short lines of text from the cells into text boxes. Each line of text is in cells A1 through A1000. All the text boxes are adjacent to the... 16 Feb 2010 02:58

Can a hyperlink run a macro?
Thank you. That did the trick. Is it possible to stop the hyperlink from running? "Tod" wrote: I found a good post that answers your question. Copy and paste this into your browser's Address box: http://groups.google.com/groups?q=excel+% 22hyperlink+to+run+a+macro%22&hl=en&lr=&ie=UTF-8&selm=% ... 10 Feb 2010 15:42

Make a sheet for one year?
Is there some kind of coding that can be put onto a sheet or workbook that will ignore data from a prior year? Here's the specific dilemma. I downloaded a General Ledger from the Microsoft website through exel, new, microsoft office online, ledger, generalledger1. I work on a fiscal budget so, naturally, I... 10 Feb 2010 15:42

Possible to nest
I am wanting to run 2 commands when I click a particular button. One command saves the spreadsheet, the other sends spreadsheet via email. They both work individually, but when I try to combine, I receive errors. ... 10 Feb 2010 19:07

Excel opening blank or Gray worksheet
I have 50 spreadsheets, one for each doctor, that was created with what looks like some macros in them. When a nurse opens the spreadsheet, the workbook is gray looking as if there is no data. However if they click Window - Arrange and OK, then it tiles the worksheet and it's fine. While this is an easy work ar... 10 Feb 2010 14:34

Merging several workbooks from folder to 1 workbook in different s
Hi All, looking for a macro wherein I can extract details from 10 different workbooks located in particular folder into a new workbook , details of each should be on new sheets. eg. there should be 10 sheets having all the details of 10 workbook located in a particular folder. Appreciated your help Rega... 10 Feb 2010 13:26

VBA - Opening afile, copying the contents
Probably simple for VBA people - I need an excel file with code that opens a CSV file off our company network, then copys the contents of sheet one off that CSV file into sheet 2 of the excel file that is holding this code. Any help? -- Message posted via http://www.officekb.com ... 10 Feb 2010 12:17

Range updates
is it possible to create a formula so it adjust automically to number of row or columns in a range, for example if there were values in the range C1 to C5 my countif formula would automatically adjust to countif(c1:c5) and if there values in cells c1 to c1000 the formula would adjust to (c1:c1000) Thanks ... 10 Feb 2010 12:17