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 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....
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 "Date Error"
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.....
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.