Loading...

excel-macros@googlegroups.com

[Prev] Thread [Next]  |  [Prev] Date [Next]

Re: $$Excel-Macros$$ Sequentially numbered pictures in Excel 2003 Don Flak Sun Oct 30 20:00:57 2011

Zip file number 2

On Tue, Oct 25, 2011 at 2:57 PM, Sam Mathai Chacko <[EMAIL PROTECTED]>wrote:

> To attach a file, go to your google mail, and check for this message, and
> while doing a reply, you can attach a file as you would normally.
>
> Sam
>
>
> On Tue, Oct 25, 2011 at 5:18 PM, Don <[EMAIL PROTECTED]> wrote:
>
>> 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 <[EMAIL PROTECTED]> wrote:
>> > Dear Don,
>> >
>> > can you share your workbook with Group.
>> >
>> >
>> >
>> >
>> >
>> > On Tue, Oct 25, 2011 at 1:40 AM, Don <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
>> >
>> > > <><><><><><><><><><><><><><><><><><><><><><>
>> > > 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 [EMAIL PROTECTED]
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
>
> ----------------------------------------------------------------------------------
> 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 [EMAIL PROTECTED]
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
----------------------------------------------------------------------------------
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 [EMAIL PROTECTED]

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel