Search results for query: *

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

I tried that, it gave me an error. Any idea why this wont work? When I added the bold it gave me an error: SELECT [Sales Record Number],1 as 'Line ID',[Item Title] as 'Product ID',[Item Title] as 'Product Code', Quantity,[Sale Price] FROM `C:\Documents and Settings\RBC\Desktop\Final...

Ok, Ill have to try that. I just gotta make a few changes to the code (IE add the product code column) and than remove the '' around the Line...I guess that has to be done after the query because it is needed in the query it seems. Thank you so much for your help. I'll repost if i need more help.

EXCELLENT! One final question...can this be executed through the macro?

Let me just clarify, this is the SQL statement: SELECT [Sales Record Number],1 as 'Line',[Item Title], Quantity,[Sale Price] FROM `C:\Documents and Settings\RBC\Desktop\Final Macro Completed`.`ebay$` UNION ALL SELECT [Sales Record Number],2, 'Shipping And Handling',null...

Ok, I cleared data in all empty cells below the 1012 sales record and it still shows the same amount of empty cells as stated above. i did the auto filter, but there are no blanks in the sales record column