Replies

It depends. A macro would not be difficult to write, but if you are cleaning up one spreadsheet, you may be able to do it quickly simply by identifying the duplicates. I like to use the sumproduct formula to identify duplicates.

background: In excel A1=A2 will return either true or false. When used in math, a true converts to 1 and a false converts to 0. In the attached, the product (A2=A3)*(B2=B3)*(C2*c3) = 0 (zero) since at least one is false. If I continue that math, (A2=A5)*(B2=B5)*(C2=C5) I get 1, since all values are true. If I sum all the products, the non duplicates add to 1, the duplicates add to more than one.

Once you identify your duplicates,you can use filters, sorting or other data manipulation to do your deletions.

Note the formula uses anchored ranges ($) =SUMPRODUCT((A2=$A$2:$A$7)*(B2=$B$2:$B$7)*(C2=$C$2:$C$7))

put an
Application.EnableEvents = False
before the Workbooks.Open statement.

OK, got that. I never saw the “blocked content” security warning above the row headers before, though apparently it was there until I went to the VBA IDE.

But why is the behavior not consistent? (silly me, M$ programmed it) Sometimes the securty dialog pops up and sometimes there is a security dialog between the ribon and the row headers. Now I notice that I do not get the popup security dialog until after I have gone to the VBA IDE. That most likely was the behavior before, but I never saw the “blocked content” warning.

I am openning a spreadsheet with a macro. The target spreadsheet has an autoopen macro, which I want to run when opened manually, but not when I open it with a macro. How do I accomplish this. Thanks.

I am openning a spreadsheet with a macro. The target spreadsheet has an autoopen macro, which I want to run when opened manually, but not when I open it with a macro. How do I accomplish this. Thanks.

I am openning a spreadsheet with a macro. The target spreadsheet has an autoopen macro, which I want to run when opened manually, but not when I open it with a macro. How do I accomplish this. Thanks.

I am openning a spreadsheet with a macro. The target spreadsheet has an autoopen macro, which I want to run when opened manually, but not when I open it with a macro. How do I accomplish this. Thanks.

I am openning a spreadsheet with a macro. The target spreadsheet has an autoopen macro, which I want to run when opened manually, but not when I open it with a macro. How do I accomplish this. Thanks.

I am openning a spreadsheet with a macro. The target spreadsheet has an autoopen macro, which I want to run when opened manually, but not when I open it with a macro. How do I accomplish this. Thanks.

I am openning a spreadsheet with a macro. The target spreadsheet has an autoopen macro, which I want to run when opened manually, but not when I open it with a macro. How do I accomplish this. Thanks.

Now that I have this working, I can say that the effect takes effect immediately. I do not have to restart the computer or the application. When I open a new project, it reads the registry.

I found it, thanks. I simplified it to the following and it worked. Next I typed in the paths I needed, one at a time. I have no Idea what I big fingered when I change the exported reg file, but I must have been consistent, because I started over more than once.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREORACLEKEY_DevSuiteHome3]
“FORMS_PATH”=”Value1”

_____________________________
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREORACLEKEY_DevSuiteHome3]
“FORMS_PATH”=”Value2”

___________________________________

Thanks for your help

I rebooted and it did not make any differenct

I want to update it. Basicaly I want two reg files and I want to swap between config 1 and config 2

Thanks. I did have a reference set. If I had stopped trying to use Application.Workbookfunctions and simply used the object browser I would have found what I was looking for.