Search results for query: *

Actually, before I even went back to check on any replies I answered my question. Here's the formula I used: =LEFT(B3&REPT(" ",28),27) So, the formula pads the cell with (28) spaces following my text and only display (27) characters. Thanks though to those that replied with your formulas.

My question relates to a solution posted by mbarron in a previous forum topic: "Add a leading zero to CSV file" =======FORUM POST IN QUESTION============= mbarron (TechnicalUser) Nov 22, 2004 Assuming you want you want your number to be 6 characters long: =RIGHT(REPT("0",6)&A1,6) Change the...

Jim, THANKS! That worked great! Just one more thing...now that I have word automating the mail merge, how do I create an executable that physically opens word, runs the marco, and closes out word?

To Whom It May Concern: Is there a way I can automate MS Word's Mail Merge function? I have a list of people in MS Excel and have been using Mail Merge to generate an XML file that lists those people. The Mail Merge works great but I just wanted to see if there was some way I can automate...

all, ok, i downloaded the SP1 for XP on another computer but have NOT INSTALLED it on the failed ip address computer yet. will get to that probably tomorrow. in the mean time, here's some info to clear up some misunderstanding of the problem... - my cable is GOOD. checked with another...

bcastner, NO, Service Pack #1 is NOT installed on my XP machine. I will do so and re-check the connection. Brian C., Thanks for your input, I will check out the Ethereal software if I am still having difficulties. I appreciate everyone's input, thanks! kanin

bcastner, First, you did disable XP's native firewall, right? YES, THEY ARE DISABLED 1. Upgrade the NIC drivers if they are available. BRAND NEW NIC, USED INCLUDED DRIVERS ON CD. WILL LOOK ONLINE TO CHECK IF NEWER VERSION 2. McAfee firewall can do this. Try it disabled. NO FIREWALL...

bcastner, to answer your questions... 1. Can you ping the router? NO 2. Can you ping any of the other two machines? NO 3a. Does anything seem to be off in the report (other than the 169.xx.xx.xx IP)? Below are my results... INTERNET SERVICE Default Outlook Express Mail - Not Configured...

To Whom It May Concern: BACKGROUND I am setting up my network at home with the following: - Efficient Networks 4-Port DSL Router (2614) - Desktop1 Running Win2K - Desktop2 Running WinXP - Laptop1 Running Win2K CONNECTION SETUP - DSL Modem to Router - Router to Desktop1, Desktop2, Laptop1...

ok, i'm not getting anywhere. so, i'm gonna solve this problem the easy way - fork out $10 and purchase a new NIC card. thanks to everyone who provided some assistance! kanin

well, the i know the cable is good b/c i checked it with my other PCs and it worked fine. but the NIC does light one led (10LNK), so doesn't that mean that it's not entirely dead? kanin

they help me reset the password to default 'admin' (could have been a possibility that the password might have been changed by me) efficient networks tech solution: - basic check of settings, ensure that... - obtain an IP address automatically is selected - obtain DNS server address...

update... installed new drivers - still no connection. ran winsockfix - still no connection. however, i did notice that only 1 of 3 leds on the NIC card (3Com EtherLink XL 3C905B-TX) were on (ooo = 10LNK 100LNK ACT). so, the leds are telling me there's no connection to the network, which i...

manarth, ok, i'll check the drivers and see if its the most recent. and also look at that winsockfix file. i'll keep the post updated, stay tuned... on a side note, PC1 & LAPTOP1 are running Win2K (the ones that connect fine) and PC2 is running WinXP (the one that is NOT connecting fine). i...

problem solved, called efficient networks tech. but thanks for everyone's help! kanin

To Whom It May Concern: I am trying to get my computers (PC1, PC2, LAPTOP1) onto my network and I was successful on TWO of THREE. I have an Efficient Networks 4-Port DSL/Cable Router (2614) where each computer on the network should get a 192.168.254.xxx IP address. PC1 and LAPTOP1 get a valid...

edemiere, sorry for the no-response just yet. but your suggestion, in fact, was helpful. however, it did not recognize any microsoft office install files. so, i guess the uninstall process already eliminated whatever the WICS utility looks for. anyway, i decided to just wipe the whole...

To Whom It May Concern: I was trying to uninstall Office when half way through the uninstall process I had to cancel it due to the amount of time it was taking (working on an old pc)...the owner needed it back. However, now that I have the pc back, under the Add/Remove Programs the option to...

matt wray, yeah, i get the login screen (only asks for password, no box for username) but i just can't get in. and yup, i tried your suggestion but still no entry. not quite sure what's going on... anyway, still waiting on efficient networks support guys to get back to me. hopefully it...

bcastner, i tried enabling username and password for prompting but still no luck. i sent an e-mail over to the efficient networks support people regarding my problem so i'm waiting on a response. but if anyone else has any suggestions, i'm open to them. thanks! and thanks to those who have...