I and others have written an Audit Trail for Excel 2007, which when working should be as close to CFR Part 11 compliant as I can get it. However, I am getting this error message when I close after entering data (see attached file to try it and for all of the workbook, modules and userform codes and access to the Custom UI -make sure to enable macros):

Dear all !

I need to interpolate future dollar (FRA)by log linear (money market) methodology.

Anyone knows how can I create log linear interpolation formula in excel ?

Tks

I'm looking for a list containing the shapes in Excel and their properties. For example: Right Triangle has .height, .width, .top, .left etcetera but I imagine there are a lot more, but which? I want to be able to change the text in this Right Triangle, but there is no .text property.

Thanks

When I add a picture to the plot area of a graph, via fill effects, pictures, the format options are greyed out and defaulted to stretch, which I do not want my picture being stretched. How do enable the format options to change them?

Hi All,

Here is my challenge which i'm facing

1. I have a validation with a list of values which are linked to set of graphs
2. I select one of the options and then the graphs change dynamically
3. I now need to copy the range(not individual graphs)to ppt as a bitmap and loop it through the list of values in the validation. Which means if there are 10 values i need to have a ppt with 10 slides.

Can any one help?

Regards
SR777

I have a an Excel spreadsheet that I am trying to total 2 cells & display the total in one of these cells.

Basically I have a cell (A1) that holds a number for this week. I would like to add this number (A1) to the number in the annual total cell (B1), & have it displayed in cell B1. I hope this is clear enough. If it isn't please ask me about it so I can try to clarify it more.

Thanks!!

I have a sorting problem that is causing severe hair loss. :)

In the attached sheet, I copy information from a web page, (local radio station web site) and paste it into import.

Using a macro, the value is then pasted into the "raw" sheet. I do this to clean formatting and other misc garbage from the data. This works.

When it lands in "raw", formulas in the adjacent columns parse the data. This works.

Using a macro, it is then copied and pasted to the bottom of "Sorted". This works.

Hi all,

I tried to put in a function with named ranges but the formula did not work.. It came out as #Value!

This is the actual formula but I want to reduce it because its very long

= IF(OR(A2>=8,A3>=8,A4>=8,A5>=9,A6>=9,A7>=10)"Not Completed","Completed")

If I named range from A2 to A4 =UNI8 and
A5 to A6 = UNI9

Can I put the formula as

=IF(OR(UNI8>=8,UNI9>=9,A7>=10)"Not Completed","Completed")

Looking forward to some feedback please!

I want to do a BeforeSave workbook macro which will select all worksheets in the active workbook except one worksheet. Is there a way to name the worksheet I don't want the BeforeSave macro to work on and rather than name each worksheet I want it to work on. this is a macro, which will be used in many workbooks with the same name for the worksheet that will not be included in the BeforeSave command, but the remaining worksheets in each workbook will have various names and number of sheets per workbook.

I have two different audit trail macros: The fist one that has a pop-up for for data entry reason after every entry and the second has a pop-up only when saving the workbook. What I have been trying to do is to add a lock cells to the macro for any new data. Any cells that require data entry are already unlocked and there are cells with formulas that are unlocked. I do not want to lock these unless something new is entered. The code for the pop-up for every entry is as follows:
[CODE]
Dim PreviousValue As Variant
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Hello Everyone,

OK, so I posted in the MrExcel forums to get some VBA help and I have a macro that does 95% of what I want it to do, however I need help to get it to function correctly.

Thread can be found here: http://www.mrexcel.com/forum/showthread.php?p=2884439&posted=1#post2884439

Any help would be appreciated.

Thanks!

Hello,

I need help with a macro for a project i am working on. I am bringing data in from an xml spreadsheet. The data is benefit information for employees.

One of the columns I am bringing into the spreadsheet is named 'CategoryName.' This field can have multiple category names associated with one person. So, it is creating multiple rows for each person. 1 row per category name. The column to the right of 'CategoryName,' is 'CategoryValue.' This column contains a value that is associated with the value in the 'CategoryName' column to the left.

I am trying to take data that exists in one sheet and make it automatically copy to another sheet. The data is in rows with titles (name) to define what is in each row. The data does not all need to be copied. only certain cells from certain rows. The title (name) of the row is already listed on the page that is being copied to. Is there a way that excel can find those names from the copy from page and transfer certain lines of code to the copy to page.

I work in construction and am trying to get organized. I have several excel files for tracking documents, and want to create one file that shows me the documents not returned by other parties. My goal is that any row in the existing files that contains a specific phrase, i would like the entire row copied to the new file. I've seen other responses here that provide response to similar requests but i don't understand the response. What i'm looking for is step by step response, like "under the formulas tab, click "more functions" then select...." Plese help.

Thanks.

Hello Vishesh,

I am attaching three sample files. I want to build a macro to be run from “Sample 3” which is resulting file. After clicking run it should ask user to enter month name as “July ’10" and after considering this input from user it should add to “Sample 2” sheets from A to A July '10 and so on .. and then merge “Sample 1” & “Sample 2” file in “Sample 3”. It should move as first A JULY '09 then A JULY '10 and for next A JULY ’11 similarly for B and so on …

In short the resulting sheet would be “Sheet 3” with the exact sheets order.

Please help.

Thanks.

Bunty

I have what I hope is a simple problem, but I have no idea how to do this, and I'm hoping someone here can help.

I have a worksheet which contains 4 columns.

Name, Company, Sponsor, Email address

The Sponsor and Email address are the same for each unique Company (ie, the Email address and Sponsor is associated with the Company not the Name), but there are up to 12 different Names associated with each unique Company.

I am working on an Excel VBA app that will use several custom classes that encapsulate a Scripting.Dictionary. I wish to use the For Each construct with these classes. I have put together the class and entered the NewEnum function, exported the class, added the necessary Attribute records, re-imported the class. The class works quite well except the For Each gets an error 424 Object required error. I have been unable to find any information about using NewEnum with an encapsulated Dictionary. Here is some sample code:

Option Explicit

Private mdictShtRegns As Scripting.Dictionary

Hi again!

I have another question.

In Excel 2010 "Page Layout" tab, "themes" group, I can change main colors from my personalized "theme colors". Is there a way to change the colors based on main colors?

Thank you

Hi,

I think I have a problem with links between workbooks. I hope you can help me. I'll try to explain what I've done:

1) I open two workbooks - the source and the destination workbooks;

2) In the destination workbook I type an equal sign and then select the cells in the source workbook I want to link;

3) Then I have two situations:

First situation: if both workbooks are open, any change in the source workbook is updated to the destination workbook - it works fine!;

Hi excelexperts! I've a question about sendin excel workbook via outlook but when running macro to send the active workbook this message appears "Run-time error 1004"
How does it works?
Thanks in advance!

Hello Vishesh,

One of my file recently converted to ms excel 2007 from 2003, now it has file extension xlsx. While opening this file in 2007, we see that chart titles was not updating while the data appropriately updated hence we clicked on the chart name then on the formula bar delete everything except = and then clicked on the drop down filter from which different chart names updating, it worked and finally works good in both 2003 and 2007 version (Chart names also updating as we select them from drop down)

Sir/Madam

I want to learn Excel VBA to create a calculation of pension for my dealing work in office for my convenience. Pls provide me some sample Excel VBA work for reference. I also request to provide any ebook to learn and better understand of the Excel VBA. Pls send me to my mail ID surni.bheemashankar@gmail.com

Dear Experts,

Please guide me on one simple query.

I need to get Maximum of two Absolute values with same sign (-ve/+ve).
Please see enclosed snapshot.

Hallo !
can any one know how to set an automatic email remainder with the help of excel / outlook ?
i have a couple of worksheets with certain tasks that needs remainder on
every bi-weekly ! I would like to set up in a way that my calender reminds 2
days before the task date. Kindly help with suggestions !

thank you

Hello !
how to set notification from excel to microsoft outlook ?
The scenario is like this ,

i have spreadsheet which has to be checked every bi weekly. my boss needs me to create a notification system from that spreadsheet, i.e for every bi-weekly , it should send an e-mail to the specific people to check the spreadsheet automatically :( I tried many things like setting up timer in VBA. it didnt work out, and i didnt know how to connect automatically to the mailing system. Please can one help me out to find a solution !

Thanks in advance

Indhira

hi,

Can anybody help with this requirement. I have an Excel sheet with column A containg Bank Branch name and column B containing some numbers.
For eg: A B
branch1 10
branch1 20
branch2 11
branch2 11

I want a macro which copies branch1 details in one sheet, branch2 details in another sheet etc

If someone wanted to automate pulling info from a website..http://moneycentral.msn.com/investor/invsub/analyst/earnest.asp?symbol=fdo and pull one line of data, populate it with the symbol in excel...then run with a different symbol and pull the same line of data, populate....how would someone do that. Doing a Web Query doesn't really accomplish what I'm trying to do. Is there a initial way to direct my research on how to figure this out? There are many stock templates that pull price data on stocks, but this data is a little different. I'd love suggestions from anyone.