Dear Asa, Actually I want to sparklines also piechart,barchart in single cell in excel 2003 (I Used this version) So I will try it to export only certain chart.There are any option in excel 2003 for sparklines,piechart,barchart in single cell then I will not try to export chart from other file Regards Amar
On Thu, Oct 18, 2012 at 12:23 PM, Asa Rossoff <a...@lovetour.info> wrote: > Hi Amar,**** > > I examined your file, and it seems that ALL of the VBA objects are needed > in your new workbook, even though you are only using certain chart types.* > *** > > ** ** > > Also needed is the icons sheet (which may be hidden) for everything to > work properly.**** > > ** ** > > What MAY be an alternative is to allow it to install itself as an add-in, > by uncommenting the code in the sample workbook's ThisWorkbook module that > says ti will prompt for add-in installation if uncommented. In that case, > you might not have to copy any VBA stuff at all after add-in installation. > **** > > ** ** > > Asa**** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *amar takale > *Sent:* Wednesday, October 17, 2012 10:15 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ VBA Code Related Question**** > > ** ** > > Dear Asa > Excellent Guide me,Thanks very much. I do every steps which you tell me > but why all chart not change when I change value data in Data sheet,there > is any mistek by me > Pls tell me > > Regards > Amar**** > > On Thu, Oct 18, 2012 at 8:30 AM, Asa Rossoff <a...@lovetour.info> wrote:*** > * > > Hi Amar,**** > > In your attached file, there is no VBA code attached to the worksheet > itself, thus there is nothing to copy or move.**** > > **** > > The VBA code in your file (of which there is a lot) is in various other > objects: several standard modules, perhaps 15 or 20 class modules, several > userforms, and the ThisWorkbook module.**** > > **** > > Several ways to copy them:**** > > (1) copy the whole file to a new filename**** > > (2) Open both this file and the new file, hit ALT-F11 to bring up the VBA > editor. Drag and drop the modules you want to your new file (they will be > copied). ThisWorkbook cannot be drag and dropped, but you can highlight > the code in that module, hit copy (ctrl-c), and paste in the corresponding > ThisWorkbook module already in your new file.**** > > (3) Export the VBA modules and objects. Right-click each one you want, > choose "Export File" and save it to disc. Then click on the new workbook's > project. Right click and select "Import File" for each module and object > you want to import.**** > > **** > > Asa**** > > **** > > **** > > **** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *amar takale > *Sent:* Wednesday, October 17, 2012 4:44 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ VBA Code Related Question**** > > **** > > Dear Rajan, > I will try to export VBA code from this excel for line chart but it is not > possible,how to do it? > amar**** > > On Thu, Oct 11, 2012 at 6:18 PM, Rajan_Verma <rajanverma1...@gmail.com> > wrote:**** > > *When you move your worksheet.. your Code written in Worksheet Code > window will automatically move with it ***** > > * ***** > > * ***** > > *Regards***** > > *Rajan verma***** > > *+91 7838100659 [IM-Gtalk]***** > > * ***** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *amar takale > *Sent:* 11 October 2012 6:14 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ VBA Code Related Question**** > > **** > > Hi all Experts, > Can anybody tell me how to export worksheet with VBA code from one sheet > to another sheet.Suppose In my sheet if there are 5 tab & three VBA code > include.If I want to export one tab with VBA code to other new sheet it is > possible? I will try but not possible. > Pls suggest helpful guidance > > Regards > Amar**** > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > **** > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > **** > > **** > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > **** > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > **** > > ** ** > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > **** > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
