Search results for query: *

Hi all im trying to find the first friday in specified year / month . The code below adds 6 days on but i think im interperating the DateInterval.day wrong. [code] Date_CurrentFriday1 = Format(DateAdd(DateInterval.Day, FirstDayOfWeek.Friday, DateSerial(RDyear, RDmonth, 1)), ShortFormat) [\code]

Very You need a loop to go through your list and where the returned color is red then make the next row / column = 1 isred = 123 ' What ever color red is if IsRed = Cells(x, y).Interior.Color then 'make next cell equal 1 Cells(x, y +1).value = 1 end if

Make an array with your pics file paths and then nest this in a do until button pressed loop

ill give it a go , many thanks

Hi all I know its friday and I have a question on searching I have inherited a large DB , and want to find any tables that have the value '161941' in any of the cells , is this possible to do (relitively) simply Many thanks C

Hi Maybe something like ActiveWorkbook.SaveAs Filename:="C:\Book1.xls", FileFormat:=xlExcel9795 Look at the xlFileformat in the help, for more options Hopes this helps Chris

use tempdb IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[#temp]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1) DROP TABLE [#temp] go use agresso select a.project, a.department, count(a.department) as countofdep into dbo.#temp from atsproject as a join acrclient as b on...

apologies , there are many many different combonations of data current proj dep Count of dep 5210730 730 26 5210800 800 5 5211442 440 26 5211442 442 29 5211442 442 26 * this one wanted return 5210730 730 26...

Hi all , relitivly new to SQL and i have made this so far .... select a.project , a.department , count(a.department) from atsproject as a join acrclient as b on b.municipal = 'Y' and b.client = a.client where a.project = 'ECP12674' group by a.project , a.department order...

look into using the macro recorder , this can give you the copy and paste , code - coloring etc. secondly look at making 2 while loops, to loop firstly through your data headers , then loop through the data to match header e.g. (code typed not checked but along these lines) [/code] 'loops...

Hi all , This is the first time i have ever tried to add into a menu option in a microsoft application. I want to add an option in outlook 2003 , when you right click on a resolved name, in a email. Two things i would like to know how to do 1) I want to be able to return their first and...

attually the round function is more applicable , (sorry it is early in the morning , not woken up yet)

if you format "a" and "b" (look at the format function) then compare this issue should disappear , the number shown is very small

After searching the answer is as follows , download the pvkimporter from MS and then run in the command line pvkimprt -import LC2006A.spc mykey-2006.pvk Thanks for any views. C

Hi all I have never really come across Digital Signatures before , but I have recently modified a modules in excel and need to re-add a digital signature to it , I have been given two files LC2006.spc mykey-2006.pvk and a pass phrase for one / both ?! I am assuming that I need to add a...

Hi all I have a workbook and a custom menu with two buttons on it , Works great , but when i open on a different machine the bar is there but no buttons . How do i get the buttons to say ? Many thanks in advance. Chris

ahh yes on letter out of place this works fine now , cheers guys ! Mucho Thanks

No change if i take it out , the file path is stored with out the "\", so this is needed to make the file path continue and seperate the file from the path.

Joe At work This looks good but i get issues I am calling like this newupload = ShowShortName(uPfUpload & "\" & nsfil) uPFupload : contains the folder name nsFil : contains the file name I have ensured that the scripting dll is installed. the errors comes on Set f =...

Hi All I have a function that ftps a file from a to b , the issue im getting is when the file path is larger / has spaces I think as an example "C:\Program Files\File Program\Upload" - Errors because of spaces I think "C:\Upload" Works fine. My Question is how can get the Longer string...