Programming

URGENT, help needed.
I am getting ... Cannot find the file '<full path name to the .XLS file I click on>' (or one of its components). Make sure the path and filename are correct and that all required libraries are available This occurs when I try to open any XLS file in Excel2002. What is wrong? I made a simple change to th... 8 Feb 2006 17:50

VBA to extract sheet name
I am using Office 2003 on Windows XP. I have a string that looks like: ='Sheet Name'!R22C7 This string is in a variable, so: sSheet = "='Sheet Name'!R22C7" The length of the sheet name and the cell address changes each time. I need, in VBA code, to strip out the SHEET NAME only. Is it possible to do this ... 8 Feb 2006 12:03

CreatePivotTable error
Hi, I am writing a VB program to creat PivotTables and Charts. The source data is in a Excel file and the output with pivot tables and charts should be stored in another excel file. My code fails in the following command oWorkBookOut.PivotCaches.Add(xlDatabase, "'dec'!R1C1:R179C20").CreatePivotTable oWorkS... 9 Feb 2006 11:04

changing prices in multiple colunms based percentages
I HAVE A PRICE LIST WITH THREE PRICE COLUMNS (COST,WHOLESALE & RETAIL) I NEED A FORMULA FOR MARKING UP MY COST PRICES BASED ON PERCENTAGES FOR WHOLESALE & RETAIL. HERE'S THE WRINKLE THE PERCENTAGES ARE BASED ON THE THE COST PRICE EXAMPLE: WHOLESALE-0-99.99(a)15%,100.00-149.99(a)12.5%,150.00-UP(a)10% / RETAIL-0-69.99@3... 7 Feb 2006 16:44

vbModeless Question
By design, I have a splash screen being displayed while data is being formatted in my program - this is purely cosmetic, since I wanted the user to not view the "flashing" of the screen as the code executed. The splashscreen is displayed via: frmOpportunitySplash.Show vbModeless The issue I'm having is, whe... 7 Feb 2006 16:13

Dyamic Ranges
I was wondering if i could do this, if so how? I have a sum that goes through the same row. Everytime i insert a column i want it to automatically to include that inserted range. Example: A B C D 1 2 3 Cell C1 is suming Ranges A1:B1. Now if i insert the column before column C, i want the su... 7 Feb 2006 20:23

Object invoked disconnected from its clients.
Dear members; I have a "password" userform. The user can enter his password in a textbox and click OK or press Enter. The OK commandbutton and the Exit event resulting from pressing Enter both trigger the same procedure Check_Password to evaluate a users rights. When I insert a false password, the routine wo... 7 Feb 2006 05:08

Excel 2003 SP1: CopyFromRecordset error if field above 911 charact
I have a spreadsheet that pulls data from a SQL Server 2000 database using a stored procedure call (via ADODB.Command.Execute) and the Range.CopyFromRecordset method. In previous versions of Excel (97 and 2000), my code works fine. However, we're upgrading to Excel 2003 and this seems to have problems with any ... 6 Feb 2006 16:44

Runtime error 1004- application defined or object defined error
Hi, Thanks in advance. I am really a novice for VB. please don't laugh at my silly codes. I am trying to copy info on "DataEntry" sheet to sheets "Data" and "Comments". It works well pasting to "Data" but I got error msg like "Runtime error 1004- application defined or object defined error" when pasting to "C... 6 Feb 2006 16:44

Changing the default print settings in Excel
I am trying to change the default settings in the Excel pring page setup for the Margins tab. The default tabs are Top and Bottom at 1, and Left and Right at .75. Is there a way to change these defaults permenantly? -sam -- Thanks for your help ... 6 Feb 2006 09:58