Programming

Summary Help Needed
Here are the fields in my spread sheet. Date Name Request Received Start Time Finish Time Total Time Here's an example of what I'm trying to accomplish. Let's say I need to see how much time John has spent doing research mail. I turn on the auto filter feature so that I can select only information per... 15 Apr 2010 12:32

Open and close workbooks
I want to set up a macro that will activate a workbook, copy the info in specified fields and paste it to the master workbook, then close the original workbook. I can't figure out how to do this, because I won't know the name of the workbook that will be activated. I set up a macro that adds a new workbook and ... 15 Apr 2010 11:24

How do you convert a string to a double?
How do you convert a string to a double? This does not work: string1 = Right(Left(data(k), 21), 2) double1 = CDbl(string1) It gives a "Type mismatch" error every time. ... 15 Apr 2010 12:32

Literal string in filter, not a date
I have text cells with dates in them in ISO format, embedded in the text of the cell. I want to filter on cells that contain a certain date, e.g. 2010-03-15 but when I put that into the AutoFilter it gets automatically converted to 15/03/2010 which does not appear in the cell. How can I tell the filter that I am lo... 15 Apr 2010 12:32

How do I test whether a string is a valid cell reference?
I would like to develop a way of testing whether a string entered by a user can be used by excel to define a range of cells within a sheet. For example: "A1:C6" or "A:Z" would be OK but "iljfneklj" would not. I'd like to have ways of doing this both in VBA and also using an excel formula. Are there any ideas... 16 Apr 2010 05:06

refresh listbox
Hi All, I have excel userform, which is connected to access database. I have customer details in access dabase. I will search using excel userform, results are displayed in listbox. I will select the listbox item and update the required details. If I click save it saves to database. That is working fine. ... 15 Apr 2010 05:54

Help needed editing a script
hi there I using using this script to hide rows which working fine. I would like add to it to hide Entire row PLUS every row below it upto 1197. how can I achieve that?? Thanks in advance Sub HURows() BeginRow = 2 EndRow = 1197 ChkCol = 1 For RowCnt = BeginRow To EndRow If Cells(... 16 Apr 2010 12:52

Userform Layout
Would like to copy some features of the built in userforms (Excel 2003) In particular, on Tools/Options/View Tab: How to achieve the 'frame like' layout with, for example, the folowing graphic: 'Show -------------------------------------------------- ' (text & etched line) at the top of page. I normally use a ... 15 Apr 2010 12:32

Where is the problem on Next without For?
The following coding works fine, but once I change following code "If CStr(d.Value) = ws.Name Then DelFlag = False" into "If CStr(d.Value) = ws.Name Then " "DelFlag = False" I would like to do it, so during the debugging process, I can see whether this line is proceeded or not. It pops up a message about Next... 15 Apr 2010 04:50

Code to adjust column width
Hi, Can anyone help with code to do the following: Row E8:AI8 - each cell contains a value 0 to 100, generally a value of 1 to 20. The total of the row is maximum 100. I would like to adjust the width of the column based on the values for each column. The minimum width would need to be 6 so text is still re... 21 Apr 2010 02:14