Search results for query: *

Great works a charm...

Thanks for the help i'm getting #ref! any further help greatly appriciated

OK Thanks… Data in sheet 1: Code1 Name Value 123 Bermondsey 1 456 Bishopsgate 2 789 Canonbury 3 Data In Sheet 2 Code 2 123 456 789 What I need to do is find the match’s in Code 1 and Code 2 But put the “Value” in sheet 1 in the column next to Code 2 in sheet 2. Not all the...

Hi, Not sure if this explains it very well but... I need to use a vlookup formula in a workbook so that CODE1 (in a diffrent sheet, same workbook) and code 2 are the same it enters the number in the value column in another cell. Not all the code1's are in both worksheets Code 1 Name...

i don't have a date only time. I have it sorted now using the folowing... Dim MyString, LeftString MyString = Text1 LeftString = Left(MyString, 2) Dim MyVar MyVar = Mid(Text1, 3, 6) timedel = Text5 Label8 = LeftString + timedel & MyVar i know it's not the best way but it works

Thanks for the tip but still haveing troubel... the time is in the format hh:mm so if the user inputs a time of 05:00 i need ot to add on 2hrs. i can't get the adddate to work i have it as follows: DateAdd("h", 2) can you help further?

I have a timer to extract some data but once that has finished i need to extract some more data 2hrs after that one has finished. Rather than setting another timer with data input i want to be able to add 2 hrs onto the existing time that the user has said to run the first script. I have tried...

aaarghhhh can any one help, I have to write a macro in excel that when the spreadsheet opens it automatically runs a macro rereshs itself and e-mails itself out. The refresh i have sorted but can i get it to run the macro on open and then e-mail out to a distribution list?

I ned to converta date extracted from a screen scrape to an actual date so if the date is less than today it does one section of code if not it does the other. My problem is i have the date but how do i tell my script its a date not text? Thanks in advance....

Thanks, both of you, the code works i have thought about the date but can't think of a better way

I need to put some added security on a program i'm trying to add some code like this sub form_load if Date <= 01/01/2004 then msgbox &quot;Date Error&quot; unload me Exit sub end if End sub This won't work have tried other ways of coding but can't get it to work any one help.....

Thanks for the tip but i need it to do a count as they arrive, as when each e-mail is delt with it gets deleted.

Is there a way of counting how many e-mails comes into an inbox. We use Outlook 2000, it is a shared mailbox which anyone can access.

I have a slight problem this works but will not over right any previous files that are exists... didn't look closely enough before

GREAT THANKS WORKED A CHARM!

Thanks for the tip but am getting a error this is what i have written in: Name = &quot;D:\TrawlFiles\CAMSS\frp.txt&quot; as &quot;D:\TrawlFiles\CAMSS\frp1.txt&quot; i get the error expected end of statement on the &quot;as&quot; part

I have wrote a screen scrap that puts all info into a text file, this infomation is overwritten every time it runs but i have been asked to keep the previous data for comparison. What i want to do is re-name the .csv file before the new one is ran eg data.csv would become data1.csv