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!

  • Congratulations Wanet Telecoms Ltd 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: *

  • Users: tenbellies
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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?
  4. 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....
  5. 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.....
  6. 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.
  7. 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