Re: $$Excel-Macros$$ How can I repeat top most data of a column on each page

2011-11-18 Thread Sam Mathai Chacko
Rafique, there is NO file attached. Please revert to the mail from your inbox, and attach the file as you would normally. Sam On Fri, Nov 18, 2011 at 9:33 PM, MRafique Ujjan wrote: > Dear Sorry! I have now attached the file please help me in this > regard. > > Thanks for your quick response. > >

Re: $$Excel-Macros$$ Macro Chart Problem For Stack Exchange Program

2011-11-18 Thread dguillett1
You need to give us much more explanation. What chart, etc. Don Guillett SalesAid Software dguille...@gmail.com From: Renukachari Kasee Sent: Thursday, November 17, 2011 5:17 AM To: ashish koul ; excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro Chart Problem For Stack Exchange Prog

$$Excel-Macros$$ Fwd: How can I repeat top most data of a column on each page

2011-11-18 Thread M.Rafique MRU
Sorry I forgot to attach sheet. Now I have attached the sheet -- Forwarded message -- From: MRafique Ujjan Date: Fri, Nov 18, 2011 at 4:23 PM Subject: How can I repeat top most data of a column on each page To: MS EXCEL AND VBA MACROS Dear Group Members, I am attaching a sampl

Re: $$Excel-Macros$$ How can I repeat top most data of a column on each page

2011-11-18 Thread MRafique Ujjan
Dear Sorry! I have now attached the file please help me in this regard. Thanks for your quick response. M. Rafique Ujjan On Nov 18, 4:46 pm, NOORAIN ANSARI wrote: > Dear Rafique, > > Attachement is missing. > > On Fri, Nov 18, 2011 at 4:53 PM, MRafique Ujjan wrote: > > > > > > > > > > > Dear Gr

Re: $$Excel-Macros$$ Macro Chart Problem For Stack Exchange Program

2011-11-18 Thread Sam Mathai Chacko
Unable to understand the requirement. Please do not assume that the problems can be guessed by the volunteers here. Clear and concise explanation of the requirement will help the developer in providing an expected solution. Sometimes, sharing an example might (will) help. Regards, Sam Mathai Chack

$$Excel-Macros$$ converting excel file into xml file

2011-11-18 Thread P.VIJAYKUMAR
Dear Gurus, Is there any method to convert Excel file into XML format.In some specific software for impotring data .the data should be in xml format only,then only we can import the data.I need any macro method or any thing which converts excel data into XML FILE FORMAT Thanking you all , Regar

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

2011-11-18 Thread Sam Mathai Chacko
Can't comment without looking at the actual files, but hope the workbook you are trying to open is an excel 2003- version, and that you have modified the .xlsm above to xls Sam On Fri, Nov 18, 2011 at 2:02 AM, TAschefler wrote: > Thanks Sam and Paul for the responses. > > I actually found code

Re: $$Excel-Macros$$ Re: Consolidation of file which is in Open office to XL-2007

2011-11-18 Thread Sam Mathai Chacko
Vijay, you may be better off querying at Open Office forums. I fear we are not well versed with that in this forum to provide help (though I hope someone out there can) Regards, Sam On Fri, Nov 18, 2011 at 2:57 PM, vijayKumar wrote: > Guys, Kindly Help asap. > > > On Thu, Nov 17, 2011 at 2:26 P

Re: $$Excel-Macros$$ How can I repeat top most data of a column on each page

2011-11-18 Thread Sam Mathai Chacko
Format your column with a custom format like this 0"-"000"-"0 To repeat top rows, you cannot limit the columns. Entire row can be deleted. To do this, go to page setup, in the Sheet tab, select the rows you want to repeat in the Rows to repeat at top section Also, like NOORAIN said, your att

RE: $$Excel-Macros$$ Need help on Access VBA automating outlook

2011-11-18 Thread Asa Rossoff
Hello kavita, I don't have Outlook 2010 installed, but I checked the Outlook 2010 object reference on MSDN @ and noticed MAPIFOLDER isn't listed at all. At http://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook.map ifolder.aspx it is specified as deprecated, and to use Fol

Re: $$Excel-Macros$$ How can I repeat top most data of a column on each page

2011-11-18 Thread NOORAIN ANSARI
Dear Rafique, Attachement is missing. On Fri, Nov 18, 2011 at 4:53 PM, MRafique Ujjan wrote: > Dear Group Members, > > I am attaching a sample data sheet here. In which following are the > columns > > 1. Union Council > 2. Name of Deh > 3. Name of Village > 4. S. No > 5. Full Name > 6. N.I. C No

$$Excel-Macros$$ How can I repeat top most data of a column on each page

2011-11-18 Thread MRafique Ujjan
Dear Group Members, I am attaching a sample data sheet here. In which following are the columns 1. Union Council 2. Name of Deh 3. Name of Village 4. S. No 5. Full Name 6. N.I. C No 7. Nature of House Now I have entered data in this sheet in thousands of names and hundreds of villages. 1) Now I

Re: $$Excel-Macros$$ Deleting modules

2011-11-18 Thread NOORAIN ANSARI
Dear Shekhar, try this Step.. Select Module-Right click-Remove Module-Press No On Fri, Nov 18, 2011 at 4:23 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Could you please let me know how to delete module? > > Thanks in advance. > > > > Regards, > > Chandra Shekar B > > -

Fwd: $$Excel-Macros$$ VBA from Excel 2003 to 2010

2011-11-18 Thread Chandra Shekar
Hello, Could you please let me know which software did you used to solve this issue. Could you please provide the link of the software Thanks in advance. -- Forwarded message -- From: Chandra Shekar Date: Thu, Nov 17, 2011 at 9:12 AM Subject: Re: $$Excel-Macros$$ VBA from Excel

Re: $$Excel-Macros$$ Re: Consolidation of file which is in Open office to XL-2007

2011-11-18 Thread vijayKumar
Guys, Kindly Help asap. On Thu, Nov 17, 2011 at 2:26 PM, vijayKumar wrote: > Dear Friends, > > Request you to help me on a Query of Open Office Excel. > > The Query is as fallows. > > >1. Can we protect the sheet as we do protect worksheet in XL. >2. Request you to help me in creating a

Re: $$Excel-Macros$$ Indirect formula

2011-11-18 Thread NOORAIN ANSARI
Dear Ankit, Excel INDIRECT function takes a text string and converts this into a cell reference. Excel does not understand the text string "B1" to mean a reference to the cell B1. Therefore, if you extract or build up a reference to a cell or range using text, you will need to use the INDIRECT fu

$$Excel-Macros$$ Re: Macro Chart Problem For Stack Exchange Program

2011-11-18 Thread renuka chari
Plz give me the replay ASAP Thanks On Nov 17, 6:17 am, Renukachari Kasee wrote: > Hi experts can you solve this problem Plzzz i dont know how to > do that i need this ranges into chart axis > > thanks in advance > > *(¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling!! >