Programming

Need help with Workbook_BeforeClose event
After I Save a workbook, I then Close it. But when I do so, Excel prompts me to Save the workbook again. Is there some code I can add to the Workbook_BeforeClose event that will negate the prompt to re-save it (even after I just Saved it!)? Thanks in advance for any help. Bob ... 18 Apr 2010 21:57

Assign variable value across files
I have 2 files that are open, File A and File B. I have two Public variables VariableA and VariableB in Files A & B respectively. How do I assign/pass the value between the two. I know I can do this by assigning the value to a range and then from a range back to the variable, but what is the syntax for assig... 18 Apr 2010 15:18

fractions to decimal
I want to have one cell call a cell that has a fraction in it that is formated like so 0'-7/8" I need it to be formated like 0'-0 7/8" so with the following code I can convert it to decimal. [=SUBSTITUTE(LEFT(H69,FIND("-",H69)-1),"'","")*12+SUBSTITUTE(REPLACE(H69,1,FIND("-",H69),""),"""","")] the above code ... 19 Apr 2010 11:34

"Move to bottom of range"
Hello, I have some code that adds the contents of one sheet to the end of another. How do I correctly select the first empty cell below the first sheet that I want to add data to? Something like ActiveCell.SpecialCells(xlLastCell).Select 'Move to bottom of range ^^^ This is where I need work. ... 30 Apr 2010 21:53

A formula for subtotals against each category
Hi, I would like to have sub totals of Marks against each category and name ( there are diffrent names). please help me with a general formula. Thanks in advance Jeevan Sr. No Qtn No. Name Test No Subject Correct Option Marked Option Marks sub total Category 1 Apoorva 4 2 -0.25 Analytic... 18 Apr 2010 09:45

Worksheet toolbar
The following code works perfectly on my machine. The custom toolbar is only visible when one specific sheet is active and disappears when I switch to another sheet or another workbook. But when the WB is opened on someone else's machine the toolbar appears and will stay visible when another WB is activated and the... 18 Apr 2010 17:32

Restricting pasting, except for Paste Values
Within this Discussion Group, I have searched for "restrict pasting" and "prevent pasting", but I have been unable to find a thread that solves my problem. I have created a worksheet in which I have added conditional formatting and validation rules to various cells. Most of my users typically copy data from ... 17 Apr 2010 21:49

Problem with referencing a hidden column
The code below works great, that is until I hide column Q. I do not want the data in column Q to me visible on the worksheet. Is there any way around this problem? TextBox100.Value = Range("Q4").Text TextBox200.Value = Range("Q49").Text TextBox300.Value = Range("Q94").Text TextBox400.Value = Range("Q139").... 17 Apr 2010 21:49

open word file
Hi i would like to open word file using getopenfilename by using excel macro and copy the data to excel file. Sub test() Dim appWD As Word.Application Dim appWDS As Word.Document Set appWD = CreateObject("Word.Application.8") appWD.Visible = True filetoopen = Word.Application.GetOpenFilename("All Files (*.... 17 Apr 2010 15:13

Sheet delete event
Excel 2007, Win 7 I have a bunch of sheets, each named a person's name. I have a list of these names that I use in a DV cell. When the user deletes one of these sheets, I would like for the list to be changed to reflect that sheet deletion. How can I capture the event of a sheet deletion? Thanks for your ti... 19 Apr 2010 11:34