Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

Hello, For some reason an Excel workbook that I've been using for a while, now gives a message when it opens, saying that this workboook contains links to another workbook, and do I want to update them. I should have no links to any outside books...is there some way I can trace where the links...

Hello, I have a general question to ask. I had created a database, and using VBA was pulling data from text files to populate the database. Now I've been asked to move the data automatically into SQL Server (which I know next to nothing about) AND instead of using Access VBA, to make an .exe...

Hi All! Here's a new question about my database. Quick summary: I created a database (with much help from all of you) in Access, that opens a text file out of a directory and pulls all the data into 3 tables. Everything has been working fine, but I'm concerned, and I'm thinking I may need to...

Hi all, I'm pretty sure the way I'm doing things is NOT the most efficient method... As I've posted in the past, this is my situation: I have a folder, where autogenerated text files are placed throughout the day (no set number). I have my database going in to the folder, opening up the text...

You guys are awesome!! The database I'm building is going great. This question will be easy for yous. Every day there is a random number of files created and stored in a folder. What is the best way to go through this folder, and get all files? I already have it finding the correct filename, but...

Hello, I've been working on a database that opens up text files, and imports data into Access. I have the import function working almost perfectly, but now I'm stuck. The files that I need to open up are always in the same folder. The file names are 2 letters, followed by numbers. Each new file...