Programming

Selecting items from list and attaching ratios to selection
I am struggling with the following. I would like to set up a sheet whereby I send the following to a user which would be in cells A1 and B1. Fund A $1m The user would then return the spreadsheet with the following Fund A $1m GBP,EUR,USD 0.5,0.4,0.1 having updated cells 3 curren... 3 Mar 2010 06:16

Convert Case
My original post seems to have disappeared so here is a repeat. I have to clean up a spreadsheet by converting the text in cells A6:B11999 to uppercase text. These cells contain text only. Is there a quick way to accomplish this? ... 3 Mar 2010 15:18

Convert Cells to uppercase
I have to clean up a spreadsheet by converting the text in cells A6:B11999 to uppercase text. These cells contain text only. Is there a quick way to accomplish this? ... 3 Mar 2010 05:10

Passing a string to a function instead of a cell reference
Currently using excel2003 with the following UDF Function EmpName(nam3 As String) Select Case nam3 Case "John" EmpName = "First" Case "Doe" EmpName = "Last" End Select End Function This works if I use a cell reference i.e. A1=John, =EmpName(A1) but fails if ... 2 Mar 2010 23:44

SQL query in excel (VB) using multiple parameters
I would like to have an sql query (which I've written) that looks at multiple rows of parameters in excel and returns data - if anyone can point to some guidance I'd be very grateful. One the "Parameter Sheet" I will have parameters going across and then down (e.g., one line for each client belonging to a certai... 2 Mar 2010 16:58

VBA code for Excel File Save As
Ron your code works great. Is there a way to incorporate into the code that allows me to pick up a textbox with the data entered in there to be part of the file name upon saving the workbook? "Ron de Bruin" wrote: You can use GetSaveAsFilename Sub Test() Dim fname As Variant Dim Wb A... 2 Mar 2010 16:58

To use parameter with like.
CAST(? AS VARCHAR) + '%' ? represents variable. It does not work for empty variable. Still working on that one. Rames wrote: Sorry, I should have tried and asked the question here. It works same way! 12-Feb-08 Sorry, I should have tried and asked the question here. It works same way! selectCommand = "... 2 Mar 2010 15:50

Update pivot table report filter using cell value
Please point a VBA beginner in the right direction: I want the code below to update the pivot table based on the cell value in "C5" of a worksheet named "Dates". Can this be done by amending the last line of recorded code below? Windows("VDN Daily.xlsm").Activate ActiveSheet.PivotTables("PivotTable1").Piv... 2 Mar 2010 12:24

Printing App
I have a spreadsheet that requires a constantly changing variable each time it is printed. I have a cell with a batch number. For each copy I want printed, this batch number should increase by one. I am able to do this for single copy print jobs, but I can't figure out how to increase the number for each copy f... 2 Mar 2010 10:08

xltm saveas xlsm
I have the following code within an "xltm" file which I want to then save as "xlsm": Do fName = Application.GetSaveAsFilename(InitialFileName:="kupa", filefilter:= _ " Excel Macro Enabled Workbook (*.xlsm), *.xlsm,") Loop Until fName <> False ActiveWorkbook.SaveAs Filename:=fName ... 3 Mar 2010 07:21