Hi friends I have a workbook which will automatically create another workbook in XLSTART folder when it is opened for the first time on a computer.
The workbook which is saved in XLSTART folder contains a macro which will 1) Close any workbook with a name ending with ".svi" which is opened with excel without saving any changes to it and without prompting the user. 2) Open the same workbook (name ending with ".svi") using a macro inside another workbook (which is saved in another location; path stored in a registry key) Currently I am using Application.OnTime function (once in a second) to check whether any workbook with a name ending with ".svi" is open. But is there a better way to find out when a workbook with a name ending with ".svi" is opened? I mean is there a direct or indirect method to trigger the macro to run using any events like "Workbook_Open", "Calculate" etc? (I don't want to keep the macro running all the time) Let me also explain why I want to do all these: I have created a random access file with extention "*.svi" which can be opened only using a specific macro (I have good reasons for using a random access file) I want the users to be able to open that file by double clicking on the icon of "*.svi" file (otherwise the same had to be opened only through another workbook containing the macro) I could not think of any other way of doing this. I don't know how to create a new icon for my custom type file. Any help regarding this is highly appreciated Thank you in advance :) Hemant Hegde --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
