Search:

Type: Posts; User: LegareColeman; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    11
    Views
    871

    Re: Site Username

    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...
  2. Replies
    15
    Views
    1,029

    Re: files open slow (2007)

    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...
  3. Replies
    5
    Views
    643

    Re: Sooner Or Later ...

    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?
  4. Replies
    11
    Views
    2,802

    Re: How well do you know Excel?

    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...
  5. Replies
    13
    Views
    3,197

    Re: FollowHyperlink (Excel 2003 VBA)

    Thanks. I played ariund with InternetConnect but I can't figure out how to make it work.
  6. Replies
    13
    Views
    3,197

    Re: FollowHyperlink (Excel 2003 VBA)

    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...
  7. Replies
    13
    Views
    3,197

    Re: FollowHyperlink (Excel 2003 VBA)

    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...
  8. Replies
    13
    Views
    3,197

    Re: FollowHyperlink (Excel 2003 VBA)

    Thanks, I'll take a look at that. WININET.DLL does seem to be there.
  9. Replies
    13
    Views
    3,197

    Re: FollowHyperlink (Excel 2003 VBA)

    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...
  10. Replies
    13
    Views
    3,197

    FollowHyperlink (Excel 2003 VBA)

    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...
  11. Replies
    20
    Views
    1,144

    Re: Use count to stop macro (2000)

    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>...
  12. Replies
    6
    Views
    419

    Re: =DAY() question (Excel 2003 SP2)

    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...
  13. Re: Office 2007 General Question (Office 2007)

    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...
  14. Replies
    4
    Views
    2,569

    Re: Date and Time Sorts (Excel 2003 SP3)

    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...
  15. Re: Office 2007 General Question (Office 2007)

    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...
  16. Replies
    2
    Views
    494

    Re: Windows Installer (XP SP2)

    Thanks, I'll take a look.
  17. Replies
    2
    Views
    494

    Windows Installer (XP SP2)

    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). ...
  18. Replies
    25
    Views
    1,259

    Re: change cell color (office 2000)

    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...
  19. Replies
    4
    Views
    508

    Re: FAX Support (XP SP2)

    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...
  20. Replies
    4
    Views
    508

    FAX Support (XP SP2)

    Does XP support sending/receiving FAXes, and if so how do you install that support?
  21. Re: Paste special to create a formula (NOT 2007)

    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>
  22. Re: User Form: findind specific blank cell (2003 SP2)

    Hey!!!!!! I am the one who is getting to that age. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
  23. Re: User Form: findind specific blank cell (2003 SP2)

    I do not understand. If the .End(XLUP) stops at a non-empty cell then are you saying that IsEmpty(LastCell) will be true?
  24. Re: User Form: findind specific blank cell (2003 SP2)

    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 =...
  25. Re: User Form: findind specific blank cell (2003 SP2)

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4