Re: $$Excel-Macros$$ Deleting modules

2011-11-21 Thread Chandra Shekar
Hello, Thanks for the reply. can we write code for this & assign to a button. Regards, Chandra Shekar B On Mon, Nov 21, 2011 at 3:19 AM, Venkat CV wrote: > Hi Chandra Sekar, > > Right Click on Module and Remove module and Click option No,, > > *Best Regards,* > *Venkat * > *Chennai* > *My Link

Re: $$Excel-Macros$$ help needs to connect form controls to the table

2011-11-21 Thread Shankar Bheema
Dear Sam How to restrict max length of characters in a text box for MS ACCESS 2003 ? On Mon, Nov 21, 2011 at 9:57 PM, Sam Mathai Chacko wrote: > I don't see any remaining doubts! What doubts do you have? > > Sam > > > On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema > wrote: > >> thank you so m

$$Excel-Macros$$ Opening for MIS

2011-11-21 Thread Venkat CV
-- Original message -- From:""Absolute HR Solutions Pvt. Ltd.""< praja...@absolutehrs.com > Date: 21 Nov 11 11:01:35 Subject: Opening for MIS - VBA/SQL To: The sender of this email is registered with Naukri.com as Absolute HR Solutions Pvt. Ltd. *Experience required for the Job:*

$$Excel-Macros$$ Fwd: Job

2011-11-21 Thread Venkat CV
-- Original message -- From:"Hewlett-Packard India Pvt Ltd"< ghulam-mohammed.huss...@hp.com > Date: 21 Nov 11 16:12:45 Subject: Openings @ Hewlett Packard (HP) for SQL DBA- CHENNAI LOCATION To: The sender of this email is registered with Naukri.com as Hewlett-Packard India Pvt Ltd

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

2011-11-21 Thread dguillett1
Always best to use the actual file. Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Monday, November 21, 2011 10:52 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Don, Thanks you so

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

2011-11-21 Thread maulik desai
Hi Don, Thanks you so much for your response but i just want to tell that actual batch code are not in series like batch 1, batch 2 etc it is based on process & sub process name also based on location & then No so i can say there is no fixed format for the batch code & also give me 1 days time i w

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

2011-11-21 Thread maulik desai
Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids are not common & it is also not based on channel name.its is based on location wise & its always get change so i suggest you to kindly add the new column after G or After M Actaully My Database is from A to G & if u add the n

Re: $$Excel-Macros$$ Paste Special VS Paste Special

2011-11-21 Thread Sam Mathai Chacko
To copy paste a format from one workbook to another workbook, you just need to ensure both the workbooks are open in the same instance of the application. Regards, Sam Mathai Chacko On Mon, Nov 21, 2011 at 10:46 AM, hanumant shinde wrote: > Hi, > > Thank you all. > in this case if i want to copy

Re: $$Excel-Macros$$ help needs to connect form controls to the table

2011-11-21 Thread Sam Mathai Chacko
I don't see any remaining doubts! What doubts do you have? Sam On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema wrote: > thank you so much sir, if possible pls clarify my remaining doubts. > > > On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko wrote: > >> You have to create a recordset by usin

Re: $$Excel-Macros$$ Getting External Data using "From Microsoft Query"

2011-11-21 Thread Sam Mathai Chacko
Sumesh, I believe your question is around how to modify the SQL query to be dynamic so that it can take inputs from a separate string variable or probably a cell. HEre's an example for a simple select statement SELECT [AgeOfCustomer] FROM [DataTable] WHERE [CustomerName] = "Sam" Supppose the nam

Re: $$Excel-Macros$$ "@" character in Excel

2011-11-21 Thread Manish Pandey
Hi Hemant, Go to File>Excel Options>Proofing>Auto Correct Options, there uncheck 'internet and network path with hyperlink'. This will resolve creating hyperlink automatically. Regards, Manish maverickpan...@gmail.com On Mon, Nov 21, 2011 at 5:09 PM, hemant wrote: > Hi i am suppose to enter "@"

Re: $$Excel-Macros$$ "@" character in Excel

2011-11-21 Thread mohd saber
hi, In Excel 2007 1. Click the Office Button, then click Excel Options 2. Click the Proofing category, and click the AutoCorrect Options button 3. On the AutoFormat As You Type tab, remove the check mark from Internet and network paths with hyperlinks 4. Click OK, twice, to close t

$$Excel-Macros$$ "@" character in Excel

2011-11-21 Thread hemant
Hi i am suppose to enter "@" character in coumns. And whenever i enter it, it opens OUTLOOK configuration. How can i enter "@" character and without starting OUTLOOK in Excel 2007. I don't want to change any settings of OUTLOOK. Kindly provide solution. Thanks Hemant Dange -- FORUM RULES (93