Threads Replies Last Post 4 Pages: 1  2  3  4   File -> Open gives xla file not found when trying to open in Excel 2003 I get this error message 'idxlcom.xla' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted. -Then the "open" is disabled... Every time I click file open this pops up..and i ... 2 28.09.2006 02:30:08 Adjust values in amortization table I have used the Amortization template but would like to adjust it so that it automatically fills in the missing value. If I have 3 of the 4 values (note amount, term, payment and interest rate) it would fill in the missing value and create an amortization table. How do I do this? Thanks. ... 1 27.09.2006 19:48:54 Changing years to months in amortization template I downloaded the MS Loan Amortiztion template. I'm having a problem because it only allows me to enter years for the length of the loan.Some of the loans I have are not even years (37 months, for example),but the template won't allow me to enter this. Can you please tell me how to make changes to accommodate this? Thanks. ... 1 27.09.2006 18:19:02 calender control I have a calendar control on a worksheet (in a template file) and I need the calendar to display today's date when the workbook is opend. I've tried various forms of: Private Sub Workbook_Open() Sheet1 [Calendar1].Value = Now() End Sub and get various forms of error messages. Can someone please give me the correct code or is there something I can set in the property window without ... 2 23.09.2006 10:54:08 Template for a small hotel Dear All, does anybody know where I could find a template for managing a small hotel. Thanks in advance for ANY answer! Best wishes, Marc ... 6 14.09.2006 16:29:41 find and move How can I setup a macro or use a function to find a column who's first cell is called "Addresses" then move the whole column to sheet 2. Is it possible? Puzzled ... 1 13.09.2006 14:08:55 Default save directory for a template Is there any easy way to automatically have a template save to a particular location for that template only? e.g the 'Quotes' template saves to the quote directory the Orders template saves to the orders directory Thanks Mike ... 1 08.09.2006 07:19:28 Loading Data into Multiple sheets in 1 book Loading Data into Multiple sheets in 1 book Hi All I have 2 questions 1. I am trying to automatically create a workbook with a number of sheets in it with different data. I see how the command mode allows you to feed data to a (one/first) sheet (C:\Program Files\Microsoft Office\Office\excel.exe" H:\':DETAIL.XFER.SHORT.FILENAME) but how do you get data to sheets 2 3 4 etc in the workbook?... 1 07.09.2006 14:40:57 Gana dinero facilmente Invierte solo 7 dolares y gana ayudando begin 666 HAZ UN GRAN CAPITAL AYUDANDO A LOS DEMAS.....doc MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````! M````6@``````````$ ``7 ````$```#^____`````%D```#_____________ M____________________________________________________________ M____________________________________________________________ M__________________________________________... 1 05.09.2006 18:07:12 Gana dinero facilmente Invierte solo 7 dólares y gana ayudando.. begin 666 HAZ UN GRAN CAPITAL AYUDANDO A LOS DEMAS.....doc MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````! M````6@``````````$ ``7 ````$```#^____`````%D```#_____________ M____________________________________________________________ M____________________________________________________________ M________________________________________... 1 05.09.2006 17:50:38 Additional funds needed I am wondering if any finance experts are on this forum. I am looking for a spreadsheet that can do additional funds needed (AFN) calculations. It uses the income statement and balance sheet to financial forecast of funds needed when there is a projected increase in sales. A pro-forma would help but most pro-forma do not specifically do this AFN analysis. Thanks DWR ... 1 01.09.2006 19:22:07 Additional Rows >65536 Hi, I need to grab a months data but can be upto 70-80,000 rows. Can you extent past 65k or what is the best way to link seperate worksheets for customers to single month of data........Thanks ... 2 25.08.2006 23:52:00 Emailing Individual worksheets Gday, I have one set of data that will feed approx. 25 worksheets for a monthly report, with each worksheet going to seperate customers. Can I put a hyperlink to the email recipients so that when I run data and get report, I say click on hyperlink in cell A1 with email adddress and it will drop that worksheet only into an email ????. This is rather than copy individual sheets, send as... 2 25.08.2006 23:44:00 .NET 2.0 COM Excel add-in stops responding when SqlConnection object is created Dear All I have encountered a problem when creating a System.Data.SqlClient.SqlConnection in my Excel add-in. I am using: - Visual Studio 2005 - Excel 2003 SP2 I created the add-in with the VS2005 Shared Add-in Wizard. I then included the required Office and Microsoft.Office.Interop.Excel assembly references. In the OnConnection method I add two buttons to the Excel menu. In the ... 1 24.08.2006 15:35:33 if statement Can anyone tell me how to put more than 9 if statements into a single formula ? I can get 9 om a row but not 9 for instance if i want to detect the numbers of days in a mont on a large spreadsheet I may enter =if(a1="Jan",31,if(a1="Feb",28,if(a1="Mar",31,0))) and so on, I can get it to work upto September with it working then it comes up with an error, Thank Peter ... 6 20.08.2006 07:04:54 Estimating return on investment Does anyone have a decent template for estimating the ROI for a new software project? I'm afraid I'm in a bit over my head. Many thanks in advance, John Duke johnduke39@gmail.com ... 2 17.08.2006 23:41:38 Restrict dates entered in date formatted cells I would like to restrict dates entered to a certain month for each sheet (e.g only dates i january for the sheet named Jan). How can this be done? Macro/directly or something else? It would be nice if you could just enter the date and the the month and year were automatically filled in (month according to selected sheet and year according to current year, though it should be possible to ... 1 16.08.2006 13:23:50 Restrict dates entered in date formatted cells I would like to restrict dates entered to a certain month for each sheet (e.g only dates i january for the sheet named Jan). How can this be done? Macro/directly or something else? It would be nice if you could just enter the date and the the month and year were automatically filled in (month according to selected sheet and year according to current year, though it should be possible to ... 1 16.08.2006 13:23:44 template fix I need to fix my outlook so i can save templates again. need help ... 2 14.08.2006 16:08:20 Need a construction estimate template Does anyone have a construction bid template? Or a similar template I could modify? Thanks! ... 2 13.08.2006 07:01:49 soc.com -- MAY the LORD BLESS YOU TODAY GOD BLESS AMERICA ... 1 23.06.2006 13:31:39 csot templates Could any one please send me templates for (cost control & inventory) in hotels accounting thank you khaled khaled_amer3@hotmail.com ... 3 21.06.2006 15:33:41 Converting letters to numbers I am a teacher looking for an easy way to convert letters to numbers. My students get their grades A - F. To calculate their average grade, I need to convert the letters to numbers, calculate the average and then back to letters. Typically the list would look something like this: Subject 1 Subject 2 Subject 3 Average John B C A Mary A ... 4 21.06.2006 15:32:00 Can I Use an "Import" Template Based on a Doc's Filename? Hello. I would like for our users to be able to: 1. Select a text file in Windows Explorer; 2. Right-click and open the file with Excel; 3. Then, BASED ON THE DOCUMENT'S FILENAME, Excel would know which macro/template to automatically apply to the file in order to import it with the proper formatting and alignment. I already have a macro that will import and format the file... but I ... 1 16.06.2006 01:07:27 File Links - Drive Mapping Hi, whenever my client opens a spreadsheet (Office XP) with linked files, it creates a network drive mapping (z:) even though the links point to the h: What is causing this or where else can I look to stop it mapping the z: drive. Thanks, Graham... 1 30.05.2006 06:21:02 4 Pages: 1  2  3  4