Search results for query: *

I am having some issues with Visual Basic 6.0 and Visual Basic NET. A recent Microsoft Windows update (Microsoft.NET Framework 2.0: x86 (KB829019)) which became available in late January was installed a few of our computers. This update seems to have caused a conflict in some system DLL's...

One that I launch.

I'm trying to send key strokes to a DOS based program using VB6 but the SendKey syntax won't work. Does anyone know a way around this? Thanks.

Thanks johnwm I'll try to do that.

If number corresponding to #,--,- is only one digit, then a zero should be added before it. If the number corresponding to --,#,- is one digit, a space should be added before it. That's just the way it needs formatted. Thanks. Brad

Hello, I have a ton data in a comma delimited txt file like shown below "Orig Format" I'm trying to convert it to a list of 6 digit numbers with spaces for missing numbers. At the end of each set, I need to place ascending numbers in place of ,, which need the format _ _ _ . Any help would...

Hi, Here is the basic idea. I have a column of boolean excel data that returns 'Y' or 'N'. (i.e. =IF(G2>=10,"Y","N")) I would like to create a new column that counts the cells where the value that is returned is equal to 'Y'. The range however is not the entire column...

Rob, Thanks for the help with my threads. It's nice to know there are still people that will take time out of their day to help others. Good luck in your future. Brent

Hi, I understand that Pocket Excel does not support data validation. Does anyone know an alternative method to create drop down lists that would be supported by Pocket Excel. Thanks, Brent

Hi, I understand that Pocket Excel does not support data validation. Does anyone know an alternative method to create drop down lists that would be supported by Pocket Excel. Thanks, Brent

Thanks for the help. This works somewhat but I think the problem lies within the line: if target.column=1 and target="" then '(an empty cell in column A) because the target.column=1 needs to refer to a merged column which is actually both column A and B. How do I refer to both...

This was my original post: Here is the basic idea.... A 7 N 8 9 10 11 12 The possible values to be entered are N,S,E,W. I want to create a formula that when A8 is highlighted it enters the appropriate value(N,S,E,W) into A8. In this case N. When A9 is highlighted it would automatically...

In response to your reply on my thread.... http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/32/pid/707/qid/518169 How do you enter this worksheet event code? Thanks, Brent

Here is the basic idea.... A 7 N 8 9 10 11 12 The possible values to be entered are N,S,E,W. I want to create a formula that when A8 is highlighted it enters the appropriate value(N,S,E,W) into A8. In this case N. When A9 is highlighted it would automatically enter N. If the user were to...

Zathras, Thank you for taking the time to view my post. I forgot that the data would not fit into one worksheet. If needed, I can use two worksheets to solve the problem. The second worksheet would just append the data that won't fit in the first sheet. Brent

I'm working with a large workbook containing 24 sheets. I created a new worksheet with the following columns: A B C D E F G H I J K L M N Dir ID Spec 1.5m 0.3 .05m 5m 3m Tall BT I need to extract data from the current worksheets("Sheet1&quot...