$$Excel-Macros$$ @ character in Excel
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 (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ @ character in Excel
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 the dialog boxes. Regards, Saber On Mon, Nov 21, 2011 at 5:09 PM, hemant hemantda...@yahoo.com wrote: 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 (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Saber -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ @ character in Excel
Hi Hemant, Go to FileExcel OptionsProofingAuto 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 hemantda...@yahoo.com wrote: 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 (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Getting External Data using From Microsoft Query
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 name Sam is written in a cell A1 So your query would then change to SELECT [AgeOfCustomer] FROM [DataTable] WHERE [CustomerName] = Range(A1).Value Regards, Sam Mathai Chacko On Mon, Nov 21, 2011 at 12:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sumesh, Please see below link.. http://excelusergroup.org/blogs/nickhodge/archive/2008/11/04/excel-2007-getting-external-data.aspx -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Nov 21, 2011 at 12:34 PM, Sumesh sumeshgopurathin...@gmail.comwrote: Hi, I'm trying to get data from Oracle database using the option From Microsoft Query. This however retrieves data based on the query which remains static, unless it is modified. I want the query to be dynamic. I would like to know how this can be done. For e.g. an input to my query is customer number. The customer number varies. The required customer number is input in a cell in one of the sheets. Is there a way to pick up this input into the SQL query? Hope I'm clear. Thanks in advance for the assistance. Kind Regards, Sumesh -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ help needs to connect form controls to the table
I don't see any remaining doubts! What doubts do you have? Sam On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema shankar.n...@gmail.comwrote: thank you so much sir, if possible pls clarify my remaining doubts. On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko samde...@gmail.comwrote: You have to create a recordset by using the OpenRecordSet command in the CurrentDB Use Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(SELECT * FROM t_main) rst.AddNew 'Add the Payment record rst.Fields(0).Value = txtfileno 'Payment ID rst.Fields(1).Value = txtempname 'W.O. # End Sub Also, your first column has a data type of Number. However, the txtfileno variable contains a string / text value. That will have to be corrected also. I have fixed this in the attached database. Regards, Sam Mathai Chacko On Sat, Nov 19, 2011 at 4:32 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I created a form with MSACcess 2003, I placed a command button on the form for saving the data into the table. But it is throwing an error. Pls check and suggest me solution. -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Paste Special VS Paste Special
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 arsfan2...@yahoo.co.inwrote: Hi, Thank you all. in this case if i want to copy paste only format from 1 workbook to another then how can i achieve that. -- *From:* Venkat CV venkat1@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, 21 November 2011 7:56 AM *Subject:* Re: $$Excel-Macros$$ Paste Special VS Paste Special Hi Hanumant, First one you have copied data from Some other Application(New Window workbook,World..Etc) window and 2nd one Copied from Same window same sheet's That's what it's Showing different Options... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Thu, Nov 17, 2011 at 9:49 PM, hanumant shinde arsfan2...@yahoo.co.inwrote: Hi Friends, i have attached screenshot which has 2 windows for paste special functionality. i wanted to paste only formula but i got 1st window (Left from reader) hence could not do so. can somebody please tell me in what circumstances which window appears. i.e. which window will open when -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * * * * -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday
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 new col then From A To H , actually there is no summry sheet (From K to M ,if u want u can remove the column L(person name ) from summary sheet can add in main database after col F so while macro prepares summry sheet it will be easy for me to get data) i have just shown to u for ref actaully i want it like once i update the database in column A to H , Macro can create the summry sheet based on unique list then send the mail to mail ids (from To in CC fields) Thanks On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Sure Maulik... I just want to know those email ids (which you want to add in CC BCC) are common or they'll be changed with every channel name...?? Regards Deepak On Sun, Nov 20, 2011 at 2:43 PM, maulik desai mauliksde...@gmail.comwrote: Thanks you so much deepak for your effort sorry for late reply becasue i can not able to use Gmail from my office pc i check your file it is working very well just one thing i want to ask u that i want to add some email id on CC BCC can u please help in this that how can i do that. while data pasted to mail body , bottom line of table is not reflected . Request you to please look in small chnages revert Thnaks in Advance.. On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh deepaktheind...@gmail.com wrote: Here it is I developed this code on 2007 platform..I hope it'll work in 2003 as well... Sorry.. I couldn't attached the excel file with my previous post because I's in office at that time can't access to gmail over there... Regards Deepak On Tue, Nov 15, 2011 at 11:32 PM, maulik desai mauliksde...@gmail.comwrote: Hi deepu, Thanks you so much for your reply I have tried to paste the code in module but it not work properly request you to kindly provide me the excel sheet with your macro code but before you send me the file required small changes do not use K M column for Chennel name email address that is given just for information my actual database is from A to G request you to kindly change the macro code accordingly send it back for the other checks also if you want u can create the summary sheet with the help of macro paste it on sheet 2 also for name u can use Column H for the proper output.1 more thing i want to tell you that a have to send mail with our official signature so if u can apply macro logic for the same also it would be very great ful to u. Request you to kindly make the changes resend it for the final check Thanks in Advance thanks for your time support. On Mon, Nov 14, 2011 at 4:10 PM, deepu deepaktheind...@gmail.comwrote: Hi Maulik, Below is the code that you're looking for... Insert a module in your workbook and paste the following code and run it... --- Dim MyArray() As Variant, ListArray() As Variant Dim R As Long, C As Integer, LastRow As Long, i As Long Dim OutObj As Object, EmailObj As Object, EmailBody As String, RecAdd As String Sub PrepareData() 'Assigning values to MyArray LastRow = Sheet1.Range(A6).End(xlUp).Row MyArray = Sheet1.Range(A7:G LastRow).Value 'Assigning values to ListArray LastRow = Sheet1.Range(K6).End(xlUp).Row ListArray = Sheet1.Range(K7:M LastRow).Value For i = LBound(ListArray) To UBound(ListArray) RecAdd = ListArray(i, 3) EmailBody = Hi Application.WorksheetFunction.Proper(ListArray(i, 2)) ,BRP Align=centerFYI...BRBR _ TABLE Border=1, Cellspacing=0, Bgcolor=#EEECE1TR _ TD Bgcolor=#14498A, Align=CenterFont Color=#FFCustomer Name/Font/TD _ TD Bgcolor=#14498A, Align=CenterFont Color=#FFLocation/Font/TD _ TD Bgcolor=#14498A, Align=CenterFont Color=#FFDate/Font/TD _ TD Bgcolor=#14498A, Align=CenterFont Color=#FFSite/Font/TD _ TD Bgcolor=#14498A, Align=CenterFont Color=#FFStatus/Font/TD _ /TR For R = LBound(MyArray) To UBound(MyArray) If ListArray(i, 1) = MyArray(R, 6) Then For C = 1 To 5 EmailBody = EmailBody TR _ TD MyArray(R, 1) /TD _ TD MyArray(R, 2) /TD _ TD MyArray(R, 3) /TD _ TD MyArray(R, 4) /TD _ TD MyArray(R, 5) /TD _ /TR Next C End If Next R Call SendEmail(RecAdd, EmailBody) Next i End Sub Sub SendEmail(ReceiptAdd As String, EBody As String) Set OutObj = CreateObject(Outlook.Application.12) Set EmailObj = OutObj.CreateItem(0) EmailBody = EmailBody
Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....
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 will update the remaining code send u batch mean while your can change the code becasue currenly it is based on batch 1 batch 2 as u mentioned also can i get the progress bar for the same . I must say it is very efficient code thanks for that for now it took 1 or 2 sec to update i hope in real file it will help me also Thanks On Sun, Nov 20, 2011 at 11:17 PM, dguillett1 dguille...@gmail.com wrote: I have gone thru and re-written your code to be more efficient. I see no real need to do with a worksheet change event as it will be fast even with 750 rows. It starts with a clean sheet beginning at row 7 assuming your Batch’s are actually named Batch 1, batch 2, etc. Click to see!! Don Guillett SalesAid Software dguille...@gmail.com *From:* maulik desai mauliksde...@gmail.com *Sent:* Sunday, November 20, 2011 3:21 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Don, Thanks for your reply i am so sorry for late reply acctually i can not able to use gmail from my office pc here i am attaching the Format of my file as requested, kindly check the macro code i want to requce the code size normally it takes 20 to 30 mins currently it has just a dummy data so it will give faster result but acctually on Batch sheet it contains more then 750 rows on a monthly basis Request you to kindly do the needful thanks in advance. On Mon, Nov 14, 2011 at 6:47 PM, dguillett1 dguille...@gmail.com wrote: Attach your file with a reply to this msg. Don Guillett SalesAid Software dguille...@gmail.com *From:* maulik desai mauliksde...@gmail.com *Sent:* Sunday, November 13, 2011 10:31 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Team, I having 1 excel sheet in that i have apply below Sumproduct macro code 72 times to get output on my database (This code is provided by Daniel of this group ) my But my problem is it take about 20 to 30 mins to run the code total 550 row(not fixed) x 72 columns ) what I want that can i get a progress bar which shows me status like 3 outof 72 columns completed or 10%,15% ,30% completed like that also if can help to reduce the code size to work faster Please find below code provided by Mr.Daniel of this group. Thanks in advance Here is an example to replace sheet Batch column K with a macro: Sub test() 'sheet Batch column K With Sheets(Batch) For Each c In .Range(.[A7], .[A65536].End(xlUp)) .Cells(c.Row, 11) = Evaluate(sumproduct((DB!$A$2:$A$46803=Batch!$A c.Row )*(DB!$AP$2:$AP$46803=Yes))) Next c End With End Sub You should run the macro each time you change, add or delete a value in column A; place the following macro in the sheet module : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 And Target.Row 6 Then Cells(Target.Row, 11) = Evaluate(sumproduct((DB!$A$2:$A$46803=Batch!$A _ Target.Row )*(DB!$AP$2:$AP$46803=Yes))) End If End Sub You’ll have to do the same for others formulas. Regards. Daniel *De :* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *De la part de* maulik desai *Envoyé :* mardi 22 février 2011 18:55 *À :* excel-macros@googlegroups.com *Objet :* $$Excel-Macros$$ How to use sumproduct Formula in Macro I having Database with 4Sheets and i have used Sumproduct Formula in many Columns in my database. i have apply the formulas on every columns but the prolem is the file becomes very heavy it take to much time to give the output is there any way to use the samproduct function with the help of macro ** ** sample file attached i am having large database Request you to kindly provide the solution for the same -- Thanks Regards, Maulik Desai 9967363926 -- -- 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 --
Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....
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 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 will update the remaining code send u batch mean while your can change the code becasue currenly it is based on batch 1 batch 2 as u mentioned also can i get the progress bar for the same . I must say it is very efficient code thanks for that for now it took 1 or 2 sec to update i hope in real file it will help me also Thanks On Sun, Nov 20, 2011 at 11:17 PM, dguillett1 dguille...@gmail.com wrote: I have gone thru and re-written your code to be more efficient. I see no real need to do with a worksheet change event as it will be fast even with 750 rows. It starts with a clean sheet beginning at row 7 assuming your Batch’s are actually named Batch 1, batch 2, etc. Click to see!! Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Sunday, November 20, 2011 3:21 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Don, Thanks for your reply i am so sorry for late reply acctually i can not able to use gmail from my office pc here i am attaching the Format of my file as requested, kindly check the macro code i want to requce the code size normally it takes 20 to 30 mins currently it has just a dummy data so it will give faster result but acctually on Batch sheet it contains more then 750 rows on a monthly basis Request you to kindly do the needful thanks in advance. On Mon, Nov 14, 2011 at 6:47 PM, dguillett1 dguille...@gmail.com wrote: Attach your file with a reply to this msg. Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Sunday, November 13, 2011 10:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Team, I having 1 excel sheet in that i have apply below Sumproduct macro code 72 times to get output on my database (This code is provided by Daniel of this group ) my But my problem is it take about 20 to 30 mins to run the code total 550 row(not fixed) x 72 columns ) what I want that can i get a progress bar which shows me status like 3 outof 72 columns completed or 10%,15% ,30% completed like that also if can help to reduce the code size to work faster Please find below code provided by Mr.Daniel of this group. Thanks in advance Here is an example to replace sheet Batch column K with a macro: Sub test() 'sheet Batch column K With Sheets(Batch) For Each c In .Range(.[A7], .[A65536].End(xlUp)) .Cells(c.Row, 11) = Evaluate(sumproduct((DB!$A$2:$A$46803=Batch!$A c.Row )*(DB!$AP$2:$AP$46803=Yes))) Next c End With End Sub You should run the macro each time you change, add or delete a value in column A; place the following macro in the sheet module : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 And Target.Row 6 Then Cells(Target.Row, 11) = Evaluate(sumproduct((DB!$A$2:$A$46803=Batch!$A _ Target.Row )*(DB!$AP$2:$AP$46803=Yes))) End If End Sub You’ll have to do the same for others formulas. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de maulik desai Envoyé : mardi 22 février 2011 18:55 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ How to use sumproduct Formula in Macro I having Database with 4Sheets and i have used Sumproduct Formula in many Columns in my database. i have apply the formulas on every columns but the prolem is the file becomes very heavy it take to much time to give the output is there any way to use the samproduct function with the help of macro sample file attached i am having large database Request you to kindly provide the solution for the same -- Thanks Regards, Maulik Desai 9967363926 -- -- 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
$$Excel-Macros$$ Fwd: Job
-- 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 *Experience required for the Job:* 3 - 6 years *Job Location:* Chennai *Dear Candidate,* Hi, Greetings from HP. We at Hewlett-Packard offer you the best work environment where you can learn, grow and contribute to the success story. Yes, we are back with opportunities for you to make your dreams a reality, make anything possible. HP is hiring SQL DATABASE ADMINISTRATOR for CHENNAI Location. Kindly go through the requirements and revert with your updated resume. Experience: 3 to 6 Yrs LEVEL 2 SUPPORT Work Location : CHENNAI If interested kindly mail across your updated profile to ghulam-mohammed.huss...@hp.com along with following mandatory details: Total Exp: Relevant Exp in Core SQL DBA: Current CTC Expected CTC: Education Qualififcation: Updated Contact No Openness to relocate to CHENNAI: Current Location: Job description You'll be making significant contributions to the overall success of projects, whether the optimum solutions involve people, process or technology. Delivering tremendous differentiated and perceived value to customers, you'll ensure that hp provides them with the best overall service experience in the industry¢¢â€š¬¦not only ensuring that projects run to plan, but also identifying opportunities to provide even greater value through expanded engagements or new consulting opportunities. This will involve working exceptionally closely with customers, sharing knowledge, leveraging hp's experience and knowledge, and driving the creation of structured intellectual capital. SQL Server 2000/2005/2008 (MCDBA/MCTS) certified with exposure to 24*7 Production support. Working Knowledge of Oracle Desired 1. Substative (3- 6 years) experience providing database administration in the following environments - MS SQL Server 2000/2005/2008. 2. Expertise on Installation, Backup, Restores/ refreshes, etc. 3. Must have worked on Log shipping, Replication, DB Mirroring, Migration, performance tuning, Cluster environment and DTS/SSIS. 4. Expertise in mentoring and coaching peers. 5. Ability to deal with conflicting deadlines on a regular basis when managing work packages associated with projects. 6. Proven experience in Database Technologies and able to Architect / Design / implement a DB solution which meet client requirement of High Availability, Performance and Reliability in one or more of the following, Oracle, DB2 UDB, MS SQLServer, Sybase and Informix. 7. Good working knowledge of Windows XP/2000/2003 Operating environments. 8. Ability to utilize various tools to provide system management functions such as: system backup/recovery, code promotion, system monitoring. 9. Ability to perform software upgrades, and apply patches. 10. Ability to formulate overall strategies and support development effort in areas of major difficulties and organizational complexity. 11. Risk awareness is vital. A simple change can have major unintended consequences. 12. University Degree or College Diploma in Information Systems and demonstrated experience in the field of Information Technology. 13. Recognized Leadership/Management skills for working in a stressful environment. GENERAL 1. Risk awareness is vital. A simple change can have major unintended consequences. 2. Exercise judgement and analysis to arrive at recommendations or conclusions. 3. Thorough knowledge of business application, strategic business and I.T. strategic direction and technology disciplines. 4. Excellent verbal and written skills 5. High level of initiative with strong organizational skills. 6. Excellent interpersonal skills and team orientation. 7. Strong leadership and motivating skills 8. Excellent time management skills 9. Ability to make formal presentations 10. Ability to deal with complex technical issues If the positions are irrelevant to you, please help refer your friends who would be interested to be a part of HP. Thanks Regards, Ghulam Md Hussain Hewlett Packard India, Staffing -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * * * -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data
$$Excel-Macros$$ Opening for MIS
-- 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:* 2 - 7 years *Annual Salary of the Job:* 0.0 - 4.0 Lacs *Job Location:* Chennai *Dear Candidate,* Dear Candidate, Urgent Opening with Infosys BPO: Responsibilities Activities Description: Also please fill up the following details - Candidates are expected to be proactive, communicate effectively across levels and drive initiatives independently. SHE/HE will * Participate in business requirements discussions with the different operations teams * Document business requirements * VBA (Visual Basics for Applications) - Excel/Access-based VB Script apps, Outlook macros or mainframe macros based on the business requirements * Testing of macros and other tools * Provide support on operations floors once tools are deployed Skills: * Good understanding of VBA / Excel Macros VB Scripts. * Good Understanding of client-server architecture. * Good Analytical Skills * Good Written Communication Skills * Good Knowledge in MIS * Knowledge on Dot-Net would be an added advantage.. *Qualification - *EXP- *Revalent EXP- * Current CTC - (Fixed) (Variable)___ * Expected CTC - * Notice Period - * Passport Status - *Experience- *Relevant Experience- * Why are you looking for a change from the current company? - Kindly mail me your updated resume with the acceptance of applying for this role at the earliest feasible. Email Id - praja...@absolutehrs.com Thanks Regards, Prajakti Shende Management Trainee Absolute HR International USA. CANADA. INDIA www.absolutehrs.com 'Leadership Through Delivery -- *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * * * -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ help needs to connect form controls to the table
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 samde...@gmail.comwrote: I don't see any remaining doubts! What doubts do you have? Sam On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema shankar.n...@gmail.comwrote: thank you so much sir, if possible pls clarify my remaining doubts. On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko samde...@gmail.comwrote: You have to create a recordset by using the OpenRecordSet command in the CurrentDB Use Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(SELECT * FROM t_main) rst.AddNew 'Add the Payment record rst.Fields(0).Value = txtfileno 'Payment ID rst.Fields(1).Value = txtempname 'W.O. # End Sub Also, your first column has a data type of Number. However, the txtfileno variable contains a string / text value. That will have to be corrected also. I have fixed this in the attached database. Regards, Sam Mathai Chacko On Sat, Nov 19, 2011 at 4:32 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Experts I created a form with MSACcess 2003, I placed a command button on the form for saving the data into the table. But it is throwing an error. Pls check and suggest me solution. -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Re: $$Excel-Macros$$ Deleting modules
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 venkat1@gmail.com wrote: Hi Chandra Sekar, Right Click on Module and Remove module and Click option No,, *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71 * 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 -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * * * * -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com