Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ljCharlie
  • Order by date
  1. ljCharlie

    How to activate any cell in the worksheet?

    Thanks! You're right.I got confuse because offset uses 0 but cell uses 1. It works! ljCharlie
  2. ljCharlie

    How to activate any cell in the worksheet?

    I have tried the following: Function numbCols(countrows) As Integer Dim shtAnnual As Worksheet Dim rng As Range Dim numCols As Integer Dim txtInbox As String Set shtAnnual = ActiveSheet 'activate the first cell as a starting point for counting non-empty rows...
  3. ljCharlie

    How to activate any cell in the worksheet?

    Is there a way to activate any cell and make it active in the worksheet at anytime in the program? Any help is appreciated. ljCharlie
  4. ljCharlie

    Automatically set current active worksheet to myWorksheet

    Thanks! I found it. It's ActiveSheet and not ActiveWorkSheet. ljCharlie
  5. ljCharlie

    Automatically set current active worksheet to myWorksheet

    Thanks but that doesn't work. I got an error saying variable not defined on the word "ActiveWorkSheet" ljCharlie
  6. ljCharlie

    Automatically set current active worksheet to myWorksheet

    Is there a way to automatically detect the worksheet name of a workbook? Here's what I want to do. Dim myWorksheet As Worksheet Now, I want to Set myWorksheet to the currently active worksheet. How do I do this? Help is appreciated. ljCharlie
  7. ljCharlie

    How to determine maximum rows and columns?

    Is there a simple way to determine the number of rows and columns in a workbook? It's hard to specify the range if I don't know the maximum number of rows and columns that I can work with. Any help is appreciated.
  8. ljCharlie

    What is the limit that SMTP can do?

    Many thanks for your help. The information you provided is very helpful. ljCharlie
  9. ljCharlie

    What is the limit that SMTP can do?

    Thanks, PScottC, for the explanation. So while the SMTP is sending that 15,000 emails, it will slow down the whole network then, correc? Or we should not be doing any Internet access, correct? What about accessing our network resource, will that affect it too? You mentioned that you send out...
  10. ljCharlie

    What is the limit that SMTP can do?

    So what kinds of hardware or any kind of requirement do I need if I want to send around 10 to 40 thousand emails at one time? I'm creating a news letter for interested users. ljCharlie
  11. ljCharlie

    What is the limit that SMTP can do?

    I'm not sure if this topic relates to exchange server but I don't know which forum to ask so I choose this forum. Anyway, I like to know what the maximum limit of emails that SMTP can send out at one time. Any help, suggestionns, or point to a link is appreciated. ljCharlie
  12. ljCharlie

    Remote desktop web connection

    Many thanks to you. It works! ljCharlie
  13. ljCharlie

    Remote desktop web connection

    Well, I found out that the web browser need to install Remote Desktop ActiveX Control. I'm not sure if this ActiveX control is installed by default or not. If not, then I might not be able to connect to my pc once I'm on the road. One other question, when I instaleld the remote desktop activeX...
  14. ljCharlie

    Remote desktop web connection

    I installed the remote desktop web connection service and it seems to be working fine. However, when I tried to connect to it using a browser, I got to the login page but the "Connect" button is not working despite I put in all the information. The "Connect" button is grayed out. Any idea why...
  15. ljCharlie

    Best way to connect to my server

    Thank you for the response. Yes, I do have port 3389 open on my firewall and it's working except that I want to access through a web browser. I just installed the tsweb on my personal computer at home. I'll give it a try and see what happens. The problem I have with this method is that the IIS...
  16. ljCharlie

    Best way to connect to my server

    What is the best way to connect to my server? I can think of a couple of options such as remote desktop connection and tsweb services. With remote desktop connection, the client has to have Windows XP remote desktop connection application installed. With tsweb, I have to turn on IIS and somehow...
  17. ljCharlie

    CD autostart not working

    Many thanks for the response but it doesn't seem to do the trick.
  18. ljCharlie

    CD autostart not working

    The CD/DVD autostart is not working. Any guess why this would happened? When I double click on the My Computer, the CD/DVD drive does not even show the application's icon. Help is appreciated. ljCharlie
  19. ljCharlie

    CSS not working under MS IE

    First of, I couldn't get the 2-3 pixel gap between the #lftSideMenu and #mainContent, and the #rghtSideMenu and #mainContent to close. Once these gap is closed up, I believed the navigational menu will work. If somehow, this can't be done, is there a way to get the navigational menu work with...
  20. ljCharlie

    Cache roaming profile not deleted

    Well, the problem I have was not a terminal profile issue. The problem is regarding roaming domain user profile. I've checked the Resultant Set of Policy mmc and everything is working without any errors but it just doesn't delete the profile once the user log off the client computer.

Part and Inventory Search

Back
Top