excel 03

I have closed a document (that I forgot to save), I cannot figure out how to restore the file. Is there any way to recover the file?

Good day, I'm having a difficulty opening a .xls file using a Ms Exel 2003. It prompt a box saying: The file you are trying to open, 'AA.xls' is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the...

For years I've bypassed this issue by using SUMIF constructed tables, or VBA macros. Finally come across a few problems I can't adequately fix with it. It's probably simple. On a pivot table in excel 2003, is there a way to lock the row and column data so that, when a filter is applied it uses...

I need some help, I am using Excel 2003 and hope someone can help me with this dilemma. I have an excel sheet with date information on it that is formatted like this: Sunday, April 27 The year is not imputed into the spread sheet. Is there a way to have it look like this: 4/27/1997 Thanks

Hi all, I know this question has been asked over and over again, but no matter how much I search I dont seem to able to find a suitable resolution. My challenge would seem to be simple, but I am unable to sort it out by myself. I work in a call centre and I record my daily figures. My target is...

Hi guys. I have Excel 2003. I am working on a problem. I have multiple sheets for various purposes of my customers with all various columns. However i require to have a master sheet which gives me the due dates customer wise in one place. i.e it selects the customer, the worksheet purpose (say...

I need help for creating vba code in EXCEL 2003 for command button which will find cell in table range using column and row header with criteria which contain focused cell in list

I am trying to have a user type in a 4 digit number. This number corresponds to a xls file name (as if you were browsing on your computer that is what you would see). This would then open that specific workbook. After opening the workbook it would copy the only worksheet in the workbook. It...

Hi Team, I'm attemping to assign a Macro that has multiple parameters to an image in Excel 2003. It works with one parameter, but as soon as I add a second it can no longer find the macro. Example of what works: 'MacroName("Parameter1Value")' ' Function to open the correct UserForm. Sub...

I have the code below which captures my data onto a the sheet, and works fine when there is already data in the spreadsheet; Private Sub btn_Add_Click() Dim ws As Worksheet Set ws = ActiveSheet ' change for the worksheet you want data to go to Set rngNext = ws.Range("A" &...

I currently have the code below; Private Sub CommandButton1_Click() Dim Response As VbMsgBoxResult Response = MsgBox("Are you sure you want to delete this waiting list?", vbExclamation + vbYesNo) If Response = vbNo Then Exit Sub Sheets("Home").Select Sheets(ComboBox1.Value).Delete Unload Me...

Hi all, I have a VBA script which is designed to conditional format certain cells based on another cells dropdown selection however every time i run it i get the runtime 13 error. Now i know the formula is a big one within this macro however i've been told this is the only way I can get excel...

Hi all, I'm currently using Office 2003 to create a rolling forecast that can automatically update and populate. Because of my lack of vba knowledge I'm currently stuck on how to do a few things. I searched online how to copy multiple rows, and with it only specific columns, but could not find...

I am working in excel 2003. I have a drop down box in a cell which has two options say A and B. I want certain cells to lock themselves based on input from the user, means if user selects A cells from A5 to A15 should get locked. Similarly B5 to B15 should get locked if user selects B. So I was...

Hi Everyone, I have a situation where i have to copy data from web page and paste the data in a single excel cell without losing formatting. Data on a web page will be like the below: **************************************** This is in bold This is in red color and bold...

Hello Every intelligent soul out there, For the past 15 days I have tried practically every site that google has thrown up whenever I have searched for help on using VBA to create a pre-defined excel sheet with varying data into different PDF files with a filename which can be generated by...

I'm looking for some VBA help, I have date values in Column A, Planned Budget Spend to Date in Column B (all on sheet1), and I would like to sum the daily change orders on sheet2 and add pass those values to Column C on sheet1 and sum those to the corresponding row (matching date)...

Hi all, I have been tasked with some string manipulation and today must be my bad head day as it is proving more difficult than I expected. I have to take the initials of the first and second and third name from the first and second and third columns along with any surnames The reason is we...

I get a excel book from a colleague and I need to validate all the formulas,quite a lot of them is there any fast way of doing it?

I have been trying for some time to be able to download a file from what I believe to be a FTP site. There are three user input fields which I have been able to identify there names. After these fields are complete there is a button to push which I have also identfied it's name. Once the...