Search results for query: *

Forgive me, I dont know vbs, I searched and searched for what I have so far and feel like I am very close to a solution on this. All files are in the same folder, currently on my laptop. The task at hand is... 1.Take 3 xls files and convert them to txt 2.Combine the txt files into a single...

thread68-907911 Back in 2004 I asked this question and KenWright gave me a formula that has saved me countless hours of frustration...so let me starrt by saying thanks again Ken! Now today, I am realizing that this formula does have a shortfall. Here is my original question from 2004 I have...

I have this formula working as is but it needs 1 more "IF" added to it...Ive never created a formula this lengthy but I thought I could do 7 "IF's" without a problem. here is the formula... =IF(VLOOKUP(H2,A:E,5,TRUE)="M",IF(VLOOKUP(H2,A:G,7,TRUE)="A",(VLOOKUP(H2,A:F,6,TRUE)/100)*O2)...

I have several remote sites that are connected to our database via Frame Relay...they also have local Internet access. I used the solution found in this article to connect the PC's to both networks. http://www.tek-tips.com/viewthread.cfm?qid=1006195 Now I have a SOnicwall at 3 of these...

I created a shortcut to Microsoft Word(several different ways) and every time it is not visible on the desktop but I can see all the shortcuts when I explore the desktop folder. I checked the shortcuts properties and they are not hidden. Theres probably a good/easy explanation for this but this...

We have an old Windows NT workstation that is a voice/phone recorder that records all phone calls on 10 different lines(Audiolog). While attempting to get this PC visible on our network, it seemed that the network card wasnt working or maybe the driver wasnt loading. I changed the startup...

This is probably an easy one but I'm stumped and in a hurry. The formula is =B13 but when I copy it down, the formula copies(=B14, =B15, etc) but all cells display the value from B13. If I go to each cell and click in the formula bar, it will then calculate and display the correct value. I...

I have a file that has part numbers with leading zeroes formatted as special/zip code instead of text. When I try to format them as text the leading zeroes disappear. It seems that for example 00103 is actually only 103...the formatting is what puts the leading zeroes in. Not all PN's have the...

This is an unusual problem so bear with me as I try to explain it as best as I can. We are an automotive warehouse (host)with 10 retail locations all connected to the same database...which is a Unix Based computer. The remote locations are connected via a 56k frame relay connection and use FDT's...

This is an unusual problem so bear with me as I try to explain it as best as I can. We are an automotive warehouse (host)with 10 retail locations all connected to the same database...which is a Unix Based computer. The remote locations are connected via a 56k frame relay connection and use FDT's...

Is there a way to reset the password in a protected sheet without knowing the original password?

I'm recording a macro for a project I'm working on. I have permission to work on this project at home so if I am able to perfect the macro, I will want to have it on my home PC as well. What is the best method for doing this? Excel 2002 both machines

I think I have seen this before but now I cant find it. Is there a way to make formula error display as something other than #N/A? Excel 2002

I have a problem that I face on a somewhat regular basis. I have part numbers which may have a combination of letters, dashes, and numbers. I have to go thru and manually delete the dashes from some part numbers but not all of them. This is the desired "format"... If the dash is between a letter...

Is there a way to change the default header/footer settings in Excel? I would particularly like the footer to be #8 font size...it always comes up as 10 and I always have to change it.

I have a SS with over 32,000 rows and my PC is locking up when trying to sort with vlookups in 2 of the columns. Is there something I can do to boost performance while working with these larger files? Pentium 866 with SCSI drives, 512 SDRAM, Win2K, Office XP. This topic below is regarding the...

I have data this will come out of the database looking like this... Location Line Part# PartType 1 GAT 1000 N 2 GAT 1000 S 3 GAT 1000 N The locations represent the stores with Location 1 being the warehouse, 2 3 and so on are the retail stores. I need to...

My boss would like to be able to use a dial up connection when he is away from the office and send/receive emails. I know I can set it up to do both but when he is at the office, the dial up connection will fail...when he is home the LAN connection will fail. It will always be a nuisance no...

I thought this might be a server issue but only 2 people are complaining about it. I just got through hitting s/r 3 times before it would send the 1 email in my outbox. Both machines are Win2000 with Office XP SP1. Server in Win NT. Email accounts are configured as POP3.

I regularly send meeting invitations to my supervisor. In the last few months, if I send him an "all day" meeting it will show up in his calendar as spanning 2 days. I sent him an invitation for April 6th, 2:30 - 3:30 and it shows up in his calendar as 1:30 - 2:30. Both computers are on Office...