||||||||||| » » » Here Duplicate a Database Using RMAN in Oracle Database 11g Release 2 This article is an update of a previous article. • • • • Related articles. • Introduction RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, a remote server will a different file structure or the local server with a different file structure. The article assumes the duplicate database is being created on a separate server, using the same SID (DB11G) and the same file structure as the source database. Explanations of several other scenarios are available. If you are duplicating to the same machine you need to make sure the SID and DB_NAME of the duplicate does not match the source database, and you need to make sure the DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters are set correctly, so the duplicate doesn't attempt to use the same directory structure as source database. There may be other parameters to consider including the location of the fast recovery area and admin directories. Check the contents of your SPFILE and read the documentation appropriate for your scenario. Backup-Based Duplication Create a backup of the source database, if a suitable one doesn't already exist. $ rman target=/ RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG All subsequent actions occur on the server running the duplicate database. Create a password file for the duplicate instance. $ orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwDB11G password=password entries=10 Add the appropriate entries into the 'tnsnames.ora' file in the '$ORACLE_HOME/network/admin' directory to allow connections to the target database from the duplicate server. # Added to the tnsnames.ora DB11G-SOURCE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ol5-112-dup1)(PORT = 1521)) ) (CONNECT_DATA = (ORACLE_SID = DB11G) ) ) Create a PFILE for the duplicate database. Since we are duplicating the database onto a separate server with the same filesystem as the original, we don't need to convert the file names. In this case, the PFILE is called 'initDB11G.ora' and is placed in the '$ORACLE_HOME/dbs' directory. # Minimum Requirement. DB_NAME=DB11G # Convert file names to allow for different directory structure if necessary. #DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/DB11G/','/u01/app/oracle/oradata/NEWSID/' #LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/DB11G/','/u02/app/oracle/oradata/NEWSID/' We don't need all the other parameters as the clone will copy the SPFILE from the primary database. If you are duplicating a database on the same machine you will probably need to create a PFFILE/SPFILE manually from the primary database SPFILE, manually change the values and avoid the SPFILE clause in the duplicate command. Create any directories necessary for start the duplicate database. $ mkdir -p /u01/app/oracle/oradata/DB11G $ mkdir -p /u01/app/oracle/fast_recovery_area/DB11G $ mkdir -p /u01/app/oracle/admin/DB11G/adump Make the backup files from the source database available to the destination server. That can be done by either copying them to the matching location on the destination server, or placing them on a shared drive. If you are copying the files, you may want to use the following type of commands. $ scp -r oracle@ol5-112-dup1:/u01/app/oracle/fast_recovery_area/DB11G/archivelog /u01/app/oracle/fast_recovery_area/DB11G $ scp -r oracle@ol5-112-dup1:/u01/app/oracle/fast_recovery_area/DB11G/backupset /u01/app/oracle/fast_recovery_area/DB11G $ scp -r oracle@ol5-112-dup1:/u01/app/oracle/fast_recovery_area/DB11G/autobackup /u01/app/oracle/fast_recovery_area/DB11G Connect to the duplicate instance. DBA Tips Archive for Oracle. In issuing the ALTER DATABASE ACTIVATE STANDBY DATABASE command, the standby bit in the control file is reset. $ ORACLE_SID=DB11G; export ORACLE_SID $ sqlplus / as sysdba Start the database in NOMOUNT mode. SQL> STARTUP NOMOUNT; With the duplicate database started we can now connect to it from RMAN. For the duplication to work we must connect to the duplicate database (AUXILIARY), but depending on the type of duplication we are doing we may optionally connect to the original database (TARGET) and/or the recovery catalog (CATALOG). $ ORACLE_SID=DB11G; export ORACLE_SID # No target or catalog. Metadata comes from backups. $ rman AUXILIARY / # Target, but no catalog. Metadata comes from target database controlfile. $ rman TARGET sys/password@DB11G-SOURCE AUXILIARY / # Catalog, but no target. Metadata comes from the RMAN catalog. $ rman CATALOG rman/password@rman-catalog AUXILIARY / # Target and catalog. Metadata can come from the target controlfile or the catalog. $ rman TARGET sys/password@DB11G-SOURCE CATALOG rman/password@rman-catalog AUXILIARY / We can then duplicate the database using one of the following commands. Remember, remove the SPFILE clause if you have manually created a full PFILE or SPFILE. # Backup files are in matching location to that on the source server. # Duplicate database to TARGET's current state. DUPLICATE TARGET DATABASE TO DB11G SPFILE NOFILENAMECHECK; # Duplicate database to TARGET's state 4 days ago. DUPLICATE TARGET DATABASE TO DB11G UNTIL TIME 'SYSDATE-4' SPFILE NOFILENAMECHECK; # Backup files are in a different location to that on the source server. # Duplicate database to the most recent state possible using the provided backups. # Works with just an AUXILIARY connection only. DUPLICATE DATABASE TO DB11G SPFILE BACKUP LOCATION '/source/app/oracle/fast_recovery_area/DB11G' NOFILENAMECHECK; # Do a point-in-time clone. DUPLICATE DATABASE TO DB11G SPFILE BACKUP LOCATION '/source/app/oracle/fast_recovery_area/DB11G' NOFILENAMECHECK UNTIL TIME 'TO_DATE('2014-11-17 07:00:00', 'YYYY-MM-DD HH24:MI:SS')'; # Alter some SPFILE parameters during the clone. Oracle 11g introduced the ability to create duplicate databases directly without the need for a backup. This is known as active database duplication. The process is similar to the backup-based duplication, with a few exceptions. First, and most obviously, you don't need a backup of the source system, but it does have to be in ARCHIVELOG mode. The passwords in the password files must match for both servers, so remember to set the correct password when creating the password file on the destination server. Both the source and destination database servers require a 'tnsnames.ora' entry for the destination database. In this case I added the following to each server. The destination server still requires the source entry shown in the previous section. # Added to the tnsnames.ora on source and destination server. DB11G-DESTINATION = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ol5-112-dup2)(PORT = 1521)) ) (CONNECT_DATA = (ORACLE_SID = DB11G) ) ) The destination server requires static listener configuration in a 'listener.ora' file. In this case I used the following configuration. Remember to restart or reload the listener. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = DB11G.WORLD) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1) (SID_NAME = DB11G) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol5-112-dup2.localdomain)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = /u01/app/oracle When connecting to RMAN, you must use a connect string for both the target and auxiliary connections. $ ORACLE_SID=DB11G; export ORACLE_SID $ rman TARGET sys/password@DB11G-SOURCE AUXILIARY sys/password@DB11G-DESTINATION Include the FROM ACTIVE DATABASE clause in the DUPLICATE command. DUPLICATE DATABASE TO DB11G FROM ACTIVE DATABASE SPFILE NOFILENAMECHECK; RMAN-06054: Unknown Archived Log During the duplicate operation you may encounter the following error. RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence???? And starting SCN of???? Here are some things to think about when trying to resolve this. • If this is a backup-based duplicate, it is possible you have not copied all the archived redo logs from the target to the auxiliary backup location. If you can, copy the missing logs across and try again. • If this is a backup-based duplicate and you can't copy across the missing archived redo logs, you may need to do a point in time duplicate, described above, to leave you in a consistent state prior to the transactions contained in the first missing log. • If this is an active duplicate, all necessary logs should be shipped automatically from the target to the auxiliary instance. This can only fail if the archived redo logs on the target system have been removed during the clone operation. This could happen if an archived redo log backup has taken place on the target server during the clone operation and deleted the backed up logs. If this is the case, either disable the backup of the target system during the clone operation, or stop using active duplicates. For more information see: • • Hope this helps.
0 Comments
I suggest this reverse phone lookup service: It's a cheap service that works great! It could be used for a much deeper search. You can use it to get hold of different varieties of background reports, and in addition cell numbers, addresses and names. You can get unlimited reports. I ran with this because I required to verify more numbers. You can get the name, other phone number, address history, relatives, and much more about anyone! The completly free reverse phone lookup generally doesn't provide anything interesting. To get interesting information, money will must be paid. The free searches don't provide considerably more than what may be found through the phone directory. The reverse phone detective search tool does work, but you should use just the service that I posted above. The last thing you want to do, is pay for a service and find the numbers you want to lookup are not available in their directory. The service that I reccomend doesn't have any kind of problem, you won't get any bad surprise! • Tell us some more • Upload in Progress • Upload failed. Please upload a file larger than 100x100 pixels • We are experiencing some problems, please try again. • You can only upload files of type PNG, JPG, or JPEG. • You can only upload files of type 3GP, 3GPP, MP4, MOV, AVI, MPG, MPEG, or RM. • You can only upload photos smaller than 5 MB. • You can only upload videos smaller than 600MB. • You can only upload a photo (png, jpg, jpeg) or a video (3gp, 3gpp, mp4, mov, avi, mpg, mpeg, rm). • You can only upload a photo or a video. • Video should be smaller than 600mb/5 minutes • Photo should be smaller than 5mb •. Activating a prepaid phone on Page Plus is easy and free if you port your number! Click to get started. Activate a cellphone that is currently inactive to begin using service on the device. Two types of cellphone technology exist: CDMA, or phone that don't use SIM cards. Register for your Instant Account Access. Complete the information below to Register on Union Bank of India Credit Card Net Banking to view your account information. Its Simple and a good thing about UNION BANK NET BANKING and PNB NET banking is that it will start working instantly, unlike sbi and few other banks in which. Feb 10, 2010 i am in india having union bank of india ACC.how to activate INTERNET BANKING AND MOBILE BANKING facilities What is the difference betwen INTERNET BANKING. Union Bank of India offers “U-Mobile”- the mobile banking facility that will help you do banking transactions using your mobile phone. Features: * No charges - Absolutely FREE * User friendly interface with touch screen UI support * Download signup and start the using U-Mobile * Secure way of doing transaction anytime. Union Bank Of India - Internet Banking FAQs & Guidelines What is Self User Creation? Union Bank of India has facilitated its customers (Debit Card Holders) to Register Online for Retail Internet Banking Services. They can opt for Only View or View & Transaction facility of Retail Internet Banking Services. Customers can use this online facility from anywhere through Internet without any hassle. Customers are not required to visit the branches for Retail Internet Banking Registration. Customer can register himself only once for one Debit Card. Accounts, which are already registered for Retail Internet Banking Services, can not be registered again. FIVE MUST for Self User Creation • Debit Card number & Debit Card PIN number. • Account Number (Which is linked to your Debit Card). • Date of Birth or PAN number (Either should be available for the above account at branch). • Details of any 1 out of last 5 transactions for above account. • Your mobile number & e-mail id should be present for above account at branch ( one time activity). How do I do Self User Creation online? • Click ' link on Net-Banking website (). Enter the followings. • Debit Card number, PIN number (Enter from Virtual KeyBoard) & 15 digit Account Number • Date of Birth or PAN Number (one of the two is mandatory). • Amout of any 1 out of last 5 transactions for the account. 500, you have to put 500 in Rupee & 00 in Paise field. • Select the Debit or Credit option for the above transaction details. • You can select “View Only” or “View & Transaction” facility. • If all data entered are correct, then you will be displayed your User ID, Name. • If you continue, you will be asked to put the Login / both Login & transaction passwords as per your facility selection. • You can access Internet Banking Services after 2 working days. How secure is this online Process? You can use Virtual Keyboard for entering your information to ensure utmost security from Key loggers. Data pass through 128-bit encrypted Secured Layer. Multiple validations take place at ATM switch, Bank records and Internet Banking end. If wrong PIN entered for 3 times the Debit Card gets blocked for the day & gets activated automatically next day. You will get SMS and e-mail after creating Internet Banking User Id & Password(s). For any query contact our Call Centre - 1800 22 22 44. Copyright © Union Bank of India. Symantec takes the security and proper functionality of our products very seriously. As founding members of the Organization for Internet Safety (OISafety), Symantec supports and follows the principles of responsible disclosure. Symantec also subscribes to the vulnerability disclosure guidelines outlined by the National Infrastructure Advisory Council (). Please contact if you feel you have discovered a security issue in a Symantec product. A Symantec Product Security team member will contact you regarding your submission. Symantec strongly recommends using encrypted email for reporting vulnerability information to. The Symantec Product Security PGP key can be found at the end of this message. Symantec has developed a Product Vulnerability Response document outlining the process we follow in addressing suspected vulnerabilities in our products. This document is available below. Copyright © by Symantec Corp. Permission to redistribute this alert electronically is granted as long as it is not edited in any way unless authorized by Symantec Security Response. Reprinting the whole or part of this alert in any medium other than electronically requires permission from. Disclaimer The information in the advisory is believed to be accurate at the time of publishing based on currently available information. Use of the information constitutes acceptance for use in an AS IS condition. There are no warranties with regard to this information. Neither the author nor the publisher accepts any liability for any direct, indirect, or consequential loss or damage arising from use of, or reliance on, this information. Symantec, Symantec products, Symantec Security Response, and are registered trademarks of Symantec Corp. And/or affiliated companies in the United States and other countries. All other registered and unregistered trademarks represented in this document are the sole property of their respective companies/owners. Initial Post on: Thursday, 25-May-06 23:20:00 Last modified on: Wednesday, 07-Feb-07 15:19:43. May 23, 2009 I used Norton Internet Security. Norton Security, Norton Security Deluxe, what's next. NIS, Norton Security, Norton Security Deluxe. In conclusion, we have developed an alternative promoter system for thioglycoside activation, NIS/AW-300 MS. Protoc., 1 (2006), pp. Dec 01, 2006 I had NIS 2006 since last December and the subscription is due to expire shortly. I bought another NIS 2006 from Scan two weeks ago. The problem is. Norton Internet Security. Norton has known about this bug since January 2015 and still hasn't released a patch. Are N360/NIS/NAV Being Auto-Upgraded to NS. I'm talking about the problems that are posted here. I can't possibly mention all of them, but some specific cui problems that I'm having are: button images disappearing, including standard autocad images, not just custom buttons; button images shown in the list being 'not available', even though it's right there in the list; and toolbars rearranging all over the place when making a new toolbar. All of these problems can be found posted by other users here, plus a large number of other problems. Autocad is the only program I have that requires me to trouble shoot it, rather than the company that made it. Very frustrating, especially when the bosses question why we paid so much for something that requires me to spend large amounts of unbillable time to figure out why it doesn't work. Wrote in message news:[email protected]. I'm talking about the problems that are posted here. I can't possibly mention all of them, but some specific cui problems that I'm having are: button images disappearing, including standard autocad images, not just custom buttons; button images shown in the list being 'not available', even though it's right there in the list; and toolbars rearranging all over the place when making a new toolbar. All of these problems can be found posted by other users here, plus a large number of other problems. Autocad is the only program I have that requires me to trouble shoot it, rather than the company that made it. Very frustrating, especially when the bosses question why we paid so much for something that requires me to spend large amounts of unbillable time to figure out why it doesn't work. -------------------------------------------------- Ok, I haven't experianced any of those CUI problems yet, but I must admit I haven't used the interface that much. So what are the other problems (non-CUI) that you referred to in your original post? ~nods~ MAP 2005 was a bit buggy. But, once I installed the service packs all was cool. (of course, my communication center thingy never worked, so I had to hear others talking about the SP before I knew it was available and to go download it) 'Jim Dory' wrote in message Admittedly this is in Map but just a few posts ago I posted 'unhandeled exception in CUI' here and on the map 3d 2006 group with no replies. Appreciate it if someone could help trouble shoot. I found 2005 to be too buggy to use (mostly the selection tool- clicking on an object to highlight it- would quit working so I never went much further with it). I get pretty irritated that software that is so expensive to purchase and keep current doesn't work. I'm also plenty aware that other people don't have similar problems so will not place all blame on autodesk - just a heap of it. Anyway, I still have 2004 and it works pretty flawlessly for me so I will just curse autodesk and keep using 2004. Wrote in message news:[email protected]. I'm talking about the problems that are posted here. I can't possibly mention all of them, but some specific cui problems that I'm having are: button images disappearing, including standard autocad images, not just custom buttons; button images shown in the list being 'not available', even though it's right there in the list; and toolbars rearranging all over the place when making a new toolbar. All of these problems can be found posted by other users here, plus a large number of other problems. Autocad is the only program I have that requires me to trouble shoot it, rather than the company that made it. Very frustrating, especially when the bosses question why we paid so much for something that requires me to spend large amounts of unbillable time to figure out why it doesn't work. I think I see what you mean now - working with a clean install of LDT2006, every time I open CUI, edit a partial menu, and press OK - I get this...... AutoCAD menu utilities loaded.; error: Exception occurred: 0xC0000005 (Access Violation); warning: unwind skipped on exception; error: Exception occurred: 0xC0000005 (Access Violation); error: Exception occurred: 0xC0000005 (Access Violation); error: Exception occurred: 0xC0000005 (Access Violation)......and AutoCAD vanishes from the desktop:-0. This is a 'problems' website, what do you expect to see around here. Are we talking plain AutoCAD, or a vertical version? ADT2006, plain 2006 and LT2006 I had no problems with, the last two I did a lot of menu changes and customizations with no issues posted around here. This CUI is very new and different, I suspect most of the common issues will be resolved as everyone discovers then solves them permanently over time, just in time for R2007. -- Dean Saadallah Add-on products for LT. Wrote in message news:[email protected]. >> This is probably the last time I'm posting anything here, >> because this seems to be turning into a chat room instead >> of a place to solve problems. Re-reading your original post, you never asked anyone to help 'solve a problem'. Any word on when a patch will be avilable for 2006? It is apparent by the number of problems posted here that a patch better be on the way soon, especially to fix all of the cui problems. You asked in a peer to peer newsgroup when a patch will be available. You stand a much better chance of getting a reliable answer by asking your dealer or checking the Autodesk website. Applies To: Office for business Office 365 Admin Office 365 Small Business Office 365 Small Business Admin Internet Message Access Protocol (IMAP) is a protocol that allows you to download messages from a mail provider's servers, such as those for Gmail, onto your computer so you can use Microsoft Outlook to view and edit your email, even when aren't connected to the Internet. Enable IMAP on for your Gmail account To make your Gmail messages accessible by Microsoft Outlook, you need to enable it for IMAP. • Sign in to your Gmail account by using a browser that is supported (Google Chrome, Firefox, Internet Explorer, or Safari). • Choose or click the gear icon ( ) on the top right. • Choose Settings > Forwarding and POP/IMAP. • Select Enable IMAP, and then choose Save Changes. Table of Contents • • • • Steps to Configure Zoho Mail account as IMAP in Outlook • Log in to your account to. (Login to www.zoho.com/mail >> Settings >> Mail Accounts >> IMAP Access >> Enable IMAP Access by clicking the checkbox). • Launch the Microsoft Outlook application in your system. • Click File and select Add Account. • Locate and select ' Manual setup or additional server types', and click Next • In the ‘ Choose Service’ page, select 'POP or IMAP', and click Next. • In the ' Add Account' page, provide the following details: • User Information • Your name: Your preferred display name. This will be used in the emails you send from Outlook. • Email address: Your Zoho account email address ([email protected] or email aliases for organization accounts or [email protected], if you have a personal account) • Server Information: For specific configuration related to your account, check section. • Select IMAP from the Account Type menu. • Incoming server: imappro.zoho.com - for organization accounts (if your domain is hosted with Zoho). • Incoming Server: imap.zoho.com - for personal accounts (if you have a personal @zoho.com account) • Outgoing Server: smtp.zoho.com • Logon Information: • Username – The email address of your Zoho account ([email protected] for Email Hosting users / [email protected] for personal users). • Password – Zoho Account Password (Use if Two-Factor Authentication is enabled for your account.) • Ensure that ' Remember Password' is checked, and click More Settings. • Outgoing Server tab: Select My outgoing server (SMTP) requires authentication and ensure that Use same settings as my incoming server is checked • Select the Advanced tab and configure the Settings as follows: • Incoming Server (IMAP): 993 • Select SSL from the drop down menu for encypted connection. • In Outgoing Server, Select SSL from the drop down for the encrypted connection. • Outgoing Server (SMTP): 465 • Click OK • You will be redirected back to the 'Add New Email Account' section. • Click Test Account Settings to check the configuration info. • When the tests are successful, Outlook will display a popup as shown below. If you see any errors, check the troubleshooting section. Specific Instructions for Outlook IMAP Sent Items By default, our SMTP Servers automatically place sent emails in the Sent folder. However, when you send an email with Outlook, it also saves another copy in your Sent folder there. To avoid duplicates in the Sent folder, change the following settings: In Zoho Mail: You can turn off the copy created by the server in the SMTP settings. Refer for instructions. However, you can also change the settings in the email client you use. In Outlook 2007: • From the Tools menu, select Options and then Preferences • Choose Email Options and uncheck Save Copies of messages in Sent Items folder. In Outlook 2010: • Select your Zoho account from the Account Settings menu and click Change • Choose More Settings, click Sent Items and select, Do not save copies of sent items. Downloading full messages By default, Outlook downloads just the Sender, Subject, and the Date Information (headers) when syncing email. Jul 30, 2013 This tutorial is aimed at Melb PC Users who are migrating from the old Melb PC webmail to the upgraded Microsoft-hosted system. To replay this video demo. As part of the Microsoft Office Suite, Outlook serves as the primary email program for many companies. However, if your business has its own email system or you would. Did you remove the account in Outlook. In order to re-activate a Microsoft account. Accidently closed my hotmail account, dont care about the mail. Dec 14, 2017. Your Gmail account can be accessed anywhere using an email app on your phone or by logging on to Gmail.com, but you may prefer to use Outlook to access your email. This tutorial. In order to connect Outlook to Gmail, you'll need to first enable the IMAP connection that Outlook will use. Log in to your. It downloads the full message only when you click on that email. You can change this behavior by changing the Send/ Receive Settings. If you are upgrading to Office 2007 using the upgrade version, you cannot remove Office 2003 since it served as the basis for the Office 2007 upgrade license. Thus, you cannot reuse the Office 2003 license. -- Carey Frisch Microsoft MVP Windows Shell/User --------------------------------------------------------------- 'Kanzil' wrote: I want to upgrade a PC from Office 2003 to Office 2007 and then install the Office 2003 on a different PC. How do I deactivate the Office 2003 license prior to installing on a different PC? I am not using an update version - it is full install of Office 2007. It will be installed on a brand new PC - the old PC with Office 2003 will have the hard drive scratched and given away and the full version of Office 2003 will be installed on a PC that we are retaining. 'Carey Frisch [MVP]' wrote: > If you are upgrading to Office 2007 using the upgrade version, > you cannot remove Office 2003 since it served as the basis > for the Office 2007 upgrade license. Thus, you cannot reuse > the Office 2003 license. > > -- > Carey Frisch > Microsoft MVP > Windows Shell/User > > --------------------------------------------------------------- > > 'Kanzil' wrote: > > I want to upgrade a PC from Office 2003 to Office 2007 and then install the > Office 2003 on a different PC. How do I deactivate the Office 2003 license > prior to installing on a different PC? All you do is uninstall the program, then reinstall it on the other computer. You may have to use the phone activation when you do so. 'Kanzil' wrote in message news:[email protected].:I am not using an update version - it is full install of Office 2007. Jun 25, 2014 I upgrade a user's computer from XP to windows 7 and tried to move the office 2003 and this is what I get. Libre office, here.| 7 replies| Microsoft Office. Apr 24, 2009 'Product has been activated too many times' Attempting to activate over the phone then also. Microsoft OFFICE. In Office 2003 the. I´m trying to activate a Microsoft Office 2003 on a Windows XP SP3 over the phone but when a click on 'I want to activate the software by telephone' nothing happens. More Activate Ms Office 2003 By Phone videos. It: will be installed on a brand new PC - the old PC with Office 2003 will have: the hard drive scratched and given away and the full version of Office 2003: will be installed on a PC that we are retaining.:: 'Carey Frisch [MVP]' wrote::: > If you are upgrading to Office 2007 using the upgrade version,: > you cannot remove Office 2003 since it served as the basis: > for the Office 2007 upgrade license. Thus, you cannot reuse: > the Office 2003 license.: >: > --: > Carey Frisch: > Microsoft MVP: > Windows Shell/User: >: > ---------------------------------------------------------------: >: > 'Kanzil' wrote:: >: > I want to upgrade a PC from Office 2003 to Office 2007 and then install the: > Office 2003 on a different PC. How do I deactivate the Office 2003 license: > prior to installing on a different PC? Sponsored Links. Your Arlo Go camera uses the AT&T network to send pictures and video to your Arlo account in the cloud. You must activate your Arlo Go SIM card before you can use your Arlo Go camera. To activate your Arlo Go SIM card with AT&T: • If you know your AT&T Enterprise Sales account representative, contact them with your Arlo Go SIM ICCID and device IMEI. Both the ICCID and the IMEI display on the label on the bottom of the Arlo Go retail box. • If you don’t know your AT&T Enterprise Sales Contact, but you have an existing AT&T Service or Business Wireless account, call AT&T Mobility Sales & Services using one of the following phone numbers: • Business Support: 866-353-4110 Monday through Friday 8 a.m. Eastern Time • Business Care: 800-331-0500 Monday through Friday 8 a.m. Find great deals on eBay for activate 'at t' prepaid sim card. Shop with confidence. Enter device information. SIM number Need a SIM card? Help for SIM number. Your SIM card number (ICCID number) has 20 digits and begins with 89. Help for IMEI number. Enter this 15-digit number without any spaces or dashes. Service ZIP Code. Help for service zipcode. Get a T-Mobile prepaid sim card to use on your own phone. Activate; Search. If you need a new SIM card: Order at T-Mobile.com or call 1-8 then follow. To 10 p.m. U.S. Eastern Time Saturday and Sunday 8 a.m. Eastern Time • If you do not have an AT&T Service or Business Wireless account, call the AT&T Exclusivity Business Line at 888-296-4561, Monday through Friday 8 a.m. To 7 p.m., U.S. Eastern Time. For more information about setting up your Arlo Go camera, see. CloneCD 5.3.4.0 Crack Plus Serial Key Full Version Download CloneCD 5.3.4.0 Crack is a contraption that you can use to copy the substance from your CDs, paying little regard to the copy affirmation and sort of information that is secured on them. This kind of making PC tasks is especially important for advancing fortifications in barrier you lose or hurt the particular plates.CloneCD 5.3.4.0 Crack is in like path organized to oversee mixed DVDs. Performs 1:1 copies of the substance, while totally insulting any DRM (Digital Rights Management) control that may come toward its. After a short foundation handle, you will see how essential the interface is, fulfilling by both learners and master customers. The standard menu grants you to explore four choices: read to picture narrative (from a source CD), make from picture record (to CD peruser), copy CD (from CD peruser to CD writer), or erase CD. Moreover, you can look at five profiles – sound CD, data CD, diversion CD, blended media sound CD, and guaranteed PC please. The Settings portion of CloneCD gives customers decisions for sounds (for a powerful or failed undertaking; or install a particular sound), attract auto-play for data or sound plates, change bolster size, and others. A log record can in like way be appeared to help you screen the progress made.With everything considered, CloneCD is a respectable device for making CD/DVD fortresses, paying little mind to the way that the substance is encoded or guaranteed by DRM. It beats fragile parts and yields a subjective copy of the fundamental thing without getting enormous naughtiness on structure resources. Is the best instrument to take a gander at and record copy guaranteed plates. You can without a lot of a grow copy data from these copy guaranteed contraptions for more copies. It kept up a wide variety of security sorts like ProtecCD, SecureRom, Laserlock, and SafeDisk et cetera. Distinctive grouped customers continuing on sections are joined into it. CloneCD 5.3.4.0 Keygen is kept up all kind circle picture hotspots for right plate pictures like DVD-RAM, CD, DVD + R Dual Layer, RW, DVD + DVD + RW, DVD-R, et cetera. CloneCD 5.3.4.0 Crack Free download is a wonderful and helpful software in the world.CloneCD 5.3.4.0 patch+keygen allows you. How to Activate? Download the. Is imperative for changing plate pictures on re-attempting talented or editable circles. It is ensured and secure mechanical get-together for make plate picture of support archives and ace data. It won’t left any single record of epic memory programming. CloneCD 5.3.4.0 Crack is quite recently mechanical party which is best for all kind of customers like authorities, home customers, office customers, and learners. Features of CloneCD 5.3.4.0 Crack: • To start with replicating programming that utilizations RAW-Mode. • Makes working 1:1 duplicates onto CD-Rs and CD-RWs. • Increments weak divisions with picked CD essayists. • Impersonates weak divisions with all CD essayists. • Works with CD-ROMs, CD-Rs and CD-RWs. • CloneCD 5.3.4.0 creates Audio CDs that adjustment as per Redbook standard. • Plate picture stipends control over valuable use of introduced media. • Copies from CD/DVD drives, hard-drive or virtual drives Natural UI, making it clear for novices. • Rich choice of preset choices by techniques for default profiles. • Impelled choices for pro clients. • Enduring, energetic and does not require an ASPI driver. • Capable particular support and client mind. • New: Copies DVD-R, DVD-RW, DVD+R, DVD+RW, DVD+R Dual Layer and DVD-RAM. • New: Supports DVD split record picture plots – this strategy works with FAT32 dispenses is flawless with VirtualCloneDrive. System Requirements: • OS: Windows XP, Vista, 7, 8, 8.1, 10. • CPU: Intel Pentium 300 MHz or higher (or corresponding). • Memory: 256 MB open RAM. • Hard Disk Space: 50 MB free space on the hard drive. How To Activate? • the product splendidly. • After Download Remove Your Previous document. • Now restart your pc. • Then open CloneCD utilizing winrar. • Install exe document. • Use break or key make it full version. Video Tutorial: CloneCD 5.3.4.0 Crack Plus Serial Key Full Download From Given Link Below. CloneCD 5.3.4.0 Crack is in like manner prepared to deal with mixed DVDs. It performs 1:1 copies of the substance, while thoroughly disregarding any DRM (Digital Rights Management) control that may come in its direction. After a short foundation handle, you will see how essential the interface is, pleasing by both learners and ace customers. The standard menu grants you to look over four choices: read to picture archive (from a source CD), create from picture record (to CD peruser), copy CD (from CD peruser to CD writer), or erase CD. Also, you can investigate five profiles – sound CD, data CD, preoccupation CD, blended media sound CD, and guaranteed PC amusement. The Settings section of CloneCD gives customers decisions for sounds (for a powerful or failed undertaking; or implant a particular sound), engage auto-play for data or sound plates, change bolster size, and others. A log record can in like manner be appeared to help you screen the progress made. With everything considered, CloneCD is a respectable device for making CD/DVD fortifications, in spite of the way that the substance is encoded or guaranteed by DRM. It beats fragile parts and yields a subjective copy of the primary thing without acquiring huge harm on structure resources. CloneCD 5.3.4.0 Crack Patch Free Download is the best instrument to examine and record copy guaranteed plates. You can without quite a bit of an extend copy data from these copy guaranteed devices for more copies. It maintained an extensive variety of security sorts like ProtecCD, SecureRom, Laserlock, and SafeDisk et cetera. Various diverse customers enduring segments are joined into it. Is maintained all kind circle picture hotspots for exact plate pictures like DVD-RAM, CD, DVD + R Dual Layer, RW, DVD + DVD + RW, DVD-R, et cetera. CloneCD 5.3.4.0 Serial Key is valuable for modifying plate pictures on redoing competent or editable circles. It is ensured and secure mechanical assembly for make plate picture of support archives and expert data. It won’t left any single archive of colossal memory programming. CloneCD 5.3.4.0 Crack is simply mechanical assembly which is best for all kind of customers like experts, home customers, office customers, and learners. CloneCD 5.3.4.0 Crack Highlights: • To begin with copying programming that uses RAW-Mode. • Makes working 1:1 copies onto CD-Rs and CD-RWs. • Increments feeble divisions with picked CD writers. • Impersonates feeble divisions with all CD writers. • Works with CD-ROMs, CD-Rs and CD-RWs. • Creates Audio CDs that change in accordance with Redbook standard. • Plate image grants control over useful usage of installed media. • Copies from CD/DVD drives, hard-drive or virtual drives. • Natural UI, making it straightforward for tenderfoots. • Rich decision of preset decisions by methods for default profiles. • Impelled options for ace customers. • Enduring, brisk and does not require an ASPI driver. • Capable specific support and customer mind. • New: Copies DVD-R, DVD-RW, DVD+R, DVD+RW, DVD+R Dual Layer and DVD-RAM. • New: Supports DVD split record picture outlines – this game plan works with FAT32 allocates is immaculate with VirtualCloneDrive. Step by step instructions to Activate CloneCD 5.3.4.0 Crack: • records from the given connection. • Separate every one of the documents. • Introduce the setup and open the program. • Open the License key document and duplicate from it. • Utilize this key into initiation tab of the program to enact. • You are finished. Appreciate full form. Framework Requirements: • OS: Windows XP, Vista, 7, 8, 8.1, 10 • CPU: Intel Pentium 300 MHz or higher (or proportional) • Memory: 256 MB accessible RAM • Hard Disk Space: 50 MB free space on the hard drive. Video Tutorial For Your Help: CloneCD 5.3.4.0 Crack Serial Keygen Full Version Free Download From Given Below. 228 Verizon Activation Number Djbackup, 800 Number To Activate Verizon Phone Version Free, Activate A Verizon Cell Phone Free Blogspiano, Prepaid Phone Activation Verizon Musicsgh, Activate A Verizon Cell Phone Free, Cellphone Activation Software Free Withfilecloud, Activation Fee For Verizon Prepaid Phones Drivers Welcome, How To Activate A Verizon Phone Apps Directories, How Do I Activate My Verizon Wireless Prepaid Phone, Verizon Iphone Activation Ssn Zip500x500 Smartphone Soon, 2018 is coming soon. A fresh year will often also be invaded new smartphones of. So, what features whiz that would be the trend next year? Sep 21, 2017. Verizon Wireless allows you to bring your own device or purchase one of their phones to use on their prepaid plans. How to activate your Verizon prepaid cell phone depends entirely on whether or not you bring your own device. Online Activation. The first step of the prepaid activation process is to. Whenever you upgrade a phone on a Verizon Wireless. How to Activate a New Phone on an Existing Verizon. And manually activate it using its ESN or MEID number. How do I activate my new phone? Their Toll Free Activation Number. IPhone both with Apple and with Verizon Wireless. The previous number that. If 2 yrs earlier a smartphone with a large screen (above 5 inches) dominate industry, now the smartphone with a full screen barely bezel (bezeless) and double cameras precisely the absolute most sought by many people. In reality, these technology trends are just present via premium smartphones directed at the top of class. So to say, the premium-grade smartphone market still dominates this trend. So, whether smartphone technology trends this season will continue sustainable in 2018? Can it be entry-level Will smartphones also follow an identical trend? See how big is industry with the trend, it's no wonder many leading vendors intensively introduce this feature on its flagship. Just say it iPhone X, Samsung Galaxy Note 8, Google Pixel 2, Oppo F5, Vivo V7 Plus, and several others. Smartphone trend during the lastyear it does conical to a number of advanced features. We will review for you personally 6 Technology that Will Become Trend in 2018 1. Middle-Class Will Using Bezeless Screen Bezeless is the largest trend that gets attention throughout 2017. It 's not impossible smartphone screen trends bezeless (with a 2: 1 screen ratio or 18: 9) will continue within the next year. However, if this year the screen bezeless only comes through the premium class, next year bezeless smartphone screen actually be present in the segment medium. Unfortunately not disclosed which manufacturer will carry the bezeless screen in the middle class. But if discussing the rumors that circulated, one of the alleged players is Samsung. Known, the tech giant origin of Ginseng Country is definitely preparing some classes medium, Galaxy A5, that is rumored to be carrying the display bezeless display Galaxy S8 Galaxy S8 and Note 8. So, besides Samsung, will there be another vendor who's also preparing an identical step? You will find definitely some, so people think next year 's full-screen smartphone is not just expensive. USB Type-C Herry also said, may well be more new smartphones that come with a USB Type-C port in 2018. This indicates Micro-B or 2.0 USB port will not be considered a trend. 'That may inevitably be some or possibly many smartphones come with a Type-C USB port. USB type this 1 many usefulness and needless to say better as opposed to Micro-B ', such as USB Type-C may be used in alternating position, distinctive from 2.0 which can only be used in the up position. Furthermore, USB Type-C is also claimed to be faster to greatly help document transfer process and can charge faster, though not supported by Fast Charging capabilities. Face Recognition Fingerprint scanner was no further considered as a sophisticated feature on the smartphone. In reality, this feature had become a development over the last few years. IPhone 5s arguably become pioneers. Then, that trend will replace the fingerprint is none besides facial scan feature aka Face Recognition, or also often called facial scanning. This feature once was adopted in several premium classes released in 2017, some on we suggest to them like iPhone X and Samsung Galaxy Note 8. Face Recognition can also be present on middle-class smartphones, like the Oppo F5 and Vivo V7. 'It is not the possible way of opening the smartphone screen with the face may be the trend of many vendors in preparing new products with this technology within the next year. Dual DSLR Dual Camera These are dual cameras which have end up being the trend of smartphone 2017, this trend will continue for quite some time forward, as well as in the long term. 'The configuration is exactly like the Samsung Galaxy Note 8 or some other series with two dual cameras, one lens for telephoto mode, and another a wide-angle. With your capabilities, the captured photo effects will result in professional camera shooting like DSLR or mirrorless. Bye-bye 3.5mm Jack Headphone! The lack of a 3.5mm headphone jack hole will also be a popular trend. In fact, this really is already done Apple on the iPhone 7 and 7 Plus since 2016 ago. 'It took a long time for many vendors to finally get it follow Apple 's 'footsteps 'to remove the headphone hole on its newest product. In 2017 also already exist some, such as for example Pixel 2, Xiaomi Mi 6, HTC U11. Later, the newest smartphone with out a 3.5mm headphone jack hole will rely on wireless technology. Not impossible, some that would follow Apple 's release step special wireless earphones for iPhone without headphone jackholes. Without Home Button Combined with the bezeless trend, the physical home button is predicted to be lost on the most recent smartphone lineup in years front. Instead, the smartphone screen might be embedded fingerprint to open the screen. 'iPhone X already first, but he 's counting on FaceID (face scanning technology). Some are among smartphone vendors will likely follow Apple. Vivo has also introduced Under Display Fingerprint Scanning technology right. So this smartphone won't use the physical home button, open the smartphone just need to touch the screen, '.Thus, without the home button, the smartphone will in truth have the screen intact. For alternatives open the screen, users can take advantage of features Face Recognition, Iris Scanning, and embedded fingerprint directly below the screen in Vivo. On this amazing site we display some, and will also review Plus Minus iPhone possible it will also be helpful for you for extra information. IPhone is a revolutionary phone by Apple Inc., and the first generation began to be marketed on June 29, 2007 in America, priced at the US $ 499 for 4GB model and the US $ 599 for 8GB model. The next generation was named iPhone 3G, was launched in many countries on July 11, 2008, priced at the US $ 199 for the 8GB model and the US $ 299 for a 16GB model. While the third generation called iPhone 3GS appeared on June 17, 2009, the price tag on US $ 199 for 16GB model and the US $ 299 for the 32GB model. IPhone Specs How may be the specification? The iPhone camera includes a capacity of 2-megapixel resolution for the very first generation iPhone and iPhone 3G, and 3.2 megapixels for iPhone 3GS. However, iPhone debutants and 3G do not need to record capabilities video, except by making use of the extra software. You will find about 100 thousand applications that can be placed on iPhone latest product. This app is sold on iTunes computer or in the Apps Store. IPhone users can also buy and download apps within the Apps Store directly provided only 10MB. The os on the iPhone uses a lightweight version of Mac OS X that is practical, without the 'junk components '. The device occupies about 250MB space. The operating-system could be updated periodically via iTunes for free. Gadgets which can be touted as 'The Smartest Phone 'isn't suddenly famous as, however it took no time since the initial iPhone was launched. The 2nd generation of iPhone is spread to many states on July 11, 2008, and priced the US $ 199 for 8GB models and the US $ 299 for the 16GB model. Generation third or also referred to as iPhone 3GS, thrown in to the gadget market on June 17, 2009, be valued price US $ 199 for model 16GB and the US $ 299 for the 32GB model. IPhone 3G is quite popular among gadgets in differing of the world. With a number of additional applications, this Apple product directly becomes the closest competitor Blackberry in the class of smartphones. However, the iPhone 3G has some shortcomings, ie incapable of perform cut and paste operations. Though it appears simple, editing is important. After iPhone 3G features to grab and copywriting disappears in this gadget. Additionally, the iPhone also does not need MMS facilities. Of course, this problem is difficult Apple users, because, without MMS, gadgets cannot send photos or pictures directly. Besides that, iPhone also does not need the capability to record video. As a device that's a degree of outer sophistication ordinary, the shortcoming to record video is extremely strange. Another drawback, when the center iPhone users using apps like Twitter or instant messaging, iPhone owners cannot read inbox messages on a regular basis concise and fast. Yet another, the famous iPhone battery is wasteful. The applications used to cause this gadget quickly go out of energy. While the benefits of Apple iPhone is to really have a revolutionary touchscreen and instantly accompanied by many vendors. However, no one can match the iPhone technology. Additionally, support 3rd Party Apps may also be very much, though not entirely free. Another plus may be the stylish design, in addition to the screen large with very clear picture quality. Excellence iPhone touchscreen technology that utilizes a fresh interface mechanism - also known as multitouch - is really worldwide. Actually, what kind of multitouch on the iPhone? IPhone has super sensitive screen against touch, that will be layered 'capacitive 'material. This causes the screen to differentiate between location and movement constant on multilocation. Since it relies heavily on this 'capacitive 'material, the iPhone screen can only just be active with the touch of the fingertips. That is, the screen is difficult to use if the consumer is utilizing a stylus or wearing a holster nonconductive. Touchscreen on the iPhone will detect touch through a couple of methods which can be 'mutual capacitance 'and self-capacitance '.Through the 'mutual capacitance 'method, the 'capacitive 'circuit uses 2 types the layer material, that is the site for current career paths, and a area for current signal censor sensors. 'Self-capacitance 'utilizes the electrode layer attached to the 'sensor capacitance 'circuit. Both wills send data in the proper execution of electrical pulses to the processor. More information After you have an iPhone, users must register to have AT & T service for phone activation. After active, an individual can illuminate the screen by pressing the tiny button at the bottom of the screen. Four phone icons, mail, safari, and iPod will appear at the bottom of the screen. While on top screen there's a row of icons, which really is a menu hint for numerous functions such as texts, maps, weather, clock, calendar, photo albums, cameras, YouTube, stock reports, notes, and settings. A lot of attractive features which can be added on iPhone, like - for instance - various kinds of games. These various applications may be obtained at Apple 's online store, and most are special apps for iPhone and iPod Touch. Before entering 2018, as a start we shall start discussing Smartphone Flagship will likely Make an Uproar in the beginning of the newest year: 1. Nokia 9 The best type of Nokia Android smartphone range is rumored to be supporting multimedia features. Nokia 9 itself reportedly is likely to be equipped with Qualcomm Snapdragon 835 processor and 4GB RAM and 64GB of internal memory. Supports multimedia, making Nokia 9 is likely to be designed with dual-camera Carl-Zeiss and 12MP resolution. Of Nokia also consider the 4K video features that are mandatory for the upcoming 2018 guys. Nokia 6 (2018) Underneath there is an upgrade from the Nokia smartphone range. Nokia 6 (2018) reportedly will use the screen contemporary with a rate of 18: 9 and is supposed for the mid-end class market with affordable prices. In this line, Nokia reportedly will contend with Xiaomi and Motorola who have been fighting in this market. Nokia 6 (2018) use Snapdragon 630 and supported with 4GB of RAM and 32GB of internal memory. Samsung Galaxy S9 and Galaxy S9 + The flagship smartphone certainly provides a different experience to its users. Samsung Galaxy S9 and Galaxy S9 + was reported provides some updates. Includes the use of the most recent Qualcomm Snapdragon processor 845. The improvement is the usage of dual vertical cameras on the back. Fingerprint problem in the earlier generation will undoubtedly be fixed. Samsung Galaxy S9 and Galaxy S9 + will put it on camera so easy to reach. OnePlus 6 Just released OnePlus 5T, don't make brand smartphone origin China stop innovation. As known, OnePlus 5T is already using the 18: 9 ratio screen and will continue on OnePlus 6. The headlines can be OnePlus 6 will utilize the best processor Qualcomm Snapdragon 845. Obviously, the performance of the gameplay will increasingly fast. Xiaomi Mi 7 Xiaomi Mi 7 became probably the most anticipated smartphone in 2018 by netizens. Since this smartphone is likely to be the first to ever use the Qualcomm Snapdragon 845 processor. Uniquely, Xiaomi Mi 7 this can work with a dual camera selfie resolution of each 16MP. With the support of lowlight mode and features bokeh, will Mi 7 contend with another selfie smartphones? Xiaomi Mi Mix 3 Mi Mix Xiaomi smartphone line is built with a beautiful design. Well reportedly Xiaomi Mi Mix 3 already leaked on the net will work with a dual vertical camera setting that looks just as the iPhone X. Xiaomi Mi Mix 3 appears to be released in mid to late 2018. Will you wait for the presence of the smartphone these guys? Xiaomi Redmi Note 5 Xiaomi Redmi Note 5 is expected to be released in January 2018. Just as the line Redmi Note previously, this smartphone uses widescreen supported with a big 4000mAh battery. Xiaomi Redmi Note 5 brings an 18: 9 ratio screen that uses FullHD + resolution (2160 x 1080 pixels). Not even known whether Xiaomi Redmi Note 5 will carry dual camera technology or not. IPhone (2018) iPhone X much discussed in 2017 appears to be the inspiration of Apple 's smartphone in the future. Reportedly Apple will prepare three types of iPhone 2018 with a display of bezel-less and notch which can be characteristic. For cut prices, Apple supplies the iPhone 6.1 with a TFT-LCD screen. While the other two models will using OLED panels of 6.5 inches and 5.8 inches. What do you call her name? Innovation in the smartphone market certainly won't stop until the above things. Obviously, there are lots of more innovations which are increasingly being prepared and kept tight by vendors to surprise smartphone consumers in future. Go To Other Form Welcome to ASP.NET Welcome to ASP.NET Back. >>Application.EnableEvent(True) Application.EnableEventS=true Here is one I use with a double_click event to goto a workbook whose name is typed in a cell. Sub GetWorkbook() If ActiveCell.Value = ' Then Exit Sub workbookname = ActiveCell.Value On Error GoTo OpenWorkbook Windows(workbookname & '.xls').Activate Exit Sub OpenWorkbook: Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen End Sub -- Don Guillett SalesAid Software wrote in message news. > Hello, > > I have an excel addin (.xla) file under excel startup folder (ie, > office11 startup), where I have defined App_WorkbookActivate event. > This macro executes fine when I open the excel file from explorer. But > when I open the file from automation, it does not execute. > The code is as follows, > > Application.EnableEvent(True) > ActiveWorkbook = AllWorkbooks.Open('filename') > ActiveWorkbook.RunAutoMacros(3) > > Any suggestions would help! > > Thankyou.. Activeworkbook is a predefined reference to the workbook that is active. I wouldn't try setting it to anything. The fact that you show that code and say that it works in any situation makes your whole presentation suspect. Of course Don has already pointed out an additional offending line: >Application.EnableEvent(True) -- Regards, Tom Ogilvy ' wrote: > Hello, > > I have an excel addin (.xla) file under excel startup folder (ie, > office11 startup), where I have defined App_WorkbookActivate event. > This macro executes fine when I open the excel file from explorer. But > when I open the file from automation, it does not execute. > The code is as follows, > > Application.EnableEvent(True) > ActiveWorkbook = AllWorkbooks.Open('filename') > ActiveWorkbook.RunAutoMacros(3) > > Any suggestions would help! > > Thankyou. Don Guillett wrote: > >>Application.EnableEvent(True) > Application.EnableEventS=true > > > Here is one I use with a double_click event to goto a workbook whose name is > typed in a cell. > > Sub GetWorkbook() > If ActiveCell.Value = ' Then Exit Sub > workbookname = ActiveCell.Value > On Error GoTo OpenWorkbook > Windows(workbookname & '.xls').Activate > Exit Sub > OpenWorkbook: > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > End Sub > -- > Don Guillett > SalesAid Software > > wrote in message > news. > > Hello, > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > office11 startup), where I have defined App_WorkbookActivate event. > > This macro executes fine when I open the excel file from explorer. But > > when I open the file from automation, it does not execute. > > The code is as follows, > > > > Application.EnableEvent(True) > > ActiveWorkbook = AllWorkbooks.Open('filename') > > ActiveWorkbook.RunAutoMacros(3) > > > > Any suggestions would help! > > > > Thankyou. > > Thanks for your reply. The code looks similar, except for Windows(workbookname & '.xls').Activate What does the above line of code do? I am writing in c++ and I am not sure what is the code equivalent to the above in c++? I understand Workbook activate is executed when workopen is opened. I don't do C++. This is visual basic for applications VBA -- Don Guillett SalesAid Software wrote in message news. Dec 31, 2014. Hello, does anyone know how to enable/disable an Event in an EventTrigger? In the Editor you can switch an event to Off/Runtime-Only/runtime+editor - but i haven't found a way how to disable an event inside an EventTrigger by script. Does anyone know how to do that? I know i can remove them from. Log in using your active account, start to enjoy your active life! Activate Method ().NET. // Keep the current form active by calling the Activate. Which was were incremented in the Button1 control's // click event. > > Don Guillett wrote: >> >>Application.EnableEvent(True) >> Application.EnableEventS=true >> >> >> Here is one I use with a double_click event to goto a workbook whose name >> is >> typed in a cell. >> >> Sub GetWorkbook() >> If ActiveCell.Value = ' Then Exit Sub >> workbookname = ActiveCell.Value >> On Error GoTo OpenWorkbook >> Windows(workbookname & '.xls').Activate >> Exit Sub >> OpenWorkbook: >> Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen >> End Sub >> -- >> Don Guillett >> SalesAid Software >> >> wrote in message >> news. >> > Hello, >> > >> > I have an excel addin (.xla) file under excel startup folder (ie, >> > office11 startup), where I have defined App_WorkbookActivate event. >> > This macro executes fine when I open the excel file from explorer. But >> > when I open the file from automation, it does not execute. >> > The code is as follows, >> > >> > Application.EnableEvent(True) >> > ActiveWorkbook = AllWorkbooks.Open('filename') >> > ActiveWorkbook.RunAutoMacros(3) >> > >> > Any suggestions would help! >> > >> > Thankyou. >> > > > Thanks for your reply. > The code looks similar, except for > Windows(workbookname & '.xls').Activate > What does the above line of code do? > I am writing in c++ and I am not sure what is the code equivalent to > the above in c++? > I understand Workbook activate is executed when workopen is opened.. Wrote: > Don Guillett wrote: > > >>Application.EnableEvent(True) > > Application.EnableEventS=true > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > typed in a cell. > > > > Sub GetWorkbook() > > If ActiveCell.Value = ' Then Exit Sub > > workbookname = ActiveCell.Value > > On Error GoTo OpenWorkbook > > Windows(workbookname & '.xls').Activate > > Exit Sub > > OpenWorkbook: > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > End Sub > > -- > > Don Guillett > > SalesAid Software > > > > wrote in message > > news. > > > Hello, > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > office11 startup), where I have defined App_WorkbookActivate event. > > > This macro executes fine when I open the excel file from explorer. But > > > when I open the file from automation, it does not execute. > > > The code is as follows, > > > > > > Application.EnableEvent(True) > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > Any suggestions would help! > > > > > > Thankyou. > > > > > Thanks for your reply. > The code looks similar, except for > Windows(workbookname & '.xls').Activate > What does the above line of code do? > I am writing in c++ and I am not sure what is the code equivalent to > the above in c++? > I understand Workbook activate is executed when workopen is opened. I am sorry, I did have EnableEvents(True) in my code, it was a typo. And I am coding in c++, so ActiveWorkbook is a object variable in my code. It has nothing to do with the predefined reference. The macro itself that I have defined in the xla file is as follows, Private Sub App_WorkbookActivate(ByVal Wb As Workbook) Application.SendKeys ('%C') Application.Dialogs(xlDialogPrintPreview).Show Dim currentWindow As Window For Each currentWindow In Wb.Windows currentWindow.View = xlPageBreakPreview Next currentWindow End Sub The xla file is in the excel start up folder, so it gets executed when I open the file from explorer. However, when I try to open the file from automation, it does not execute the activate event. I see your deeply engaged with Don in some heavy duty topics, but just for interest, Addins and files in the xlStart directory are not loaded when Excel is started programmatically. -- Regards, Tom Ogilvy ' wrote: > > Don Guillett wrote: > > >>Application.EnableEvent(True) > > Application.EnableEventS=true > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > typed in a cell. > > > > Sub GetWorkbook() > > If ActiveCell.Value = ' Then Exit Sub > > workbookname = ActiveCell.Value > > On Error GoTo OpenWorkbook > > Windows(workbookname & '.xls').Activate > > Exit Sub > > OpenWorkbook: > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > End Sub > > -- > > Don Guillett > > SalesAid Software > > > > wrote in message > > news. > > > Hello, > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > office11 startup), where I have defined App_WorkbookActivate event. > > > This macro executes fine when I open the excel file from explorer. But > > > when I open the file from automation, it does not execute. > > > The code is as follows, > > > > > > Application.EnableEvent(True) > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > Any suggestions would help! > > > > > > Thankyou. > > > > > Thanks for your reply. > The code looks similar, except for > Windows(workbookname & '.xls').Activate > What does the above line of code do? > I am writing in c++ and I am not sure what is the code equivalent to > the above in c++? > I understand Workbook activate is executed when workopen is opened. Is there any way I can have this macro execute when excel is started programatically? Tom Ogilvy wrote: > I see your deeply engaged with Don in some heavy duty topics, but just for > interest, Addins and files in the xlStart directory are not loaded when Excel > is started programmatically. > > -- > Regards, > Tom Ogilvy > > > > > > ' wrote: > > > > > Don Guillett wrote: > > > >>Application.EnableEvent(True) > > > Application.EnableEventS=true > > > > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > > typed in a cell. > > > > > > Sub GetWorkbook() > > > If ActiveCell.Value = ' Then Exit Sub > > > workbookname = ActiveCell.Value > > > On Error GoTo OpenWorkbook > > > Windows(workbookname & '.xls').Activate > > > Exit Sub > > > OpenWorkbook: > > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > > End Sub > > > -- > > > Don Guillett > > > SalesAid Software > > > > > > wrote in message > > > news. > > > > Hello, > > > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > > office11 startup), where I have defined App_WorkbookActivate event. > > > > This macro executes fine when I open the excel file from explorer. But > > > > when I open the file from automation, it does not execute. > > > > The code is as follows, > > > > > > > > Application.EnableEvent(True) > > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > > > Any suggestions would help! > > > > > > > > Thankyou. > > > > > > > > Thanks for your reply. > > The code looks similar, except for > > Windows(workbookname & '.xls').Activate > > What does the above line of code do? > > I am writing in c++ and I am not sure what is the code equivalent to > > the above in c++? > > I understand Workbook activate is executed when workopen is opened. Tom, please feel free to step in and help the OP -- Don Guillett SalesAid Software 'Tom Ogilvy' wrote in message news. >I see your deeply engaged with Don in some heavy duty topics, but just for > interest, Addins and files in the xlStart directory are not loaded when > Excel > is started programmatically. > > -- > Regards, > Tom Ogilvy > > > > > > ' wrote: > >> >> Don Guillett wrote: >> > >>Application.EnableEvent(True) >> > Application.EnableEventS=true >> > >> > >> > Here is one I use with a double_click event to goto a workbook whose >> > name is >> > typed in a cell. >> > >> > Sub GetWorkbook() >> > If ActiveCell.Value = ' Then Exit Sub >> > workbookname = ActiveCell.Value >> > On Error GoTo OpenWorkbook >> > Windows(workbookname & '.xls').Activate >> > Exit Sub >> > OpenWorkbook: >> > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen >> > End Sub >> > -- >> > Don Guillett >> > SalesAid Software >> > >> > wrote in message >> > news. >> > > Hello, >> > > >> > > I have an excel addin (.xla) file under excel startup folder (ie, >> > > office11 startup), where I have defined App_WorkbookActivate event. >> > > This macro executes fine when I open the excel file from explorer. >> > > But >> > > when I open the file from automation, it does not execute. >> > > The code is as follows, >> > > >> > > Application.EnableEvent(True) >> > > ActiveWorkbook = AllWorkbooks.Open('filename') >> > > ActiveWorkbook.RunAutoMacros(3) >> > > >> > > Any suggestions would help! >> > > >> > > Thankyou. >> > > >> >> Thanks for your reply. >> The code looks similar, except for >> Windows(workbookname & '.xls').Activate >> What does the above line of code do? >> I am writing in c++ and I am not sure what is the code equivalent to >> the above in c++? >> I understand Workbook activate is executed when workopen is opened. Sure, in the same code that opens the workbook, open the addin as well. As an alternative, you can load it as an addin, but opening it should have the same effect. -- Regards, Tom Ogilvy 'ksr' wrote: > Thanks. > Is there any way I can have this macro execute when excel is started > programatically? > > > Tom Ogilvy wrote: > > I see your deeply engaged with Don in some heavy duty topics, but just for > > interest, Addins and files in the xlStart directory are not loaded when Excel > > is started programmatically. > > > > -- > > Regards, > > Tom Ogilvy > > > > > > > > > > > > ' wrote: > > > > > > > > Don Guillett wrote: > > > > >>Application.EnableEvent(True) > > > > Application.EnableEventS=true > > > > > > > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > > > typed in a cell. > > > > > > > > Sub GetWorkbook() > > > > If ActiveCell.Value = ' Then Exit Sub > > > > workbookname = ActiveCell.Value > > > > On Error GoTo OpenWorkbook > > > > Windows(workbookname & '.xls').Activate > > > > Exit Sub > > > > OpenWorkbook: > > > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > > > End Sub > > > > -- > > > > Don Guillett > > > > SalesAid Software > > > > > > > > wrote in message > > > > news. > > > > > Hello, > > > > > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > > > office11 startup), where I have defined App_WorkbookActivate event. > > > > > This macro executes fine when I open the excel file from explorer. But > > > > > when I open the file from automation, it does not execute. > > > > > The code is as follows, > > > > > > > > > > Application.EnableEvent(True) > > > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > > > > > Any suggestions would help! > > > > > > > > > > Thankyou. > > > > > > > > > > > Thanks for your reply. > > > The code looks similar, except for > > > Windows(workbookname & '.xls').Activate > > > What does the above line of code do? > > > I am writing in c++ and I am not sure what is the code equivalent to > > > the above in c++? > > > I understand Workbook activate is executed when workopen is opened. > > > > > > >. Thankyou, Can you give me some example code on how to open an addin? Or how to load as an addin? Tom Ogilvy wrote: > Sure, in the same code that opens the workbook, open the addin as well. > > As an alternative, you can load it as an addin, but opening it should have > the same effect. > > -- > Regards, > Tom Ogilvy > > > 'ksr' wrote: > > > Thanks. > > Is there any way I can have this macro execute when excel is started > > programatically? > > > > > > Tom Ogilvy wrote: > > > I see your deeply engaged with Don in some heavy duty topics, but just for > > > interest, Addins and files in the xlStart directory are not loaded when Excel > > > is started programmatically. > > > > > > -- > > > Regards, > > > Tom Ogilvy > > > > > > > > > > > > > > > > > > ' wrote: > > > > > > > > > > > Don Guillett wrote: > > > > > >>Application.EnableEvent(True) > > > > > Application.EnableEventS=true > > > > > > > > > > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > > > > typed in a cell. > > > > > > > > > > Sub GetWorkbook() > > > > > If ActiveCell.Value = ' Then Exit Sub > > > > > workbookname = ActiveCell.Value > > > > > On Error GoTo OpenWorkbook > > > > > Windows(workbookname & '.xls').Activate > > > > > Exit Sub > > > > > OpenWorkbook: > > > > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > > > > End Sub > > > > > -- > > > > > Don Guillett > > > > > SalesAid Software > > > > > > > > > > wrote in message > > > > > news. > > > > > > Hello, > > > > > > > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > > > > office11 startup), where I have defined App_WorkbookActivate event. > > > > > > This macro executes fine when I open the excel file from explorer. But > > > > > > when I open the file from automation, it does not execute. > > > > > > The code is as follows, > > > > > > > > > > > > Application.EnableEvent(True) > > > > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > > > > > > > Any suggestions would help! > > > > > > > > > > > > Thankyou. > > > > > > > > > > > > > > Thanks for your reply. > > > > The code looks similar, except for > > > > Windows(workbookname & '.xls').Activate > > > > What does the above line of code do? > > > > I am writing in c++ and I am not sure what is the code equivalent to > > > > the above in c++? > > > > I understand Workbook activate is executed when workopen is opened. > > > > > > > > > > >. I added code to open the addin, but I can't get it to work. Is it sufficient to add code to open the addin or should I make a call to something else? Ksr wrote: > Thankyou, > Can you give me some example code on how to open an addin? Or how to > load as an addin? > > Tom Ogilvy wrote: > > Sure, in the same code that opens the workbook, open the addin as well. > > > > As an alternative, you can load it as an addin, but opening it should have > > the same effect. > > > > -- > > Regards, > > Tom Ogilvy > > > > > > 'ksr' wrote: > > > > > Thanks. > > > Is there any way I can have this macro execute when excel is started > > > programatically? > > > > > > > > > Tom Ogilvy wrote: > > > > I see your deeply engaged with Don in some heavy duty topics, but just for > > > > interest, Addins and files in the xlStart directory are not loaded when Excel > > > > is started programmatically. > > > > > > > > -- > > > > Regards, > > > > Tom Ogilvy > > > > > > > > > > > > > > > > > > > > > > > > ' wrote: > > > > > > > > > > > > > > Don Guillett wrote: > > > > > > >>Application.EnableEvent(True) > > > > > > Application.EnableEventS=true > > > > > > > > > > > > > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > > > > > typed in a cell. > > > > > > > > > > > > Sub GetWorkbook() > > > > > > If ActiveCell.Value = ' Then Exit Sub > > > > > > workbookname = ActiveCell.Value > > > > > > On Error GoTo OpenWorkbook > > > > > > Windows(workbookname & '.xls').Activate > > > > > > Exit Sub > > > > > > OpenWorkbook: > > > > > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > > > > > End Sub > > > > > > -- > > > > > > Don Guillett > > > > > > SalesAid Software > > > > > > > > > > > > wrote in message > > > > > > news. > > > > > > > Hello, > > > > > > > > > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > > > > > office11 startup), where I have defined App_WorkbookActivate event. > > > > > > > This macro executes fine when I open the excel file from explorer. But > > > > > > > when I open the file from automation, it does not execute. > > > > > > > The code is as follows, > > > > > > > > > > > > > > Application.EnableEvent(True) > > > > > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > > > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > > > > > > > > > Any suggestions would help! > > > > > > > > > > > > > > Thankyou. > > > > > > > > > > > > > > > > > Thanks for your reply. > > > > > The code looks similar, except for > > > > > Windows(workbookname & '.xls').Activate > > > > > What does the above line of code do? > > > > > I am writing in c++ and I am not sure what is the code equivalent to > > > > > the above in c++? > > > > > I understand Workbook activate is executed when workopen is opened. > > > > > > > > > > > > > > >. Workbooks.Open 'C: MyFolder Myfile.xla' here is some code by Dana De Louis that loads the solver addin. If you want to load the addin, then you can parts of this code as an example. Sub SolverInstall() '// Dana DeLouis Dim wb As Workbook On Error Resume Next ' Set a Reference to the workbook that will hold Solver Set wb = ActiveWorkbook With wb.VBProject.References.Remove.Item('SOLVER') End With With AddIns('Solver Add-In').Installed = False.Installed = True wb.VBProject.References.AddFromFile.FullName End With End Sub -- Regards, Tom Ogilvy 'ksr' wrote: > Thankyou, > Can you give me some example code on how to open an addin? Or how to > load as an addin? > > Tom Ogilvy wrote: > > Sure, in the same code that opens the workbook, open the addin as well. > > > > As an alternative, you can load it as an addin, but opening it should have > > the same effect. > > > > -- > > Regards, > > Tom Ogilvy > > > > > > 'ksr' wrote: > > > > > Thanks. > > > Is there any way I can have this macro execute when excel is started > > > programatically? > > > > > > > > > Tom Ogilvy wrote: > > > > I see your deeply engaged with Don in some heavy duty topics, but just for > > > > interest, Addins and files in the xlStart directory are not loaded when Excel > > > > is started programmatically. > > > > > > > > -- > > > > Regards, > > > > Tom Ogilvy > > > > > > > > > > > > > > > > > > > > > > > > ' wrote: > > > > > > > > > > > > > > Don Guillett wrote: > > > > > > >>Application.EnableEvent(True) > > > > > > Application.EnableEventS=true > > > > > > > > > > > > > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > > > > > typed in a cell. > > > > > > > > > > > > Sub GetWorkbook() > > > > > > If ActiveCell.Value = ' Then Exit Sub > > > > > > workbookname = ActiveCell.Value > > > > > > On Error GoTo OpenWorkbook > > > > > > Windows(workbookname & '.xls').Activate > > > > > > Exit Sub > > > > > > OpenWorkbook: > > > > > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > > > > > End Sub > > > > > > -- > > > > > > Don Guillett > > > > > > SalesAid Software > > > > > > > > > > > > wrote in message > > > > > > news. > > > > > > > Hello, > > > > > > > > > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > > > > > office11 startup), where I have defined App_WorkbookActivate event. > > > > > > > This macro executes fine when I open the excel file from explorer. But > > > > > > > when I open the file from automation, it does not execute. > > > > > > > The code is as follows, > > > > > > > > > > > > > > Application.EnableEvent(True) > > > > > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > > > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > > > > > > > > > Any suggestions would help! > > > > > > > > > > > > > > Thankyou. > > > > > > > > > > > > > > > > > Thanks for your reply. > > > > > The code looks similar, except for > > > > > Windows(workbookname & '.xls').Activate > > > > > What does the above line of code do? > > > > > I am writing in c++ and I am not sure what is the code equivalent to > > > > > the above in c++? > > > > > I understand Workbook activate is executed when workopen is opened. > > > > > > > > > > > > > > > > >. Thankyou all so very much. I appreciate your help. I got it to work. I open the addin and then open the workbook and the macro executes now. Ksr wrote: > I added code to open the addin, but I can't get it to work. Is it > sufficient to add code to open the addin or should I make a call to > something else? > > Thankyou. > > ksr wrote: > > Thankyou, > > Can you give me some example code on how to open an addin? Or how to > > load as an addin? > > > > Tom Ogilvy wrote: > > > Sure, in the same code that opens the workbook, open the addin as well. > > > > > > As an alternative, you can load it as an addin, but opening it should have > > > the same effect. > > > > > > -- > > > Regards, > > > Tom Ogilvy > > > > > > > > > 'ksr' wrote: > > > > > > > Thanks. > > > > Is there any way I can have this macro execute when excel is started > > > > programatically? > > > > > > > > > > > > Tom Ogilvy wrote: > > > > > I see your deeply engaged with Don in some heavy duty topics, but just for > > > > > interest, Addins and files in the xlStart directory are not loaded when Excel > > > > > is started programmatically. > > > > > > > > > > -- > > > > > Regards, > > > > > Tom Ogilvy > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ' wrote: > > > > > > > > > > > > > > > > > Don Guillett wrote: > > > > > > > >>Application.EnableEvent(True) > > > > > > > Application.EnableEventS=true > > > > > > > > > > > > > > > > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > > > > > > typed in a cell. > > > > > > > > > > > > > > Sub GetWorkbook() > > > > > > > If ActiveCell.Value = ' Then Exit Sub > > > > > > > workbookname = ActiveCell.Value > > > > > > > On Error GoTo OpenWorkbook > > > > > > > Windows(workbookname & '.xls').Activate > > > > > > > Exit Sub > > > > > > > OpenWorkbook: > > > > > > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > > > > > > End Sub > > > > > > > -- > > > > > > > Don Guillett > > > > > > > SalesAid Software > > > > > > > > > > > > > > wrote in message > > > > > > > news. > > > > > > > > Hello, > > > > > > > > > > > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > > > > > > office11 startup), where I have defined App_WorkbookActivate event. > > > > > > > > This macro executes fine when I open the excel file from explorer. But > > > > > > > > when I open the file from automation, it does not execute. > > > > > > > > The code is as follows, > > > > > > > > > > > > > > > > Application.EnableEvent(True) > > > > > > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > > > > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > > > > > > > > > > > Any suggestions would help! > > > > > > > > > > > > > > > > Thankyou. > > > > > > > > > > > > > > > > > > > > Thanks for your reply. > > > > > > The code looks similar, except for > > > > > > Windows(workbookname & '.xls').Activate > > > > > > What does the above line of code do? > > > > > > I am writing in c++ and I am not sure what is the code equivalent to > > > > > > the above in c++? > > > > > > I understand Workbook activate is executed when workopen is opened. > > > > > > > > > > > > > > > > > > >. -- Regards, Tom Ogilvy 'ksr' wrote: > Thankyou all so very much. I appreciate your help. > I got it to work. I open the addin and then open the workbook and the > macro executes now. > > ksr wrote: > > I added code to open the addin, but I can't get it to work. Is it > > sufficient to add code to open the addin or should I make a call to > > something else? > > > > Thankyou. > > > > ksr wrote: > > > Thankyou, > > > Can you give me some example code on how to open an addin? Or how to > > > load as an addin? > > > > > > Tom Ogilvy wrote: > > > > Sure, in the same code that opens the workbook, open the addin as well. > > > > > > > > As an alternative, you can load it as an addin, but opening it should have > > > > the same effect. > > > > > > > > -- > > > > Regards, > > > > Tom Ogilvy > > > > > > > > > > > > 'ksr' wrote: > > > > > > > > > Thanks. > > > > > Is there any way I can have this macro execute when excel is started > > > > > programatically? > > > > > > > > > > > > > > > Tom Ogilvy wrote: > > > > > > I see your deeply engaged with Don in some heavy duty topics, but just for > > > > > > interest, Addins and files in the xlStart directory are not loaded when Excel > > > > > > is started programmatically. > > > > > > > > > > > > -- > > > > > > Regards, > > > > > > Tom Ogilvy > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ' wrote: > > > > > > > > > > > > > > > > > > > > Don Guillett wrote: > > > > > > > > >>Application.EnableEvent(True) > > > > > > > > Application.EnableEventS=true > > > > > > > > > > > > > > > > > > > > > > > > Here is one I use with a double_click event to goto a workbook whose name is > > > > > > > > typed in a cell. > > > > > > > > > > > > > > > > Sub GetWorkbook() > > > > > > > > If ActiveCell.Value = ' Then Exit Sub > > > > > > > > workbookname = ActiveCell.Value > > > > > > > > On Error GoTo OpenWorkbook > > > > > > > > Windows(workbookname & '.xls').Activate > > > > > > > > Exit Sub > > > > > > > > OpenWorkbook: > > > > > > > > Workbooks.Open(workbookname & '.xls').RunAutoMacros xlAutoOpen > > > > > > > > End Sub > > > > > > > > -- > > > > > > > > Don Guillett > > > > > > > > SalesAid Software > > > > > > > > > > > > > > > > wrote in message > > > > > > > > news. > > > > > > > > > Hello, > > > > > > > > > > > > > > > > > > I have an excel addin (.xla) file under excel startup folder (ie, > > > > > > > > > office11 startup), where I have defined App_WorkbookActivate event. > > > > > > > > > This macro executes fine when I open the excel file from explorer. But > > > > > > > > > when I open the file from automation, it does not execute. > > > > > > > > > The code is as follows, > > > > > > > > > > > > > > > > > > Application.EnableEvent(True) > > > > > > > > > ActiveWorkbook = AllWorkbooks.Open('filename') > > > > > > > > > ActiveWorkbook.RunAutoMacros(3) > > > > > > > > > > > > > > > > > > Any suggestions would help! > > > > > > > > > > > > > > > > > > Thankyou. > > > > > > > > > > > > > > > > > > > > > > > Thanks for your reply. > > > > > > > The code looks similar, except for > > > > > > > Windows(workbookname & '.xls').Activate > > > > > > > What does the above line of code do? > > > > > > > I am writing in c++ and I am not sure what is the code equivalent to > > > > > > > the above in c++? > > > > > > > I understand Workbook activate is executed when workopen is opened. > > > > > > > > > > > > > > > > > > > > > > > > >. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |