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 Chriss Miller 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: cmz21
  • Order by date
  1. cmz21

    Internet Connection

    I was able to get it working using pppoe. I am away from that machine right now, but when I am there I will post some details as to what I did. thanks for all your input.
  2. cmz21

    Worksheet disappears when loading spreasheet

    Check in task manager to see if there is an instance of excel running in the background before you open the sheet. If there is one running, it can cause this to happen. I have found that if I run a macro prior to opening a sheet and all objects are not cleared at the end of the macro, it...
  3. cmz21

    Internet Connection

    Thank you for the info.....I will try this when I can amd let you know how I make out.
  4. cmz21

    Internet Connection

    Hello, I am very new to linux - I have just installed Yoper on a laptop that I have. I am not sure how to get it to connect to the internet. I previously had windows xp running on the machine and did not have any trouble to connecting. I have a DSL modem connected to the laptop. Is there a...
  5. cmz21

    Cell Reference in VBA

    I have solved my own problem. In my coding, I stupidly didn't take into consideration that I was creating a new workbook and was trying to reference the second sheet before it was actually created. I moved that line of code to the end of my sub and it worked fine. thanks
  6. cmz21

    Cell Reference in VBA

    hello, I am using the following code to create a formula in a cell which refers to a cell on another worksheet - xlSheet.Range("I21").Formula = "='Worksheet Name'!E29" Every time I try to run the code, a browse for file dialog box opens up. How can I tell the code to use the named worksheet...
  7. cmz21

    taskbar problem

    It is as small as it can be at the moment. The problem isn't necessarily the size of the taskbar, it's that sometimes it won't autohide. I don't know if a program running might keep it from hiding, but it just won't disappear.
  8. cmz21

    taskbar problem

    Hello, I have the taskbar set to autohide, but sometimes it does not disappear. This causes problems because sometimes I can't see action buttons at the bottom of the screen because they are hidden by the taskbar. Does anyone have any idea what might be causing the taskbar to not autohide...
  9. cmz21

    using table values as variables

    I think I may be able to use a list box - however this will make me have to create one report at a time. I would like to be able to select the whole list and have it work by creating a new excel workbook for each location. Can this be done? Thanks
  10. cmz21

    using table values as variables

    I actually have 2 queries that I would like to use the same table variable for. Each location report will have multiple worksheets driven from different queries, so an access report probably won't work.
  11. cmz21

    using table values as variables

    Hello, I have a table that lists all locations for a customer. I have to create a seperate report for each location. How do I set a query to use the values in the location table as the filters for each run. I want to use vba to run through the query multiple times using each location value in...
  12. cmz21

    problem logging in to ftp site

    yeah...I now like using firefox as well. I did find, however, that uninstalling and reinstalling IE did the trick. Still no idea what exactly happened, but it's working now. Thanks for any help. cmz
  13. cmz21

    Problems with datatypes

    I have tried your second suggestion and it seemed to have worked. I have been able to transfer this into vba and it is working fine. Thanks for your help.
  14. cmz21

    Problems with datatypes

    I tried using range("A:A").value = range("A:A").value in my vba, but that didn't seem to do anything. I will try your second solution. Thanks
  15. cmz21

    Problems with datatypes

    Yes, but how can I get the text cell 09 to be interpreted as number value without the 0. I want to perform grouping on the column, but it won't group 9 with 09. So even if I change the 9 number format cells to a text, they still will not be grouped together because of the 0.
  16. cmz21

    Problems with datatypes

    Hello, I am trying to use vba to create an excel spreadsheet. The problem I am having revolves around 1 column. Some of the values in the column are numeric (eg, 1). There are a few with a value 09, which are coming in as text. I would like to do automation with vba, but I can't get these...
  17. cmz21

    problem logging in to ftp site

    I have been able to use mozilla along with the FireFTP addin to get the ftp working, but still cannot get anything working with IE. Strange......
  18. cmz21

    problem logging in to ftp site

    I'm going to try using firefox - see if it makes a difference.
  19. cmz21

    problem logging in to ftp site

    Already tried that....can't figure it out
  20. cmz21

    problem logging in to ftp site

    Hello, I am getting a page not found error when trying to access an ftp site using internet explorer. I can access the site just fine using the ftp command from the command prompt. Anyone have any idea why this might be happening? Other users can access the site just fine using internet...

Part and Inventory Search

Back
Top