Summary: You use linking for the Word piece (look it up in the help files, theres oodles of useful stuff there. Essentially, the easiest way is to copy your so...
Summary: I know that about access. But I need to create for my exam a spreadsheet system. I would like to create a main board, like a switchboard in access, h...
Summary: I'm wondering in anyone has ever used a keystroke recorder in a Windows Network system. In particular I'm looking for a recorder that'll work in Excel...
Summary: I am facing a major problem in excel. For the past few days whenever I run my spreadsheets I get the following message Application exception occurred:...
Summary: What did this function do? Is it possible that URLEncode was a User Defined Function. A User Defined Function is a function written in VBA and made ac...
Summary: When using MS Access 97, I am trying to import a Office 2k .xls spreadsheet. I keep getting an error message when double clicking the file to be impor...
Summary: Hi I want to put a formula in Excel in such a way that the denominator automatically decreases by 1 unit in every next cell. Let me explain Consider t...
Summary: Here’s a piece of weirdness I’ve been investigating with my spreadsheet database. As you doubtless know, you can put hyperlinks to a file on your...
Summary: How can I create a print button in excel so that the user by clicking it will get the whole document printed? BUT The page must not have any backgroun...
Summary: Please forgive me if this has already been answered, but I didn't find what I'm looking for. I'm trying to figure out why in excel 2007 when I record ...
Summary: Should be a pretty simple question for an Excel guru. I have two columns of text that are nearly identical except a few entries. I need a way to pul...
Summary: I have an excel spreadsheet with several worksheets. I am importing data into the 1st worksheet and then performing formulas etc into another sheet wh...
Summary: I hate time calculations in Excel. Here's what I tried. A1: 8:11 AM B1: 4:58 PM C1: =(B1-A1)*24-.5 Result: 8.28 Repeat that for 3 more working days. ...
Summary: Hi, Is it possible to just lookup an Access database from within an Excel sheet to see if the value is there? eg. I have a list in Excel of accounts, ...
Summary: I need to Sort an entire row by date automatically (close of escrow). I would like to be able to hit a button and the sheet sorts all the rows by date...
Summary: ertw= estimated return to work. This colume will most always have a date to start a case. ertw/ld= estimated return to work light duty. This colume ma...
Summary: I don't have Access but in Excel you can select to Format, Custom where you can specify how many digits or characters will be used in the field. eg. A...
Summary: hi, I want to add drop down in excel using the macro. my concenpt is as follows. if we select "USA" in cell1,1 then the list of states must pop up in ...
Summary: I have a database that is 600 MB (139,000 columns), and need to open it in Excel. Will it bomb and crash my puter ? How should I go about doing it? An...
Summary: User has an excel spreadsheet created in Excel 2000. The spreadsheet is fairly simple, a listing of meetings with several filters inserted. The user t...
Summary: My question is this, does anyone know of a shortcut keys to switch between worksheets in Excel, specifically Excel 97. For example if you hit CTRL +...
Summary: Hello, how to set the type (text, number, date,..) of column in EXCEL with VBA? (not manually through Ctrl+1 -> Format of Cells ->...) Thanks for your...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
