Summary: I've Excel VBA macros which repetitively open 100+ data files (no more than 4 open at once), do heavy number-crunching, save results, then do it all o...
Summary: With Excel 2007 and Internet Explorer 8 (with Windows 7) is there any way to open a hyperlink in a new Tab rather than a different window. Sonehow I h...
Summary: Hi there. I'm hoping someone can help me simplify a function that I'm using in excel. Basically I have rows of data, e.g. Row 1 - XOOXO Row 2 - XXXXO ...
Summary: Perhaps it is different for Excel 2002 but in Excel 97 you are limited to 256 columns and 255 sheets per workbook. So the maximun number of columns in...
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: I have an excel workbook with multiple worksheets, each sheet has multiple pages. When in print to an HP LaserJet 4100 B&W printer the pages com...
Summary: =CELL("filename") will return the sheet name at the end of the file's path. In my example: C:\My Documents\[PhoneNumbers.xls]Phone In the above exampl...
Summary: Your problem is with txtName.Text. It is not a valid variable name in Excel. Try this in the "workbook": Private Sub Workbook_Open() MsgBox ("Hell...
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: When trying to open a shared-workbook, I receive the above error message "Excel caused an invalid page fault in module MSO9.DLL." I've tried mostly a...
Summary: Hello all, I want to know if there is a way to create a bulleted list in an excel cell. Also can you use tab stops in an excel cell. Thanks in advanc...
Summary: hi I have excel 97 inwhich, if i open more than 1 file, its getting opened in the same excel application window. What i need is seperate excel instan...
Summary: maybe Silly, but the only explaination could be that 13.18 is a displayed number(i mean rounded to be displayed). Just try to increase decimals in it'...
Summary: See http://www.cpearson.com/excel/ShortCuts.htm for the Excel Keyboard Shortcuts in HTML or downloading a Zipped .xls file. Regards, Bryan ...
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: I'm confused, but we'll get to that later. First, about your code: As far as I can tell, your code is supposed to prevent users from editing any cell ...
Summary: http://www.computing.net/answers/of... I have got same issue in the link above, how can I change date format in Excel 2003 to dd/mm/yy (28/03/09),,,,t...
Summary: I have an Excel spreadsheet that has 40 rows and several columns which includes "Legend", "HRS", and "$" as column headers and there are eight categor...
Summary: Does anyone know whether MS Office 2003 Basic Edition contains the Excel Solver add-in? I understand Excel Solver is included with MS Office 2003 Pro...
Summary: Hi, Excel should be able to open the files directly. File Open Type in the file name and location. It can be easier to do this from a floppy disk or j...
Summary: I have a user that when she double clicks an attached Excel 2000 spreadsheet in an email in Outlook 2000, she gets a message saying that "the file can...
Summary: I have a user that has an issue with Outlook. Whenever she print an attachment by just right clicking on it within the email it opens up the desired ...
Summary: I have a problem calculating time in Excel. For example, in column A the time is 30:20(30 hours and 20 minutes), how can I turn the minutes into hours...
Summary: If you all ready have the formula in place, you can go into Excel Options and in there ucheck "show zero values". This will affect all spreadsheets in...
Summary: As most of you know excel is great in that when you want to copy & paste formulas it moves the cell references. On one of my sheets I copied and paste...
![[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
