Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tenbellies

    Vlookup problem

    Great works a charm...
  2. tenbellies

    Vlookup problem

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

    Vlookup problem

    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...
  4. tenbellies

    Vlookup problem

    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...
  5. tenbellies

    Adding Time

    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
  6. tenbellies

    Adding Time

    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?
  7. tenbellies

    Adding Time

    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...
  8. tenbellies

    E-mail spreadsheet

    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?
  9. tenbellies

    Convert a screen scrap date to actual date

    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....
  10. tenbellies

    Stop a program after a certain date

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

    Stop a program after a certain date

    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.....
  12. tenbellies

    Count e-mails

    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.
  13. tenbellies

    Count e-mails

    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.
  14. tenbellies

    Re-nameing a csv file

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

    Re-nameing a csv file

    GREAT THANKS WORKED A CHARM!
  16. tenbellies

    Re-nameing a csv file

    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
  17. tenbellies

    Re-nameing a csv file

    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

Part and Inventory Search

Back
Top