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

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

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

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

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

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

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

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

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

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

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