$$Excel-Macros$$ Re: Urgent Help Required
Thanks a lot Harmeet... Can u also get me one more functionality here that as soon as one agent acquires the job time and date he acquired also appears and untill he finishes the job by selecting as close which will be a drop down in next column to acquired time column. Once agent uses close from drop down in next column closing time date should also appear. Thanks once again Harish 2009/4/11 Harmeet Singh harmeet.hew...@gmail.com Bingo. See attached file. On Sat, Apr 11, 2009 at 4:35 PM, Harish Sharma harishsharma...@gmail.comwrote: Hi Ashish, Can you please help me with the file attached. I have raw data in first sheet columns B,CD and I have 9 associates to work on this data further but I want now to build a macro where if any agent click on acquire button(will be available in respective agent's sheet) he gets the data (first availabel data in the raw)from raw data sheet in FIFO basis and all the agents will also be working on the sheet together so it would be shared. But the data should not be duplicating and raw data should be protected and once the data is acuired by any agent his name should appear in first column. Thanks in advance -- Kind Regards, Harish Sharma -- Thanks Regards, Harmeet Singh -- Kind Regards, Harish Sharma --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Function to Find the word is in Upper case or lower case or mixed....
Hi, Is there any function to find whether the word entered in a cell is fully in upper case or lower case or in mixed case? Can any one please help me as soon as possible... -- Thanks and Regard ramkumar.m HAVE A NICE DAY FRNDS:) --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Fwd: mACRO HELP
Dear All, Can you please help me write a macro to simplify finding the packing list. The required files are attached for your reference. The tedious job that we do is as under: - Fin`ding the container number PONU7259344 from the daily vehicle entry file an excel file - based on the container number finding from the same file whether this container belongs to which carline (GMDAT TCAR). - Based upon the carline to search in the specific carline folder the packing list. the path is *K:\Warehouse\Mahindra\Tcar Packing list (In this path we have packing list folders for each carlines). The packing list detail is as under :* Invoice no prod_ordr_no cust_ordr_no cont_no case_no art_no part_name pack_qty TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9026 96475810 ENGINE A 4 TMAID85904A01 CAIN5847G002 0844PBP-01 MSKU0708994 X9025 96475810 ENGINE A 4 - On finding the packing list to filter the same paste in a seperate excel sheet. - Setting print margins printing. An easy and simplified way of doing this job will help us save lot of our time, computer as a resource is not available full time. - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Function to Find the word is in Upper case or lower case or mixed....
Well... to answer your EXACT question, there isn't a simple function to do that. (that I know of!) However: If you're wanting a FORMULA, then you can use: =IF(EXACT(A1,UPPER(A1)),Upper,IF(EXACT(A1,LOWER(A1)),Lower,Mixed)) If you're wanting a function: I inserted this function into a Module: Public Function Check_Case(Str As String) If (Str = UCase(Str)) Then Check_Case = Upper ElseIf (Str = LCase(Str)) Then Check_Case = Lower Else Check_Case = Mixed End If End Function hope this helps... Paul From: ram kumar.m ramsk0...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, April 13, 2009 6:12:03 AM Subject: $$Excel-Macros$$ Function to Find the word is in Upper case or lower case or mixed Hi, Is there any function to find whether the word entered in a cell is fully in upper case or lower case or in mixed case? Can any one please help me as soon as possible... -- Thanks and Regard ramkumar.m HAVE A NICE DAY FRNDS:) --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
Hi Harish, First of all, Thanks a lot for appreciation. If now I do the changes that you have mentioned in your mail, will be a spoon feeding. I have not protected the code that I have sent you. It would be a good learning for you if you try and do it by yourself. You just need to write two lines similar to what I used. Let me know if you stuck anywhere. Regards, Harmeet singh. On Sun, Apr 12, 2009 at 11:31 PM, Harish Sharma harishsharma...@gmail.comwrote: Thanks a lot Harmeet... Can u also get me one more functionality here that as soon as one agent acquires the job time and date he acquired also appears and untill he finishes the job by selecting as close which will be a drop down in next column to acquired time column. Once agent uses close from drop down in next column closing time date should also appear. Thanks once again Harish 2009/4/11 Harmeet Singh harmeet.hew...@gmail.com Bingo. See attached file. On Sat, Apr 11, 2009 at 4:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi Ashish, Can you please help me with the file attached. I have raw data in first sheet columns B,CD and I have 9 associates to work on this data further but I want now to build a macro where if any agent click on acquire button(will be available in respective agent's sheet) he gets the data (first availabel data in the raw)from raw data sheet in FIFO basis and all the agents will also be working on the sheet together so it would be shared. But the data should not be duplicating and raw data should be protected and once the data is acuired by any agent his name should appear in first column. Thanks in advance -- Kind Regards, Harish Sharma -- Thanks Regards, Harmeet Singh -- Kind Regards, Harish Sharma -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
One more thing, You can also use shortcuts to enter time/date. *Ctrl+;* to enter date and *Ctrl+shift+;* to enter time. On Mon, Apr 13, 2009 at 7:00 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi Harish, First of all, Thanks a lot for appreciation. If now I do the changes that you have mentioned in your mail, will be a spoon feeding. I have not protected the code that I have sent you. It would be a good learning for you if you try and do it by yourself. You just need to write two lines similar to what I used. Let me know if you stuck anywhere. Regards, Harmeet singh. On Sun, Apr 12, 2009 at 11:31 PM, Harish Sharma harishsharma...@gmail.com wrote: Thanks a lot Harmeet... Can u also get me one more functionality here that as soon as one agent acquires the job time and date he acquired also appears and untill he finishes the job by selecting as close which will be a drop down in next column to acquired time column. Once agent uses close from drop down in next column closing time date should also appear. Thanks once again Harish 2009/4/11 Harmeet Singh harmeet.hew...@gmail.com Bingo. See attached file. On Sat, Apr 11, 2009 at 4:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi Ashish, Can you please help me with the file attached. I have raw data in first sheet columns B,CD and I have 9 associates to work on this data further but I want now to build a macro where if any agent click on acquire button(will be available in respective agent's sheet) he gets the data (first availabel data in the raw)from raw data sheet in FIFO basis and all the agents will also be working on the sheet together so it would be shared. But the data should not be duplicating and raw data should be protected and once the data is acuired by any agent his name should appear in first column. Thanks in advance -- Kind Regards, Harish Sharma -- Thanks Regards, Harmeet Singh -- Kind Regards, Harish Sharma -- Thanks Regards, Harmeet Singh -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Data Extracting from Q Books
Hi how to extract data from a system (Quick Books for non profits ) and automatically update a formatted report (Donor Expense Report) rashid --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Risk Graphs
This is perfect. Thank you so much. On Apr 12, 6:07 pm, Tom Jeffries tjeff...@gmail.com wrote: If you want the y-axis (vertical) to change dynamically check the Auto box on the y-axis scale tab. The x-axis (horizontal) will change automatically based on stock values. The attached spreadsheet creates a simple risk graph for put and call options. If you have any questions let me know. Tom On Fri, Apr 10, 2009 at 9:40 PM, mother tdsimp...@gmail.com wrote: Yes, this is what I am looking for. I guess the X-axis is fixed and cannot dynamically adjust. Now I have to figure out how to do this with an Option (put or call). http://www.optiontradingpedia.com/option_trading_risk_graphs.htm I'm not interested in the option combos, but just one option (put or call). Thanks, On Apr 10, 6:36 pm, Tom Jeffries tjeff...@gmail.com wrote: Take a look at the attached spreadsheet. I think it does what you want. If you have any questions let me know. Tom Jeffries On Fri, Apr 10, 2009 at 8:44 AM, mother tdsimp...@gmail.com wrote: I'm trying to figure out how to create a Simple Risk Graph (profit/ lost diagram) like the one described at Investopedia: http://www.investopedia.com/articles/optioninvestor/05/012605.asp I do not want the add all the extra complexity of stuff. Just a simple/basic Risk Graph. Could someone help me with this? If this is not the correct group to post this to, please recommend a group. Thanks, RiskGraph.xls 23KViewDownload- Hide quoted text - - Show quoted text - Option RiskGraph.xls 24KViewDownload --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Need Help regarding split Emp. Name Emp. ID
Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Split Name No..xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need Help regarding split Emp. Name Emp. ID
attached file has the solution assuming that ID will be of 5 digits only On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori lavprasa...@gmail.comwrote: Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Split_Name__No.(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need Help regarding split Emp. Name Emp. ID
Dear Lavprasad, Please see the attached file with the solution of your problem. Hope that helps. Thanks Regards, Jitendra Kumar On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori lavprasa...@gmail.comwrote: Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 -- Thanks Best Regards, Jitendra Kumar Mobile # +91 9971694675 Alt. Email - jitendra_kumar...@yahoo.com It's not the strongest species that survive, nor the most intelligent, but the most responsive to change --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Split Name No..xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need Help regarding split Emp. Name Emp. ID
Lavprasad Kori- If you add trim function for the name it would remove any additional unwanted space On Mon, Apr 13, 2009 at 7:42 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: attached file has the solution assuming that ID will be of 5 digits only On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori lavprasa...@gmail.comwrote: Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 -- Thanks Regards, Harmeet Singh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need Help regarding split Emp. Name Emp. ID
There you go. _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Lavprasad Kori Sent: Monday, April 13, 2009 5:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Help regarding split Emp. Name Emp. ID Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Split Name No.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need Help regarding split Emp. Name Emp. ID
Hi Lavprasad Found a simple solution. Hope it helps. Regards Radhe On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori lavprasa...@gmail.comwrote: Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Split Name No(1)..xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need Help regarding split Emp. Name Emp. ID
As shown in the below article... http://funwithexcel.blogspot.com/2009/04/sorting-of-dates-with-different-formats.html use the 'data' tab to split the name and Id. Hope this helps. On Mon, Apr 13, 2009 at 7:12 AM, Harmeet Singh harmeet.hew...@gmail.comwrote: attached file has the solution assuming that ID will be of 5 digits only On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori lavprasa...@gmail.comwrote: Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 -- Thanks Regards, Harmeet Singh -- http://funwithexcel.blogspot.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Autorun a macro on save
Thanks, Dave, that's what I was looking for! On 3 Apr., 06:54, Dave Bonallack davebonall...@hotmail.com wrote: Hi Hamster, If you go to the Workbook window of the VBA, where your Workbook Open macros live, set the left drop-down to Workbook, then in the right drop-down, select: BeforeSave. You will se a blank sub like this: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) End Sub Then just put your code in. Hope this helps. Regards - Dave. _ The new Windows Live Messenger has landed. Download it here.http://download.live.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Macro to open Sharepoint documents?
I have a status report spreadsheet saved onto my desktop that links to 15 other excel spreedsheets on a Sharepoint location. I tried to record the macro and that would open those 15 excel spreadsheets from Sharepoint. However when I attempt to run the macro I get a Run-time error '76' Path not found. Here is what I have so far but it always errors out on the change directory command Sub Macro1() ' ' Macro1 Macro ' ' ChDir https://projects.company.com/software/Notes; Workbooks.Open Filename:= _ https://projects.company.com/software/Notes/Issues%20Tracking %20List.xls End Sub Is it possible to write a macro that can open documents that are not stored on your desktop, but rather in an information portal site? Any info or suggestions are appreciated Regards --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
Hi Harmeet, I used the other macro to fix my date and time issue since I was trying to link this date and time with availble field in raw data but this was refreshing so time was also refreshed but anyway I have fixed that but eventually I have found that the data acquired is always misses the first raw and name of the agent which comes in raw data sheet is not correct as it comes against the one row prvious data. I have also not able to get mys in your macro. Once again thanks for your time Regards, Harish 2009/4/13 Harmeet Singh harmeet.hew...@gmail.com Hi Harish, First of all, Thanks a lot for appreciation. If now I do the changes that you have mentioned in your mail, will be a spoon feeding. I have not protected the code that I have sent you. It would be a good learning for you if you try and do it by yourself. You just need to write two lines similar to what I used. Let me know if you stuck anywhere. Regards, Harmeet singh. On Sun, Apr 12, 2009 at 11:31 PM, Harish Sharma harishsharma...@gmail.com wrote: Thanks a lot Harmeet... Can u also get me one more functionality here that as soon as one agent acquires the job time and date he acquired also appears and untill he finishes the job by selecting as close which will be a drop down in next column to acquired time column. Once agent uses close from drop down in next column closing time date should also appear. Thanks once again Harish 2009/4/11 Harmeet Singh harmeet.hew...@gmail.com Bingo. See attached file. On Sat, Apr 11, 2009 at 4:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi Ashish, Can you please help me with the file attached. I have raw data in first sheet columns B,CD and I have 9 associates to work on this data further but I want now to build a macro where if any agent click on acquire button(will be available in respective agent's sheet) he gets the data (first availabel data in the raw)from raw data sheet in FIFO basis and all the agents will also be working on the sheet together so it would be shared. But the data should not be duplicating and raw data should be protected and once the data is acuired by any agent his name should appear in first column. Thanks in advance -- Kind Regards, Harish Sharma -- Thanks Regards, Harmeet Singh -- Kind Regards, Harish Sharma -- Thanks Regards, Harmeet Singh -- Kind Regards, Harish Sharma --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: color code excel cell if a cell has a formula
Hi, A quick way to reveal which cells have formulas: Ctrl+` That's Ctrl plus the key above the Tab key. Regards - Dave. Date: Mon, 13 Apr 2009 11:15:32 -0700 Subject: $$Excel-Macros$$ color code excel cell if a cell has a formula From: ned...@yahoo.com To: excel-macros@googlegroups.com could anyone tell me how to color code an excel cell if a cell has a formula. I have a long worksheet with lot of data and it it hard to tell which data is a formula and which is just value entered by users. Thanks _ Need a new place to rent, share or buy? Let ninemsn property search for you. http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Edomain%2Ecom%2Eau%2F%3Fs%5Fcid%3DFDMedia%3ANineMSN%5FHotmail%5FTagline_t=774152450_r=Domain_tagline_m=EXT --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---