Paul, I intend to open file located in specific Folder each time i open a blank workbook file.This contains Task to be performed and data to be updated each hour based on customer request. Since there are more than 10 Excel file to be updated manually (based on request received from customer and Task completed, in process,yet to start etc, ) i thought a macro would be handy to accomplish my task.
Regards, C.G.Kumar On Mon, Dec 20, 2010 at 7:58 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > For this to work, it must be in EACH Excel file that you wish to open! > > It will not work for "ANY Excel file", but only the ones that contain this > macro. > > Can you explain what it is that you're trying to accomplish? > > Is it for multiple users? or just yourself? > > You could place the file in the XLStart folder > (Excel opens all files in this folder when Excel is launched) > Paul > > > *From:* C.G.Kumar <kumar.bemlmum...@gmail.com> > *To:* richard.m...@gmail.com > *Cc:* excel-macros@googlegroups.com > *Sent:* Mon, December 20, 2010 12:09:29 AM > *Subject:* Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened > > I have used the following code; > > Sub Workbook_Open() > Application.DisplayAlerts = False > On Error Resume Next > Workbooks.Open Filename:= _ > "E:\Documents and Settings\DRIVE\Desktop\Tasks.xls > On Error GoTo 0 > Application.DisplayAlerts = True > > End Sub > > I have made macro security to low & i require this macro to run whenever i > open any excel file. but this is not working.Any suggestion. > > > Thanks & Regards, > > C.G.Kumar > > On Sat, Dec 18, 2010 at 6:53 PM, Richard <richard.m...@gmail.com> wrote: > >> Create a sub called "sub workbook_open" in "this workbook" and call >> your macro. >> >> On Dec 18, 3:34 am, "C.G.Kumar" <kumar.bemlmum...@gmail.com> wrote: >> > I want a macro to run every time when an excel file is opened. >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts