Recent content by jgarite

thats another good one...thanks, that may be useful too. thanks george and lee

wow LoL...thanks...guess i need to go back to kindergarten & learn how to count. thanks george

can someone verify this code for me? it doesnt seem to be working... <% if Mid(sKitName,4,3) = "EEE" then%><%else%> <% if left(sKitName,4) = "Asus" then%>Free Shipping <%End if%> <%End if%> The item titles are Asus A7K (just for example) and Asus EEE...if the model is a Asus EEE, it should...

Excellent! Thanks, I'll try that out right now. Do you knwo if thats server time or the users computer time? I'm assuming server time...

I am trying to figure out how to display content until a certain date is reached...is this even possible? If so, how? Not familiar at all with the date functions in php. What I have is some rebates I would like displayed on my website that expire March 31, 2008. I would like them to disappear...

1. ebay 2. i dont have the sheet in front of me (im at home), but I think it is M2 3. it will vary. so far hasnt been more than 10.

higgins, how would i use this in a macro? the country-codes.xls would be looking in Final Macro Completed.xls (this is where the macro resides) for the data that needs replacing. And how would i loop it to continue through row 2,3,4,etc...there usally arent more than 10 rows so it is a small...

Ok, well to start, I can move the columns around, I don't think it matters which column is the abbreviation and which column is the full name. Here is what I am trying to do: I have a file that contains country names that need to be converted to the abbreviations. I will be running this on a...

Hello again, I have an Excel spreadsheet containing country codes that I would assume needs to be turned into a database in order to be queried. The query would be something like this: Search for United States (finds it in column B) and replace it with its Country Abbreviation: US (Finds this in...

Now I'm confused...this is what I did to create the query, maybe I did it wrong: Data > Import External Data > New Database Query (On the Databases Tab) Excel Files > OK I opened the Final Macro Completed.xls file --It than told me there were no visible tables, I hit OK and it asked me if I want...

That is the name in the textbox :-{

getting the error Subscript out of range ...

Sheets("ebay").ebay_to_yahoo_items(1).refresh false

Wishing you a quick recovery. [thumbsup]

Hey, that last code worked perfect with minor changes to the titles. Thanks so much. I tried using the code you provided to have the macro run the query, bt it didnt work (I replaced the sheet name and the query...my query name is ebay_to_yahoo_tems and the worksheet i renamed to was the ebay...