Search:

There are a number of spammers that spoof your email address to make it look like the email came from you. I get an average of 50 of those per day. I think that most of them come from Russia and...

Did you put the double quotes around "%1" when you added it to the end of the command line like Hans said in his message? If you did not, that would cause this problem with any file that has a space...

I wonder if they have figured out yet what their customers think of the Registration/Activation wizard and the user interface in the current versions of Office and Windows?

I think questions 1 & 2 are bad questions:

For question 1 I answered Fill Series which I think is correct. I do not think that Fill Handle is correct since it could also result in Fill Copy which...

Thanks. I played ariund with InternetConnect but I can't figure out how to make it work.

OK, I think I see the problem. The download is from a proprietary site which I have to log onto before I can download the files. I thought that, if I was currently logged onto the site in IE, then...

I thought that was going to work. I tested it by downloading a .xls file from here in the lounge and everything went perfectly. However, when I tried it on the real file that I need to download (a...

Thanks, I'll take a look at that. WININET.DLL does seem to be there.

Thanks. However, I have just had to buy a new computer and much to my dislike the new one came with VISTA Home Premimum installed. From what I can find out by searching the MS web site, MSINET.OCX...

Based on data entered by a user, I can develop the http: address of a file that I need to download from a website. It looks like the FollowHyperlink method will download the file based on the...

No, you have several problems. First, ISEMPTY only works on a single cell not a range. Second, your IF statement doesn't do anything if ISEMPTY returns true. Does this do what you want?

<code>...

In addition to what Hans has said, from what I see you do not need either the WORKDAY or the DAY functions in this case. You could just format A3 as "ddd dd". If you need the result in another...

Well, it has been almost a week since I read a post somewhere here in the Lounge about a problem someone was having that was caused by the Registration/Activation Wizard. The fact that a lot of...

If "time displays as military time in the column and am/pm time in the formula bar", then that indicates that those values are Excel Date Time values. However, you haven't told us anything that we...

In my opinion, all MS software that contains the Registration/Activation Wizard is a pain and is broken. I was just forced to downgrade from Windows and Office 2K to Windows and Office XP since the...

Thanks, I'll take a look.

For the second time in three weeks, I have installed a piece of software on my PC that did something that kept Windows from booting in normal mode (this time it was Roxio's Easy Cd & DVD Burning). ...

The "o" in front of oCell does not tell VBA anything. It is simply a naming convention that tell people reading the macro that the variable is an Object variable and therefore requires the use of...

Thanks everyone. Has anyone used the XP FAX support who has also used Symantec's WinFax Pro. I have a copy of that which I used on Win 2K and I really liked how it worked. If so, can you compare...

Does XP support sending/receiving FAXes, and if so how do you install that support?

Because the prorammers spent all their time working on the *^$# Registration/Activation Wizard? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Hey!!!!!! I am the one who is getting to that age. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

I do not understand. If the .End(XLUP) stops at a non-empty cell then are you saying that IsEmpty(LastCell) will be true?

Yup, that is what I said in my last message. LastCell is set to the last cell with a value in it, therefore the IF IsEmpty(LastCell) is NEVER true. Try:

<code>
Set LastCell =...

In addition to the missing End If that Hans pointed out, I see two additional things.

1- The line that reads:

<code>
Set LastCell = .Cells(.Rows.Count, "J").End(xlUp)
</code>

finds the...