$$Excel-Macros$$ if then formula - help needed
A2 =IF(A1=buy,(B1+A2),A2) if A1 is buy then add value in (B1+A2) or else keep value of A2.. A3 = IF(A1=sell,(B1+A3,A3) if A1 is sell then add value in (B1+A3) or else keep value of A3 cant get it work..above formula... thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ if then formula - help needed
Yes, I am getting cicrular reference error. Any idea how to resolve it? I have uploaded file 'if...then.xls in Upload section.. thanks in advance.. Dilip Pandey wrote: Hi TAIgo, According to me you should be getting circular reference error because you are Adding B1+A2 being in Cell A2. Try uploading a sample file so that we can help you better. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/26/10, TAlgo trading.a...@gmail.com wrote: A2 =IF(A1=buy,(B1+A2),A2) if A1 is buy then add value in (B1+A2) or else keep value of A2.. A3 = IF(A1=sell,(B1+A3,A3) if A1 is sell then add value in (B1+A3) or else keep value of A3 cant get it work..above formula... thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ if then formula - help needed
I cant upload the file so emailing you..if you know how to upload please go ahead... Thanks again Dilip Pandey wrote: Hi TAIgo, According to me you should be getting circular reference error because you are Adding B1+A2 being in Cell A2. Try uploading a sample file so that we can help you better. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 1/26/10, TAlgo trading.a...@gmail.com wrote: A2 =IF(A1=buy,(B1+A2),A2) if A1 is buy then add value in (B1+A2) or else keep value of A2.. A3 = IF(A1=sell,(B1+A3,A3) if A1 is sell then add value in (B1+A3) or else keep value of A3 cant get it work..above formula... thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Condition macro - please solve
Hii.. I'm looking for a macro or condition statement which would do following for me: If cell A1 is BUY then run a macro automatically which will add current value in cell B1 to cell A3 so everything theres a BUY in cell A1..macro will keep addiing B1 values in cell A3 and If cell A1 is SELL then run a macro automatically which will add current value in cell B1 to cell A4 so everything theres a SELL in cell A1..macro will keep addiing B1 values in cell A4 Hope it makes sense...also A1 will be updated dynamically through external source /// -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ run a macro when workbook close
All, I have multiple workbooks with unique names in one of my folder. Each workbook has similar sheets and it contains pivot values. I recorded the program from one of the workbook which selects the fields i need. Is there a way I can do this for all the workbooks in the folder without opening one by one? Basically I want to run this below macro for each and every workbook in that folder Sub Test() ' ' With ActiveSheet.PivotTables(PivotTable7).PivotFields(OpCo) .PivotItems().Visible = False .PivotItems(Bal).Visible = False .PivotItems(Bas).Visible = False .PivotItems(Beu).Visible = False .PivotItems(Bna).Visible = False .PivotItems(Bpl).Visible = False .PivotItems((blank)).Visible = False End With With ActiveSheet.PivotTables(PivotTable7).PivotFields(Material Group) .PivotItems().Visible = False .PivotItems(Corn Oil).Visible = False .PivotItems(Feedgrains).Visible = False .PivotItems(Freight).Visible = False .PivotItems(Livestock).Visible = False .PivotItems(Ngfi).Visible = False .PivotItems(Oils).Visible = False .PivotItems(Oilseeds).Visible = False .PivotItems(Potash).Visible = False .PivotItems(Sbo).Visible = False .PivotItems(Sugar).Visible = False .PivotItems(Wheat).Visible = False .PivotItems((blank)).Visible = False .PivotItems(Uan).Visible = False .PivotItems(Sbm).Visible = False .PivotItems(Soybeans).Visible = False .PivotItems(Unknown).Visible = False .PivotItems(Softseeds).Visible = False .PivotItems(Rapeseeds).Visible = False .PivotItems(Mapdap).Visible = False .PivotItems(Soyabeans).Visible = False End With End Sub --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Important - Help needed with graph and input box
All, This is just my thought but have no idea how to proceed. Can someone please provide a solution, I will really appreciate. Not sure how to attach a spreadsheet by my data spreadsheet is uploaded to File section known as DATA.XLSX. Col A. contains dates ( 1-Jan to 16-Aug ) and Col B-K contains data starting year 2001-2010 for the same dates. I would like to create a Date Range Input box so whenever I specify date ranges, it automatically pulls data of those dates from 2001 to 2010 and creates some type of line chart. E.g I specify date1: 3-march and date2: 10-June then line graph shopuld be create automatically. Hope this is clear. Thanks in advance. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Cell adds previous values automatically
Hi, I have a market data linked to excel through DDE link so prices are updated real time. Cell A5 contains last traded volume which updates whenever a trade is done. I would like to SUM/ADD all last trade volume in cell C5. Is there any function or macro can help me to do this? Thx in advance. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Cell adds previous values automatically
i dont have a file created yet but its simple. I receive real time market data from third party application and link to excel so cell A5 will constantly updated. I would like to capture and sum each price on cell A5 and put to C5. On Aug 20, 11:45 am, Ometoon omet...@hotmail.com wrote: Hi there, Can you give some more background information, maybe the file so I can take a look at it? On 20 aug, 15:40, TAlgo trading.a...@gmail.com wrote: Hi, I have a market data linked to excel through DDE link so prices are updated real time. Cell A5 contains last traded volume which updates whenever a trade is done. I would like to SUM/ADD all last trade volume in cell C5. Is there any function or macro can help me to do this? Thx in advance. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Windows Task Manager Opening old version 2003 excel file
On Aug 2, 12:41 pm, TAlgo trading.a...@gmail.com wrote: Ayush, Thanks and appreciate your help in this matter. Just was little frustrating to search and find out that your topic was completely changed by someone. thx again, On Aug 2, 2:02 am, Ayush Jain jain_ayus...@yahoo.com wrote: Dear members, We have received concerns from few posters that there subject line of their topic was changed by other members. Please note that this is the violation of group policy. I request you to maintain decorum of the group. Any member found doing this again will be banned permanently from the group. Hi Mageshwaran, Please don't do this again in future. Hi TAIgo, Our apologies to you. Thanks for keeping us updated about such violation KEEP POSTING ! Best regards, Ayush Jain --- On Sat, 1/8/09, mageshwaran jayaraman macwa...@yahoo.co.in wrote: From: mageshwaran jayaraman macwa...@yahoo.co.in Subject: $$Excel-Macros$$ Using Protection in a Subtotal Sheet To: excel-macros@googlegroups.com Date: Saturday, 1 August, 2009, 12:32 PM Hi Guys, Need a small favour/suggestion. I've created an excel fail where I insert datas on daily basis and take a summary report at the end of the month. For a daily summary, I've used DATA SUBTOTAL function, wherein I get the summary in sheet 2(out of total 3 sheets which is automatically created when Subtotal function is used) and the daily entry is inserted in sheet 3. Now my problem is when I am trying to protect the sheet 3 using TOOLS PROTECTION PROTECT SHEET so that no body plays with the numerous formulas that I have put there, I'm not able to access the other 2 sheets. Let me know if I'd made myself clear or else I wud attach an sample excel file. Thanx 'n' rgds, Mageshwaran J. Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. See the Web#39;s breaking stories, chosen by people like you. Check out Yahoo! Buzz.http://in.buzz.yahoo.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 HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Windows Task Manager Opening old version 2003 excel file
On Aug 1, 3:02 am, mageshwaran jayaraman macwa...@yahoo.co.in wrote: Hi Guys, Need a small favour/suggestion. I've created an excel fail where I insert datas on daily basis and take a summary report at the end of the month. For a daily summary, I've used DATA SUBTOTAL function, wherein I get the summary in sheet 2(out of total 3 sheets which is automatically created when Subtotal function is used) and the daily entry is inserted in sheet 3. Now my problem is when I am trying to protect the sheet 3 using TOOLS PROTECTION PROTECT SHEET so that no body plays with the numerous formulas that I have put there, I'm not able to access the other 2 sheets. Let me know if I'd made myself clear or else I wud attach an sample excel file. Thanx 'n' rgds, Mageshwaran J. Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8.http://downloads.yahoo.com/in/internetexplorer/ --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Windows Task Manager Opening old version 2003 excel file
Paul, When I click the test.xlsm file it always opens as 2007 version, no prior version of any excel is open at that time. now I tried your suggested approaches: 1. Used C:\Program Files\Microsoft Office\Office12\EXCEL.EXE C: \foldername\test.xlsm BUT this doesnt trigger to initiate my test.xlsm in any format. Is thata anything missing on this one? 2. Yesterday I changed the setting by going to Tools and Folder Options and did exactly as what you suggested BUT with no luck. 3. As of now rest of the firm is still using 2003 so I need that version for testing and reporting purpose. Thanks On Jul 31, 12:35 pm, Paul Schreiner schreiner_p...@att.net wrote: A couple of things. I assume that you have both versions of Excel loaded and don't wish to uninstall the older version... When you say that when you open test.xlsm directly it opens as a regular 2007 excel When you do this, is Excel already open and then you double-click the file from an explorer window (or use the Open- menu )? What I suspect is that your Windows installation has Associated the Excel2003 to the .xlsm file extension. Depending on how you want your system to operate, there are several solutions. 1) in your Scheduled Task, in the 'run' box, you have the file name: c:\foldername\test.xlsm instead, tell it which program you want to use to open the file: C:\Program Files\Microsoft Office\Office12\EXCEL.EXE C:\foldername\test.xlsm 2) Change your file association. Open an Explorer window (My Computer). Select Tools - Folder Options, then select the File Types tab. Scroll down to the .XLSM file type, and hit the Change button. Now BROWSE to the C:\Program Files\Microsoft Office\Office12\EXCEL.EXE file 3) Uninstall Excel 2003 (I know, it may not be possible due to the need for testing,etc) hope this helps. Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Friday, July 31, 2009 11:28:10 AM Subject: $$Excel-Macros$$ Windows Task Manager Opening old version 2003 excel file All, I've scheduled a task to open my test.xlsm ( excel 2007 macro enabled ) file everyday but when it opens automatically, it opens as a 2003 excel file and messes up few formulaes and charts which I have created in 2007. When I open test.xlsm directly it opens as a regular 2007 excel. Any idea if this is related to some type of default or anything related to settings. I want to windows task manager to open test.xlsm as regular 2007 file instead of 2003. Thx in advance. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Windows Task Manager Opening old version 2003 excel file
hey Paul, I tried your option #1 with this one in RUN: C:\Program Files \Microsoft Office\office12\EXCEL.EXE C:\temp\Test.xlsm and somehow this does not trigger to open my file. It works if I keep C:\temp\Test.xlsm under RUN should it be under STart in? my start in : C:\Documents and Settings \cn\Desktop On Jul 31, 2:32 pm, Paul Schreiner schreiner_p...@att.net wrote: sorry to confuse you, but in option #1, you have to change the path names to the ones for YOUR location: Is Excel in: C:\Program Files\Microsoft Office\Office12\EXCEL.EXE ?? and, is your file called: C:\foldername\test.xlsm I REALLY doubt that you have a folder called 'foldername'! Also, keep in mind that if your any of your folders or file names have a space, you'll need to enclose the name in quotes: C:\Documents and Settings\MY Very Own Folder\test 1.xls try again personally, I think #1 is the best solution. Although #2 SHOULD have worked too... unless you accidently changed the association to the 2003 version! (they're both called EXCEL.EXE !!!) Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Friday, July 31, 2009 1:05:26 PM Subject: $$Excel-Macros$$ Re: Windows Task Manager Opening old version 2003 excel file Paul, When I click the test.xlsm file it always opens as 2007 version, no prior version of any excel is open at that time. now I tried your suggested approaches: 1. Used C:\Program Files\Microsoft Office\Office12\EXCEL.EXE C: \foldername\test.xlsm BUT this doesnt trigger to initiate my test.xlsm in any format. Is thata anything missing on this one? 2. Yesterday I changed the setting by going to Tools and Folder Options and did exactly as what you suggested BUT with no luck. 3. As of now rest of the firm is still using 2003 so I need that version for testing and reporting purpose. Thanks On Jul 31, 12:35 pm, Paul Schreiner schreiner_p...@att.net wrote: A couple of things. I assume that you have both versions of Excel loaded and don't wish to uninstall the older version... When you say that when you open test.xlsm directly it opens as a regular 2007 excel When you do this, is Excel already open and then you double-click the file from an explorer window (or use the Open- menu )? What I suspect is that your Windows installation has Associated the Excel2003 to the .xlsm file extension. Depending on how you want your system to operate, there are several solutions. 1) in your Scheduled Task, in the 'run' box, you have the file name: c:\foldername\test.xlsm instead, tell it which program you want to use to open the file: C:\Program Files\Microsoft Office\Office12\EXCEL.EXE C:\foldername\test.xlsm 2) Change your file association. Open an Explorer window (My Computer). Select Tools - Folder Options, then select the File Types tab. Scroll down to the .XLSM file type, and hit the Change button. Now BROWSE to the C:\Program Files\Microsoft Office\Office12\EXCEL.EXE file 3) Uninstall Excel 2003 (I know, it may not be possible due to the need for testing,etc) hope this helps. Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Friday, July 31, 2009 11:28:10 AM Subject: $$Excel-Macros$$ Windows Task Manager Opening old version 2003 excel file All, I've scheduled a task to open my test.xlsm ( excel 2007 macro enabled ) file everyday but when it opens automatically, it opens as a 2003 excel file and messes up few formulaes and charts which I have created in 2007. When I open test.xlsm directly it opens as a regular 2007 excel. Any idea if this is related to some type of default or anything related to settings. I want to windows task manager to open test.xlsm as regular 2007 file instead of 2003. Thx in advance. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: BEST EXCEL TIPWEEK # 30Submit your TIP here only
To copy paste cell content to thousands of cells: 1. Select and copy cell A1. 2. Type a cell address in the Name box, for this example, type A5000. 3. Press Shift+Enter to select the cells from A1:A5000. 4. To paste, press Enter. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Help Needed - Linking 2 workbooks
All, data on my workbook 'cricket.xlsx' is updated through a DDE link and located under g:\ drive I'm trying to link to same file from another machine so data can be updated on both the workbooks at the same time. my source file - 'G:\NT\Cricket.xlsx Target - 'G:\NT\[Cricket.xlsx]Sheet1'!B3 I'm trying to copy cell B3 to target workbook. Just the cell value doesnt update in target workbook..anythoughts? --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: BEST EXCEL TIPWEEK # 30Submit your TIP here only
To delete empty rows between data: 1. Select all columns containing data. 2. Click the Sort icon (either Ascending or Descending). --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: BEST EXCEL TIPWEEK # 30Submit your TIP here only
To print a single Comment in cell: 1. Select a cell containing a Comment. 2. From the File menu, select Page Setup, and then click the Sheet tab. 3. In the print area, insert the cell address. 4. From the Comments dropdown list, select At end of sheet and click OK. 5. Click the Print icon --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Calculation Event Macro Stopped Working
hello, I was successfully using the following code as entering orders to trade commodity futures in to exchange. Private Sub Worksheet_Calculate() Const WS_RANGE As String = B1 '== change to suit On Error GoTo ws_exit If Range(WS_RANGE).Value = oldval Then Exit Sub 'value has not changed oldval = Range(WS_RANGE).Value Application.EnableEvents = False If Range(WS_RANGE).Value Range(b2) And Range(WS_RANGE).Value Range(b3) Then 'range 1 and range 2 Call BuyBeansSellProducts End If If Range(WS_RANGE).Value = Range(b5) And Range(WS_RANGE).Value Range( b6) Then 'range3 and range4 Call SellBeansBuyProducts End If ws_exit: Application.EnableEvents = True End Sub The problem is; my code suddenly stopped recognizing range 3 and range 4 and dpes not call SellBEANBUYPRODUCTS anymore but works greate for range1 and range2 and calls BUYBEANSSELLPRODUCTS... When i run seperately SellBeansBuyProducts macro it also runs without any issues.. Any idea what is causing it? --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Currency Conversion macro
Kamal, Can you please forward the formula for standard exchange rate..thx On Jul 19, 4:04 pm, kamal shah kamal...@gmail.com wrote: Are you looking for standard Exchange Rate or a variable? If so then u dont need macro for it. you can get it done with simple formula.. let me know if u need it. kamal On Sun, Jul 19, 2009 at 6:09 PM, krishnan moorthy krishnanm2...@gmail.comwrote: Dear Moderators, I am a beginner to the excel macro world. Needed your assistance to create a macro that can convert currency i.e. Dollars and Euros to Rupees and vice versa. Any help with this is highly appreciated. Thanks in advance! Krishnan Moorthy --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: BEST EXCEL TIPWEEK # 30Submit your TIP here only
Trick to get serial number behind Date format Select a cell and enter today date into the cell by pressing Ctrl+; than press Ctrl+~. Press Ctrl+~ again to restore the sheet to its normal appearance. thx On Jul 21, 11:18 am, Ayush jainayus...@gmail.com wrote: Dear Members, Let us begin week # 29 quiz with the hope of high participation. Last Date of Submission of tips : 26th July 2009. PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE CONSIDERED FOR PRIZES. DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS. You need to submit your name, Subject the details of tips and tricks. DO let me know if you need any clarifications. Let me begin by submitting the first tip for this week competition. --- Name : Ayush Jain Subject : Convert rows to columns viceversa Detail : You can convert rows to columns (and columns to rows) by highlighting the cells you want to switch around, clicking on Edit, Copy, selecting a new cell and then going to Edit, Paste Special… Finally, place a tick in the Transpose box on the dialog box and click on OK. Who is next - --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Calculation Event Macro Stopped Working
B1 = last traded price of crude oil futures ( get through DDE link so keeps changing every sec ) e.g. 6500 B2 B3 ( I define the range so if B1 goes between the value specified in B2 and B3 then run another macro ( Call BuyBeansSellProducts ) which will enter multiple Buy Orders in to exchange) B5 B6 ( i define range for running macro will send Sell Orders ) - Call SellBeansBuyProducts Till yesterday my code was running smoothly just today something happened it stopped reacting and if B1 value goes between values specified in B5 and B6 nothing happens, it doesnt run SellBEANSBUYPRODUCTS macro...but at the same time...it works great for BuyBeansSellProducts macro... On Jul 21, 1:26 pm, Paul Schreiner schreiner_p...@att.net wrote: Have you tried setting a breakpoint and see if what it is actually doing by stepping through the code? and.. what do you mean that it stopped recognizing range 3 and 4? What are the values you're testing? B1 = B2 = B3 = B4 = Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tuesday, July 21, 2009 10:27:17 AM Subject: $$Excel-Macros$$ Calculation Event Macro Stopped Working hello, I was successfully using the following code as entering orders to trade commodity futures in to exchange. Private Sub Worksheet_Calculate() Const WS_RANGE As String = B1 '== change to suit On Error GoTo ws_exit If Range(WS_RANGE).Value = oldval Then Exit Sub 'value has not changed oldval = Range(WS_RANGE).Value Application.EnableEvents = False If Range(WS_RANGE).Value Range(b2) And Range(WS_RANGE).Value Range(b3) Then 'range 1 and range 2 Call BuyBeansSellProducts End If If Range(WS_RANGE).Value = Range(b5) And Range(WS_RANGE).Value Range( b6) Then 'range3 and range4 Call SellBeansBuyProducts End If ws_exit: Application.EnableEvents = True End Sub The problem is; my code suddenly stopped recognizing range 3 and range 4 and dpes not call SellBEANBUYPRODUCTS anymore but works greate for range1 and range2 and calls BUYBEANSSELLPRODUCTS... When i run seperately SellBeansBuyProducts macro it also runs without any issues.. Any idea what is causing it? --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Calculation Event Macro Stopped Working
Alright..i tried on another laptop and it works perfect..just its not working on my work computer..any ideas? On Jul 21, 1:26 pm, Paul Schreiner schreiner_p...@att.net wrote: Have you tried setting a breakpoint and see if what it is actually doing by stepping through the code? and.. what do you mean that it stopped recognizing range 3 and 4? What are the values you're testing? B1 = B2 = B3 = B4 = Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Tuesday, July 21, 2009 10:27:17 AM Subject: $$Excel-Macros$$ Calculation Event Macro Stopped Working hello, I was successfully using the following code as entering orders to trade commodity futures in to exchange. Private Sub Worksheet_Calculate() Const WS_RANGE As String = B1 '== change to suit On Error GoTo ws_exit If Range(WS_RANGE).Value = oldval Then Exit Sub 'value has not changed oldval = Range(WS_RANGE).Value Application.EnableEvents = False If Range(WS_RANGE).Value Range(b2) And Range(WS_RANGE).Value Range(b3) Then 'range 1 and range 2 Call BuyBeansSellProducts End If If Range(WS_RANGE).Value = Range(b5) And Range(WS_RANGE).Value Range( b6) Then 'range3 and range4 Call SellBeansBuyProducts End If ws_exit: Application.EnableEvents = True End Sub The problem is; my code suddenly stopped recognizing range 3 and range 4 and dpes not call SellBEANBUYPRODUCTS anymore but works greate for range1 and range2 and calls BUYBEANSSELLPRODUCTS... When i run seperately SellBeansBuyProducts macro it also runs without any issues.. Any idea what is causing it? --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Auto Run Macro - Copy data from multiple workbooks
thanks On Jul 18, 9:03 am, Daniel dcolarde...@free.fr wrote: A .bat file is a text file with the .bat extension instead of a standard .txt file. That makes them executable. Iused task manager instead of task scheduler. Ther is a tutorial there :http://www.iopus.com/guides/winscheduler.htm Regards. Daniel -Original Message- From: excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] On Behalf Of TAlgo Sent: vendredi 17 juillet 2009 21:33 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Auto Run Macro - Copy data from multiple workbooks Thanks ..I've never created Windows task manager..is there a link or sample guide how to create task manager and .bat file? On Jul 17, 2:43 pm, Daniel dcolarde...@free.fr wrote: Hello. Use the OnTime command in your macro. This means that your workbook has to be open and your macro running at the activation time. However, if you use Excel 2007, you could place the master workbook in a trusted folder (that is to say that an auto open macro can run at open without security questioning). Then, use the Windows task manager to schedule the execution of a .bat file containing : cmd /c c:\TrustedFolder\masterfile.xls Hope this helps. Daniel -Original Message- From: excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] On Behalf Of TAlgo Sent: vendredi 17 juillet 2009 17:20 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Auto Run Macro - Copy data from multiple workbooks Hello, Something new for me so need some help : I' would like to have a macro which will extract data automatically and daily from multiple workbooks ( Source ) and copy to Master workbook ( target ) located under same network drive. Say around 5 pm EST macro should auto run and complete the above task on daily basis. I would like to copy column A from each source files and paste to Sheet 1 of Target file ( Can be in column A, B C ) Source Files 1) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Active Users.xls 2) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Account Users.xls 3) G:\BIT\BMProjects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Inactive Users.xls Target File ( Master list ) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\eTD Users.xls thx in advance- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Auto Run Macro - Copy data from multiple workbooks
Hello, Something new for me so need some help : I' would like to have a macro which will extract data automatically and daily from multiple workbooks ( Source ) and copy to Master workbook ( target ) located under same network drive. Say around 5 pm EST macro should auto run and complete the above task on daily basis. I would like to copy column A from each source files and paste to Sheet 1 of Target file ( Can be in column A, B C ) Source Files 1) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Active Users.xls 2) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Account Users.xls 3) G:\BIT\BMProjects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Inactive Users.xls Target File ( Master list ) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\eTD Users.xls thx in advance --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Auto Run Macro - Copy data from multiple workbooks
Thanks ..I've never created Windows task manager..is there a link or sample guide how to create task manager and .bat file? On Jul 17, 2:43 pm, Daniel dcolarde...@free.fr wrote: Hello. Use the OnTime command in your macro. This means that your workbook has to be open and your macro running at the activation time. However, if you use Excel 2007, you could place the master workbook in a trusted folder (that is to say that an auto open macro can run at open without security questioning). Then, use the Windows task manager to schedule the execution of a .bat file containing : cmd /c c:\TrustedFolder\masterfile.xls Hope this helps. Daniel -Original Message- From: excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] On Behalf Of TAlgo Sent: vendredi 17 juillet 2009 17:20 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Auto Run Macro - Copy data from multiple workbooks Hello, Something new for me so need some help : I' would like to have a macro which will extract data automatically and daily from multiple workbooks ( Source ) and copy to Master workbook ( target ) located under same network drive. Say around 5 pm EST macro should auto run and complete the above task on daily basis. I would like to copy column A from each source files and paste to Sheet 1 of Target file ( Can be in column A, B C ) Source Files 1) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Active Users.xls 2) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Account Users.xls 3) G:\BIT\BMProjects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Inactive Users.xls Target File ( Master list ) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\eTD Users.xls thx in advance --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ One Cell Data - Seperate to different columns
_ Sept. 15, down 504.48 at 10,917.51. Hello, I have above data in cell A1 ..I'm looking to separate Sept 15, Down, 504.48, 10917.51 in to different columns. Any idea? --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Count the number of times Macro ran - Urgent Question
Dave, It works..thanks a lot On Jul 15, 11:13 pm, Dave Bonallack davebonall...@hotmail.com wrote: Hi, You just need to find a unused cell near by, and use it as a recorder. If the unused cell is, say, E1, then your macro would look like this: Sub resetval_SCRUSH() Range(d1) = 0 Range(E1) = Range(E1) + 1 End Sub You may need to start by putting 0 (zero) into E1, but try without first. Hope this helps. Regards - Dave. Date: Wed, 15 Jul 2009 09:58:07 -0700 Subject: $$Excel-Macros$$ Count the number of times Macro ran - Urgent Question From: trading.a...@gmail.com To: excel-macros@googlegroups.com Hello, A newbie here and I think this should be really easy for othersI have a macro which reset cell value to 0 and I have created a text box and assign this macro to it. So everytime I click that box it resets D1 value to 0. I just want to have a count the number of times macro - RESETVAL_SCRUSH ran... Sub resetval_SCRUSH() Range(d1) = 0 End Sub thx in advance/ _ View photos of singles in your area Click Herehttp://dating.ninemsn.com.au/search/search.aspx?exec=gotp=qgc=2tr=... --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: One Cell Data - Seperate to different columns
Awesome..you da man...Thanks On Jul 16, 10:16 am, Thierry tyrellc...@gmail.com wrote: You can use some fancy string manipulation. I got this to work: 'input is _ Sept. 15, down 504.48 at 10,917.51. in cell A1 Dim sInput, sDate, sDown, sFirstNumber, sSecondNumber As String sInput = Range(A1) sDate = Left(sInput, InStr(sInput, ,) - 1) sDate = Right(sDate, Len(sDate) - Len(_ )) Range(B1) = sDate sInput = Right(sInput, Len(sInput) - Len(_ ) - Len(sDate) - Len (, )) sDown = Left(sInput, InStr(sInput, ) - 1) Range(C1) = sDown sInput = Right(sInput, Len(sInput) - InStr(sInput, )) sFirstNumber = Left(sInput, InStr(sInput, )) Range(D1) = sFirstNumber sSecondNumber = Right(sInput, Len(sInput) - InStr(sInput, at ) - Len(at ) + 1) sSecondNumber = Left(sSecondNumber, Len(sSecondNumber) - 1) Range(E1) = sSecondNumber Cheers, Thierry On Jul 16, 9:06 am, TAlgo trading.a...@gmail.com wrote: _ Sept. 15, down 504.48 at 10,917.51. Hello, I have above data in cell A1 ..I'm looking to separate Sept 15, Down, 504.48, 10917.51 in to different columns. Any idea? --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: One Cell Data - Seperate to different columns
Dilip. How do I use text to column feature of 07? On Jul 16, 10:36 am, Daniel dcolarde...@free.fr wrote: Hi. Try : Sub test() Dim txt As String, Tabl txt = [A1] txt = Application.Substitute(txt, _, ) txt = Application.Substitute(txt, ,, ) txt = Left(txt, Len(txt) - 1) txt = Right(txt, Len(txt) - 1) Tabl = Split(txt, ) [B1] = Tabl(0) Tabl(1) [C1] = Tabl(2) [D1] = Tabl(3) * 1 [E1] = Tabl(5) * 1 End Sub Regards. Daniel -Original Message- From: excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] On Behalf Of TAlgo Sent: jeudi 16 juillet 2009 15:06 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ One Cell Data - Seperate to different columns _ Sept. 15, down 504.48 at 10,917.51. Hello, I have above data in cell A1 ..I'm looking to separate Sept 15, Down, 504.48, 10917.51 in to different columns. Any idea? --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: One Cell Data - Seperate to different columns
got it..thanks guys On Jul 16, 11:01 am, TAlgo trading.a...@gmail.com wrote: Dilip. How do I use text to column feature of 07? On Jul 16, 10:36 am, Daniel dcolarde...@free.fr wrote: Hi. Try : Sub test() Dim txt As String, Tabl txt = [A1] txt = Application.Substitute(txt, _, ) txt = Application.Substitute(txt, ,, ) txt = Left(txt, Len(txt) - 1) txt = Right(txt, Len(txt) - 1) Tabl = Split(txt, ) [B1] = Tabl(0) Tabl(1) [C1] = Tabl(2) [D1] = Tabl(3) * 1 [E1] = Tabl(5) * 1 End Sub Regards. Daniel -Original Message- From: excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] On Behalf Of TAlgo Sent: jeudi 16 juillet 2009 15:06 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ One Cell Data - Seperate to different columns _ Sept. 15, down 504.48 at 10,917.51. Hello, I have above data in cell A1 ..I'm looking to separate Sept 15, Down, 504.48, 10917.51 in to different columns. Any idea? --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Count the number of times Macro ran - Urgent Question
Hello, A newbie here and I think this should be really easy for othersI have a macro which reset cell value to 0 and I have created a text box and assign this macro to it. So everytime I click that box it resets D1 value to 0. I just want to have a count the number of times macro - RESETVAL_SCRUSH ran... Sub resetval_SCRUSH() Range(d1) = 0 End Sub thx in advance/ --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Count the number of times Macro ran - Urgent Question
Hello, A newbie here and I think this should be really easy for othersI have a macro which reset cell value to 0 and I have created a text box and assign this macro to it. So everytime I click that box it resets D1 value to 0. I just want to have a count the number of times macro - RESETVAL_SCRUSH ran... Sub resetval_SCRUSH() Range(d1) = 0 End Sub thx in advance/ --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ User Form Help
Hello, I need some help in creating an user form or input screen in excel so I can input two number manually...my code is as follows: I need to create some type of input box for specifying range numbers 1) f Range(WS_RANGE).Value 6465 And Range(WS_RANGE).Value 6469 Then and 2) If Range(WS_RANGE).Value 5943 And Range(WS_RANGE).Value 5946 Then So each input box will have 2 fields for prices and as soon as I input those prices it automatically updates those prices in my codeplease advice... Private Sub Worksheet_Calculate() Const WS_RANGE As String = B1'== change to suit CurrentValue = Range(WS_RANGE) On Error GoTo ws_exit Application.EnableEvents = False Application.Undo PriorValue = Range(WS_RANGE) Range(WS_RANGE).Offset(0, -1) = CurrentValue If PriorValue = CurrentValue Then GoTo ws_exit 'cell B1 did not change If Range(WS_RANGE).Value 6465 And Range(WS_RANGE).Value 6469 Then Call BuyBeans End If If Range(WS_RANGE).Value 5943 And Range(WS_RANGE).Value 5946 Then Call SellBeans End If ws_exit: Application.EnableEvents = True End Sub --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Worksheet_calculate Question
was able to figure it ouyt myself On Jul 10, 9:02 am, TAlgo trading.a...@gmail.com wrote: Hello, I've a quick question on an event Private Sub Worksheet_Calculate(). I got Private Sub Worksheet_Calculate() running on Sheet1 which does few calculations and calls a macro. Is it possible I can create another event in same worksheet Private Sub Worksheet_Calculate() which would do another calculations and calls another macro? So I want to know is it possible two Worksheet_calculate events are possible in same worksheet. Please advice. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Worksheet_calculate Question
Hello, I've a quick question on an event Private Sub Worksheet_Calculate(). I got Private Sub Worksheet_Calculate() running on Sheet1 which does few calculations and calls a macro. Is it possible I can create another event in same worksheet Private Sub Worksheet_Calculate() which would do another calculations and calls another macro? So I want to know is it possible two Worksheet_calculate events are possible in same worksheet. Please advice. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel Macro - copying cell value as it changes
Thanks Nishant... Again code does not work when value in cell A1 is updated dynamically through an external source. I create a DDE link and paste to cell A1 so prices are updated automatically.. On Jun 4, 9:24 am, Nishant Jain nishantjai...@gmail.com wrote: Try the macro do the following and then copy the code below in a module cell E1 = '00:00:01 cell E2 = validation list with 2 option active, inactive Sub check_prices() 'created by Nishant Jain (nishantjai...@gmail.com) Application.OnTime Now() + TimeValue(Range(E1).Value), run_code End Sub Sub run_code() If Range(E2).Value = Active Then If Range(B1).Value Range(A1).Value Then Range(B1:B19).Select Selection.Copy Range(B2).Select ActiveCell.PasteSpecial xlPasteValues Range(B1).Value = Range(A1).Value Range(A1).Select End If Application.StatusBar = Last run at Now() Else Application.StatusBar = False End If Call check_prices End Sub On Jun 3, 11:10 pm, TAlgo trading.a...@gmail.com wrote: i need to check on date and time... On Jun 3, 1:41 pm, Paul Schreiner schreiner_p...@att.net wrote: I think I may have something... but there's a new wrinkle... I know A1 is being updated from an external source. let's say it updates every minute... but what if the value hasn't CHANGED since the last update? let's say for the last 10 minutes, the values were: 1,2,5,5,5,6,7,5,5,3 Would it be acceptable to show the last 20 DIFFERENT values? as in: 1,2,5,6,7,5,3 ?? If so, I think we can use the Calculate event to trigger the update. Private Sub Worksheet_Calculate() Dim x If (ActiveSheet.Cells(1, 2) ActiveSheet.Cells(1, 1)) Then For x = 20 To 2 Step -1 ActiveSheet.Cells(x, 2) = ActiveSheet.Cells(x - 1, 2) Next x ActiveSheet.Cells(1, 2) = ActiveSheet.Cells(1, 1) End If End Sub now, if you really want to keep the duplicates (just to show that the values haven't changed for x number of cycles) then... is it possible for your DDE update to also update a cell with the TIME of the last update? then, do the same thing but also record the date/time of the data record? ?? Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, June 3, 2009 12:50:00 PM Subject: $$Excel-Macros$$ Re: Excel Macro - copying cell value as it changes Paul, it works but my value in cell A1 is derived from external sources via DDE. you think worksheet event does not recognize cell value if its DDE? On Jun 3, 12:32 pm, Paul Schreiner schreiner_p...@att.net wrote: the simplest approach would be to use a worksheet Change Event like: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim X If (Target.Address = $A$1) Then For X = 20 To 2 Step -1 ActiveSheet.Cells(X, 2) = ActiveSheet.Cells(X - 1, 2) Next X ActiveSheet.Cells(1, 2) = ActiveSheet.Cells(1, 1) End If End Sub hth Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, June 3, 2009 10:47:37 AM Subject: $$Excel-Macros$$ Excel Macro - copying cell value as it changes Hello All, I'm stuck on this one. Any help will be greatly appreciated. Let me see if I get this correct. I' have a cell - A1 which receives 'LAST Traded Price ' of a stock through DDE so cell A1 keeps changing dynamically during trading session. I need a macro which will copy value from A1 and place in B1 then when A1 changes it copies to B1 and earlier B1 value moves to B2 and so on..but i want this process to be limited up to B 20 .so no value in B21 hope its clear otherwise just let me know if you have questions Thanks and regards,- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ - 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$$ Excel Macro - copying cell value as it changes
Hello All, I'm stuck on this one. Any help will be greatly appreciated. Let me see if I get this correct. I' have a cell - A1 which receives 'LAST Traded Price ' of a stock through DDE so cell A1 keeps changing dynamically during trading session. I need a macro which will copy value from A1 and place in B1 then when A1 changes it copies to B1 and earlier B1 value moves to B2 and so on..but i want this process to be limited up to B 20 .so no value in B21 hope its clear otherwise just let me know if you have questions Thanks and 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: Excel Macro - copying cell value as it changes
Paul, it works but my value in cell A1 is derived from external sources via DDE. you think worksheet event does not recognize cell value if its DDE? On Jun 3, 12:32 pm, Paul Schreiner schreiner_p...@att.net wrote: the simplest approach would be to use a worksheet Change Event like: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim X If (Target.Address = $A$1) Then For X = 20 To 2 Step -1 ActiveSheet.Cells(X, 2) = ActiveSheet.Cells(X - 1, 2) Next X ActiveSheet.Cells(1, 2) = ActiveSheet.Cells(1, 1) End If End Sub hth Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, June 3, 2009 10:47:37 AM Subject: $$Excel-Macros$$ Excel Macro - copying cell value as it changes Hello All, I'm stuck on this one. Any help will be greatly appreciated. Let me see if I get this correct. I' have a cell - A1 which receives 'LAST Traded Price ' of a stock through DDE so cell A1 keeps changing dynamically during trading session. I need a macro which will copy value from A1 and place in B1 then when A1 changes it copies to B1 and earlier B1 value moves to B2 and so on..but i want this process to be limited up to B 20 .so no value in B21 hope its clear otherwise just let me know if you have questions Thanks and 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: Excel Macro - copying cell value as it changes
Basically value has to change for macro to trigger and copy and paste to another cellthere is no fix time when A1 (last traded price ) will update..normally its every few seconds. So A1 will only update ( change price ) if there is new price otherwise it will remain the same and macro wont be triggered Example: say 'last traded price ' in A1 = 35 macro wont trigger till A1 changes to 34 ( so A1 will be 34 and B1 will be 35 ( earlier value ) Again till A1 changes to another value say 36 ( now A1 = 36 )and (B1 = 34 and B2 = 35 ) A1 changes to 35 then ( A1 = 35 ) and ( B1 = 36, B2 = 34, B3 = 35 ) so my B column values will be 36,34,35... Does it makes sense? On Jun 3, 1:41 pm, Paul Schreiner schreiner_p...@att.net wrote: I think I may have something... but there's a new wrinkle... I know A1 is being updated from an external source. let's say it updates every minute... but what if the value hasn't CHANGED since the last update? let's say for the last 10 minutes, the values were: 1,2,5,5,5,6,7,5,5,3 Would it be acceptable to show the last 20 DIFFERENT values? as in: 1,2,5,6,7,5,3 ?? If so, I think we can use the Calculate event to trigger the update. Private Sub Worksheet_Calculate() Dim x If (ActiveSheet.Cells(1, 2) ActiveSheet.Cells(1, 1)) Then For x = 20 To 2 Step -1 ActiveSheet.Cells(x, 2) = ActiveSheet.Cells(x - 1, 2) Next x ActiveSheet.Cells(1, 2) = ActiveSheet.Cells(1, 1) End If End Sub now, if you really want to keep the duplicates (just to show that the values haven't changed for x number of cycles) then... is it possible for your DDE update to also update a cell with the TIME of the last update? then, do the same thing but also record the date/time of the data record? ?? Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, June 3, 2009 12:50:00 PM Subject: $$Excel-Macros$$ Re: Excel Macro - copying cell value as it changes Paul, it works but my value in cell A1 is derived from external sources via DDE. you think worksheet event does not recognize cell value if its DDE? On Jun 3, 12:32 pm, Paul Schreiner schreiner_p...@att.net wrote: the simplest approach would be to use a worksheet Change Event like: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim X If (Target.Address = $A$1) Then For X = 20 To 2 Step -1 ActiveSheet.Cells(X, 2) = ActiveSheet.Cells(X - 1, 2) Next X ActiveSheet.Cells(1, 2) = ActiveSheet.Cells(1, 1) End If End Sub hth Paul From: TAlgo trading.a...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Wednesday, June 3, 2009 10:47:37 AM Subject: $$Excel-Macros$$ Excel Macro - copying cell value as it changes Hello All, I'm stuck on this one. Any help will be greatly appreciated. Let me see if I get this correct. I' have a cell - A1 which receives 'LAST Traded Price ' of a stock through DDE so cell A1 keeps changing dynamically during trading session. I need a macro which will copy value from A1 and place in B1 then when A1 changes it copies to B1 and earlier B1 value moves to B2 and so on..but i want this process to be limited up to B 20 .so no value in B21 hope its clear otherwise just let me know if you have questions Thanks and 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$$ Copy one column to another except any cells containing zero
Guys, trying to create a macro which will copy column A to column B. This is simple but only exception I m looking is macro should not copy any value = 0 I m trying this but no luck so far..any help will be greatly appreciated.. Sub test_again() If cell(a:a) 0 Then Sheets(sheet7).Range(a:a).Copy Sheets(sheet7).Range(b:b) End If End Sub --~--~-~--~~~---~--~~ - 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: Help in Excel - How can we work in shared file while running the macro?
No file attached. ankur kochar wrote: Hi, Sorry for attaching the password file. Please find here attached file for help on how to work in excel with macros when it is s On Thu, May 21, 2009 at 10:02 PM, Fabio Lemos flnle...@gmail.com wrote: Your file has password... please attach a file without password or send us the password. 2009/5/20 ankur kochar ankurkoch...@gmail.com Hi, I required a urgent help, I had an excel file which i want to work in shared, but in that file I am using macro with VB codes, I want help how to run the macro while working in shared file using by more than 1 person at the same time. Please find the attached file for your reference. Any help on this will be really appreciated. Regards, Ankur -- Fabio L Lemos email: flnle...@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: Hi Urgent Excel help required.
Try this if this helps Sub CopyPaste() Dim ws As Worksheet For Each ws In Worksheets If ws.Name JAN Then ws.Select ws.Application.Run Macro1 End If Next End Sub Sub Macro1() Range(A2:B13).Select ' select all the data range Selection.Copy Sheets(Summary Sheet).Select ActiveSheet.Paste End Sub shannu shannu wrote: Hi All I have many sheets and I want to copy in one main excel sheet but I want to copy ne after the other exce sheet's data, it shd be like a ladder or a staircase. Sheets like A1, B1, C1 etc and one man sheet called JAN. I want to copy all the visible rows which are present in A1, B1,C1 and paste it in Jan excel one after the other. Regards, Shahina --~--~-~--~~~---~--~~ - 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: passwordupprotect file
Still it asks for a password On May 20, 11:05 am, H Upadhyay harishcupadh...@gmail.com wrote: Hi Tariq Passwored.xla crack password, but there is some way that we know what is the password. Regards Harish Upadhyay On 5/18/09, tariq tariq.78...@gmail.com wrote: hello mahesh, this file password is : AABBBAABBAAP AND ANY PASSWARD CRACKING SO MAIL ME ... my e_mail : tariq.78...@gmail.com contect no. : 09893729520 tariq khan +91 9893729520 --~--~-~--~~~---~--~~ - 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$$ Copy, past and move down one cell VBA/Macro
I am trying to copy and past data in a cell from another cell in my workbook. I then want to move down one cell each and every time I have pasted the data. Source Data always in Cell A1 target : I would like to copy in B1 Tomorrow when I open my spreadsheet, I would like to copy new data from A1 to B2 and so forth Thanks --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---