Recent content by Barneye

Awesome! Thanks!

Works Great! Only problem is how to I format the cells? After using the formula, I cannot format the Dollar columns as currency and the % column as percent.

I have an Excel workbook with 6 columns. I need to combine them into one cell but maintain a specific number of characters per column. Example: Name Orders Dollars MTD Ord MTD Doll % of goal Name 1 $1,000 10 $1,000,000 15% Name would need to be 8 characters no matter the...

Great Thanks!

Hello! I have a macro in Excel that I wrote. I need it pause to 10 seconds before it executes the next set of code. I am using Application.Wait Now + TimeValue("00:00:10") This works but seems to freeze the entire application. I have ODBC updates running in the background that need to run...

I wrote a VB Macro to feed data from an Excel sheet to an ActiveX Control that runs an LED sign. This Macro is on a loop. I made a button to start it, can I make one to stop it?

I tried that and it eliminates any duplicates in each column. I need to eliminate duplicates only if the Part, Mfg, and Available all match. The following SQL Query works but I need to display all the columns. SELECT DISTINCT Inventory.Part, Inventory.Available, Inventory.Mfg FROM Inventory;

I get several lists with inventory from my suppliers. I import the excel files into an access database. Multiple suppliers list the same inventory from the same manufacturer. I need a query to eliminate the duplicates. I have 5 columns: Part, MFG, Available, Vendor, Cost, Datecode, Package...

Jim, Right on target! If you have time, a short explination of the code would be helpfull so I understand it for the future. Thanks!

Hello! I have a gridview with phone call statitics for my sales dept. The 6th column is "TotalCalls". I need to change the font color to red if the number of total calls is less than 40 or to green if it is 40 or higher. I am new to ASP.net, so the simplest explanation will be appreciated...

Just a note.... I have actually used DTS to import from Excel to Excel. I needed to automatically combine 2 spreadsheets on a daily basis. It worked great!

Sorry if I confused anyone, sometimes I do that! I have an Excel spresdsheet being imported into SQL using DTS. One column has part numbers. These part numbers are alpha numeric, but some are numeric only 6- 10 digits. During the import the numeric only part numbers are not imported and left as...

Well having SQL output the Excel file as a csv file did not work. This is very frustrating. I guess I will have to convert the file to CSV by hand from excel and try again. If anybody has a better idea, please speak up!

I have it set for nvarchar(255). I found some info that this is designed behavior for SQL. Microsoft suggests saving the file as a text file and then do the import. I guess I will add a step to the DTS to do the conversion to text and then do the import.

I have tried many different "Data Types" with no luck. This is crazy! I hate Microsoft sometime! Ugh!