How would I do that? I do not see a way to attach it to this post and unfortunately it is not on a web-server only an internal secured data server.
Don On Oct 25, 2:30 am, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: > Dear Don, > > can you share your workbook with Group. > > > > > > On Tue, Oct 25, 2011 at 1:40 AM, Don <donf...@gmail.com> wrote: > > I have a report that is run daily. Every day the end user answers > > among other things, what was yesterdays weather. They answer by > > selecting the appropriate picture and clicking it. My excel workbook > > then uses VBA to copy the appropriate reference picture and pastes it > > in to the daily report. > > > For more than 4 years, everyday when the new picture is pasted excell > > has automatically sequentially numbered the picture next in line. If > > the last picture yesterday was 4,626 todays weather picture becomes > > Picture 4627 as shown in the name box. This had worked for more than > > 4 years. > > > Now it has quit functioning and instead of making the picture a new > > sequentially numbered name, it is retaining the name of the reference > > picture. I only have 30 reference pictures so the names are repeating > > quite often and this is becoming a problem. I need my old unique > > names back and I do not know what has occurred to change how this is > > handled. > > > I did inadvertently open and modify the workbook in Excel 2010 and I > > am afraid it may have overwritten some of the Objects or Properties > > which changed how the pictures are handled. > > > Can anyone please assist me in getting my excel back to assigning > > sequential numbers? > > > Don > > > -- > > > ---------------------------------------------------------------------------------- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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/discussexcel > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>- > Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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/discussexcel