Search results for query: *

I have the following code to list all worksheet names and their corresponding tab colors, it seems to work fine EXCEPT where the tab has no color in which case it shows as black. cna anyone suggest what i am doing wrong? Many Thanks Sub ListWorkSheetNamesAndTabColors() Set wks =...

i have a query that returns records with a callTime in the last 24 hours. what i am trying to do is determine which of these records has a calltime within the current shift (shift start times are 06:00 and 18:00) so... if the current time is 11:10 all those records with a calltime greater than...

Hi All i have a range of cells in Excel currently C16:F16, i use the following formula to return the value in the last populated cell from that range =LOOKUP(2,1/($C16:$F16<>""),$C16:$F16) this works great, however the range is going to be expanding i.e. each week a new column will be inserted...

hi i have recently got a new Vista machine and am trying to use the backup utility with a Maxtor external USB drive however when i select "backup files" in the backup and restore center it gets as far as "Looking for backup devices" and stays there forever. if i unplug the USB drive and try...

i have the following that changes the x axis scale based on a value on a worksheet, it works fine until i change With ActiveChart.Axes(xlCategory) .MinimumScale = minScaleValue .MaximumScale = maxScalevalue End With toWith oSPCCht.Axes(xlCategory)...

i have a table with the following fields (among others) id priority name i need to count the number of records for each name grouped by priority, my problem is that where there are several records with the same id number for a particular name/priority i only want the result to return 1. for...

i have an excel sheet with 4 named ranges, "pa", "pb", "pc", "pd". I need to sort these by the 11th then 6th column in each range. Can someone point me in the right direction? Cheers, Craig Si fractum non sit, noli id reficere

I have the following function thats takes a cell value in the format 0700-1900 and calculates the number of hours elapsed. It works fine but I would like to be able to use a range of cells as the parameter and work through the cells to get the total hours. Can someone point me in the right...

Hi all Don't know if this is possible but here goes... i have a view that returns data like: DATE AREA No1 No2 FINAL 01/04/06 firstArea 20 28 .71 02/04/06 firstArea 15 22 .68 . . . 01/04/06 secondArea 14...

i want to achieve 2 things: firstly to copy 2 sheets out of a workbook and into a new book but only the values and formats. and secondly copy one of the sheets into an existing workbook again only values and formats. i have got the first part working but am struggling with the second. the code i...

well, now i'm really confused (doesn't take much LOL). i have created the following to clear the contents of any unlocked cells on a number of worksheets. Function clearUserInput() 'Clears any data that has been input by the user 'Application.ScreenUpdating = False Dim shName Dim c Dim wb As...

i need to return the row numbers of any row where the first cell (column A) contains a certain text string. i know how to look for the row number of the first instance of the text, but how do i continue looking down the column for more instances? Option Explicit Function findRows() 'declare...

i have inherited an Excel spreadsheet that has some VBA to do some formatting of the sheets. this runs on opening the workbook, funny thing is though there is nothing in the workbook_open event. i just can't see what is triggering this to run. is there somewhere else this could be being called...

i have a table with several fields example of the data is: f1 f2 f3 f4 0004 01/04/2006 106.3 rp1 0004 01/04/2006 52.1 dp2 0010 01/04/2006 36.2 sp1 0010 01/04/2006 114.3 fr01 i need to...

i am trying to create a dts package that uses a sp to get data and export to a text file. the dts has a sql table as source and .txt file as destination the transform is declare @date1 datetime declare @date2 datetime set dateformat dmy SET @DATE1 =...

i'm tearing my hair out with this one... i need to return all rows where col1 matches the following pattern: 4 numbers followed by hyphen followed by 4 numbers. e.g. '0000-1200' or '0800-1600' i know this should be fairly straight forward using patindex but i can't get it. Cheers, Craig Si...

i ahve the follwoing activeX script for copying a text file using global variables for the path and file names. '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************...

i have a task that creates and populates a text file, the text file. i then use an activeX taask to copy and rename the file from using a global variable and yesterdays date as the file name. i now want to email the file as an attachment, but because the file name is different each day, i'm not...

i have the following code to fire a SQL sp and bring the data into excel. This was working fine yesterday, but now i am getting a "timeout" error, i know there is a timeout setting that i can set to 0 but not sure of the syntax or where to put it. can anyone point me in the right direction? Sub...

i have a query that returns several rows of data, i need to export this out to a text file. i have done this several times before but always to an existing text file. is there anyway i can create a new text file from within DTS using one of the values from the returned data as the filename...