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: *

  1. amberH

    counting distinct entries in a range in excel

    Hi all, I found a formula on a web page for counting distinct entries in a range of cells in Excel. It works on one of my worksheets but not on another. I'm baffled. The following formula I use in one sheet and it works great...
  2. amberH

    remove dual boot - Linux-Win ME

    Hi all, I have a dual boot, Win ME / Linux setup. I needed to reformat my hard drive (big problems) and want to get rid of Linux at the same time. I've reformatted my hard drive, but I'm pretty sure Linux is still there. The size of my hard drive should be 20M, but it's saying it's only 14 (6 is...
  3. amberH

    macro/SQL error in Excel

    Hi All, I'm stumped. I have recorded a couple macros for retrieving data from Access into Excel. They work fine as recorded. The problem is this. I have a database with several lists of checkboxes. I have an excel sheet that pulls those checkboxes into a worksheet. When I record a macro, I pull...
  4. amberH

    Excel code - why so slow?

    Hi all, I'm hoping someone can help me with this. For some reason my code is REALLY slow. I'm pasting a few lines below: Sheets("paper-data").Cells(1, 1).Value = Yr Sheets("paper-data").Cells(2, 1).Value = monStart Sheets("paper-data").Cells(3, 1).Value...
  5. amberH

    DAO/ODBC basic explanation

    Hi all, I'm wondering if someone can help me out here. I'm looking for a simple (for dummies) explanation of DAO/ODBC drivers...and what they are. I've done a lot of database work, and can copy other code until I get the desired results, but when I run into problems, I don't really have a clue...
  6. amberH

    Moving data into Excel from Access

    Thanks, I was thinking of that, but what I need is to have it totally automated. I'm creating this for other users, and I want the basically to hit a button, and have Excel go out and get all the relevant data from Access. Possible? Thanks, amber
  7. amberH

    Moving data into Excel from Access

    Hi All! I'm looking for advice on the best way to do this... I have an Access database with a bunch of Yes/No fields and a few text fields. I have an Excel spreadsheet, where I need to summarize, and pull all fields containing 'yes' into the excel spreadsheet, with the push of a button. I'm...
  8. amberH

    calling a .vbs file from excel

    Thanks acron, I was actually trying at first to put all the code in Excel, but I know very little about this. I have the following VB code, but it won't run as VBA code. I run into trouble with the section "set WshNetwork = WScript.CreateObject("WScript.Network")" line...
  9. amberH

    calling a .vbs file from excel

    Hi all, Is it possible to call a .vbs file by coding a button in excel? I have a .vbs file that installs a printer on the user's computer. I have many of these files, each installing a different printer. I was hoping to set it up in an excel sheet, with buttons to call each file. Possible...
  10. amberH

    automatic checkboxes

    Hi all, I have a list of values that will be check boxes on a VBA form. There is a chance that in the future more check boxes will need to be added. I want to have a list on a hidden sheet so that when my form is opened, it pulls each item as a separate checkbox. This way users can simply add...
  11. amberH

    manual calculate for one workbook

    Thanks! That's exactly what I wanted. I figured commands just like those existed, but I couldn't find them anywhere in Help. Thanks again! amber
  12. amberH

    manual calculate for one workbook

    Hi all, How can I set a workbook to manual calculate? I have a workbook that multiple users use. If autocalculate is one, it is SLOW. I know that I can set my options to manual calculate, but then all workbooks I open after this are manual, which isn't what I want. Is there some way I can set it...
  13. amberH

    time format in Excel

    Hi all, A friend is asking me for help, and I'm not sure how to do it. He used Excel 97 (which apparently allowed you to type in Lotus formulas?) and recently switched to Office 2000. He used to have a macro, with a hot key, that he would hit, and then enter a time, in the format 12,30 for...
  14. amberH

    using a text file with an excel file

    Hello, I have this set up to automatically get the text file every morning (a new one is generated every day). I've used this method in the past, and it works great. I think the problem here is that sometimes there is a negative sign before the numbers, which skews everything. I don't really...
  15. amberH

    using a text file with an excel file

    Hi All, I'm having a problem with using data from a text file. I currently have my program set up to open a text file, copy the lines of text, and paste it into Excel. My problem is this: If my lines of text looks like this: 09/08/2002 1 0000.00 7662.24 0015.99 0501.46 0000.00 0000...
  16. amberH

    Programatically converting or copy and excel file.

    Hi there, I'm creating a spreadsheet that uses 3rd party software to pull numbers from a database. This sheet is used every morning, and is distributed to many people. The problem I have is that the person that will open this spreadsheet every morning to update it has this 3rd party software...
  17. amberH

    VB & SQL Server vs. VBA & Access

    Hi, Thanks for your reply. I do almost identical actions in both the VBA to Access code, and the VB to SQL Server code. The text files are pulled in line by line, and populate 3 tables. The files will be pulled probably 1 each hour or so....a maximum of 30 a day. What is a DTS package?? Thanks...
  18. amberH

    Finding Links in Excel

    Hi again, Thanks, highlighting all sheets and doing a search found the links. Now my problem is this: They refer to another workbook that isn't open. If I try to delete the references in the cells I get an error message saying the sheet is protected, but it isn't protected... Another interesting...
  19. amberH

    VB & SQL Server vs. VBA & Access

    Hi all, I created a database in Access, and populated the tables with data imported from text files. Then I found out I should use SQL Server, and VB...so I rewrote everything, and now have my data being pulled with VB 6 and populating a SQL server database. My problem is this...the VB code is...
  20. amberH

    close Excel programatically

    Hello, I have a workbook that is scheduled to run every morning. After it opens, it runs it's code, then closes down the workbook, but Excel remains open. I can't figure out how to have it automatically close Excel down also. Any suggestions? Thanks, amber

Part and Inventory Search

Back
Top