16219 posts
10295 users
Macros n Sheet/Workbook protection
1 replies , 1/17/2004, 2:04:36 PM
Hi everyone, We use excel 2000. I have setup an excel file to serve as a stationary requisition at work.. all works well.. but now i need to ensure that no one changes the format / formulas...

Retrieving a File
1 replies , 1/17/2004, 4:00:48 PM
I need to set up a procedure to automatically retrieve a file(s) and send to a printer at a specified time (6:45) everyday. I'm not that familiar with VBA and have no idea where to start. Can...

tammy zembower
Pivot tables
3 replies , 1/17/2004, 9:11:19 PM
Does anyone know a good place to find information about pivot tables and how to use them?

1 replies , 1/18/2004, 2:04:52 AM
I have recorded a macro that I need to automatically run at 6:45am daily. How do I specify this in the code?

tammy zembower
Gary, Since you are combining multiple spreadsheets I think you will need to do more than what Rick describes. Use the Compare and Merge feature to pull them all together. This is described in...

Only seven arguements allowed ?
2 replies , 1/18/2004, 1:24:46 PM
i am a novice user of excell 2000 but have a specific requirement i need to create a formulae to produce a postage cost defined by 16 different weight catagories i have included my attempt but...

only seven arguements allowed
1 replies , 1/18/2004, 5:21:35 PM
i am a novice user of excell 2000 but have a specific requirement i need to create a formulae to produce a postage cost defined by 16 different weight catagories i have included my attempt but...

Formula for moving target in macro
2 replies , 1/18/2004, 9:09:28 PM
Hi I am very used to making macros with Lotus123 ... yes, the oldie one. But now i am lost with Excel. Lets say i am in a column F for ex. The number of lines is not constant. I want to copy the...

Printing to A3
1 replies , 1/18/2004, 10:30:07 PM
I have a Canon i6500 which prints A3. I have 4 A4 Excel pages I want to print onto the A3. How do I do this? I can do it is Wordperfect but can't figure it out in MS Office. Thanks Dr Carl

Define a variable problem
1 replies , 1/19/2004, 12:25:16 AM
Can anyway advise me on how to define a variable in Excel. I did basic at school as a kid and I wanted to define a variable and name it at the beginning of the spreadsheet and then use the formulas...

Error in macro.
1 replies , 1/19/2004, 5:58:19 AM
I am sorry, i am very new to Excel programming. I try to create a macro to copy a formula in a column where the number of lines os not constant.. This macro will be used in many cases, so the range...

Lost Product Key
1 replies , 1/19/2004, 3:39:53 PM
I need to reinstall my Microsoft Office 2000, but I have lost my product key. Is there any way I can find out what that is?

Sorting numbers acts like text sort
1 replies , 1/19/2004, 3:53:07 PM
We have a worksheet (Excel 2000) that was e-mailed to us. When we open it, it says there are macros, which there aren't. No matter if we say "Disable" or "Enable" macros, all cells are formatted...

formatting numbers
3 replies , 1/19/2004, 4:00:40 PM
I need to insert temperatures on a sheet and would like to be able to show them as degrees C Anyway I can format the number to show the sign for degrees Celsius? I appreciate there may be a font...

formula for the date 16 years ago.
1 replies , 1/19/2004, 7:13:04 PM
Hi, im having trouble for making a formula for the the date 16 years ago. i understand the the formula for todays date is =TODAY() but im not sure how to modify it. thanx for your time --- Message...

electric_d <
separating text into separate columns
3 replies , 1/19/2004, 9:06:07 PM
I'm new to Excel and working on a document with addresses in it. However, the first name and last name of the people are within the same column. So my question is: how do you separate text into...

0 replies , 1/20/2004, 2:24:35 AM
I can't open any excel files because of SYLK. How do I get rid of it or work with it?

file format not valid
2 replies , 1/20/2004, 3:40:50 AM
On my old computer I can receive an excel attachment but on the new one I receive the above error message. When I go to help, it suggests the external format is not valid and to save it in...

Beginner question for months and subtotals
1 replies , 1/20/2004, 5:59:28 AM
I am new to Excel (have limited exp with Word vba). I would like t enter a list of data where column 1 shows a cost item on the lef followed by the 12 months of the year. Row 1 will be for net,...

Paul Cox <
Using linked objects wiyj Outlook
0 replies , 1/20/2004, 7:26:34 AM
Is there any way to link Excel cells to Outlook contact data so that I can share the contact information in Excel? I haven't found it yet. The "paste link" feature doesn't seem to work. Any...