$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)
Hi I think you can use the WEB ADI functionaly to upload data in ORacle AP.. On 8/17/09, bala Subrahmanyam puligadda simplyb...@gmail.com wrote: Hi All, Can anyone help me in loading the excel information to Oracle Applications. I have a list of transactions which I manually enter in to Oracle AP transactions manually. can we record macro which automatically pic the transactions by step and post it to the Oracle Applications tab which I use. 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 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: How to unhide the sheet
Just go to Fomat sheet unhide the sheet. On 1/16/09, vinu vinu1sm...@gmail.com wrote: hello frnds, Whenever I open Excel new file(2003) I can see only sheet 1 and 3, sheet 2 is hidden. I tried to unhide by using Menu. It didnt work. Even I open the VBA and seen sheet 2 named as and invisible, I can make changes here and saved it. Even though when I open a new file I cant see sheet2. Could you pls guide me. Thanks a lot. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Hide Formula or data in column
Hi ... you can hide the column in very simple way Select the column Right Click with your Mouse click on Hide On 1/5/09, Keyur Shah keyursha...@gmail.com wrote: hi, Can anybody guide me how to hide data in column sothat no one can visible and i want to lock sheet that mouse pointer move only selected column only. -- Keyur Shah (M) 98259 28073 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel Macro
Hi Tom, Thanks this book is very useful. but do you have any such book which has more examples of macro .I am very keen to learn macros to automate most of my process. Thanks. On 1/4/09, Kamal Gulati kamalgula...@gmail.com wrote: Thanks a lot Mr. Tom, for the nice file for the Macro. Could you also provide me the file for Access Macro's as I need to do with all these. I know this is not the group for Access but still if you provide me that I would be highly obliged. Thanks and regards, = - k...@m@l' g...@ti' - = Ph: +91 9899101928, 9718361928 On Sun, Jan 4, 2009 at 8:59 PM, Tom Jeffries tjeff...@gmail.com wrote: Attached is a good introduction to Excel Macros provided by a member of this group. On Sat, Jan 3, 2009 at 11:22 AM, Kamal Gulati kamalgula...@gmail.comwrote: Hi friend, Can any one send me the simple steps and sample file to create Macro's in Excel. As I am new in macro's in excel plz send me all the steps with example. Thanks and regards, = - k...@m@l' g...@ti' - = Ph: +91 9899101928, 9718361928 - --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: how to make read only file in the particular folder
Hi Tom, Thanks for helping me but I have a question when I ran this macro the file get protect and open as read only. but read only should not get change unless I unprotect it with password. I tried macro you sent to me. The file I have protect through this macro I can easily unprotect with giving the password which I used to protect the file.I just to Tool and call the unprotect sheet then file is allowing to make any changes which I dont want. Thanks for your help. On 12/31/08, Tom Jeffries tjeff...@gmail.com wrote: The attached Workbook contains a macro (ProtectWBs) which I believe does what you want. Enter the complete path name for the starting point eg. C:\FilestToProtect and the password when prompted. Each Workbook (and its Sheets) along the specified path will be protected using the password provided. If you have any questions let me know. Regards, Tom On Tue, Dec 30, 2008 at 2:05 AM, vijender kumar simplevi...@gmail.comwrote: Hi to All, I have problem if you guys have solution then please provide me. My probelm is I have 20 or 30 folders and each folder containing 30 to 40 excel file which I have to sent to the market. and I have to protect ( read Only) each excel file one by one manually so that no one can make the change.I have do this exercise on monthly basis. Is there any option to make it automate through the macros. so that I can protect all of the file read only which is available in particular folder. or can I make all folder read only . --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Count function
Use Pivot table Option for this On 12/3/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I have to use Count function, and I have multiple criteria's for example I have to count the number of times a person's name is apperaring in a sheet and again count if he is active member or not from the second column, please let me know how to use an array within this count function. Plz reply ASAP. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Concatenate Formula
Hi, Use the below formula. =A1B1TEXT(C1,(dd-mm-yy)) On 10/26/08, karthik balasubramanian [EMAIL PROTECTED] wrote: Hi, Use this formulae: =CONCATENATE(E17,F17,TEXT(G17,[$-409]d-mmm-;@)) COL: E F G ROW ms excel 24-oct-2008 E17 is ms F17 is excel g17 is 24-oct-2008 I hope this helps. with regards karthik.B On Fri, Oct 24, 2008 at 1:01 AM, H Upadhyay [EMAIL PROTECTED]wrote: Pls chk attached file Regards Harish Upadhyay On 10/23/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi All, I have an issue while using concatenate formula, Can any one of you help me out with this: Query: Column A : MS Column B : Excel Column C : 24- Oct-08 ( formated as d-mmm-yy). When I use concatenate i get a result as : MS Excel 39745 After formatting the cell too d-mmm-yy, I get the same result instead of MS Excel 24-Oct-08. Please advice me if there is any other way out to get the result as desired. Thanks in Advance Cheers Shyam --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Concatenate Formula
hi. do one thing first paste special the cell value which has date then try concatenation On 10/24/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi All, I have an issue while using concatenate formula, Can any one of you help me out with this: Query: Column A : MS Column B : Excel Column C : 24- Oct-08 ( formated as d-mmm-yy). When I use concatenate i get a result as : MS Excel 39745 After formatting the cell too d-mmm-yy, I get the same result instead of MS Excel 24-Oct-08. Please advice me if there is any other way out to get the result as desired. Thanks in Advance Cheers Shyam --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: change from small letter to capital
Hi, Just use this formula =upper(cell reference) On Sat, Sep 20, 2008 at 5:22 PM, vinay keni [EMAIL PROTECTED] wrote: dear all, i want to know how to change from small letters to capital letters as i have some 500 persons name which i have typed in small letters now wants to change those things in the Big letters . reply fast its urgent -- Regards, Vinay Keni --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Vlookup Help
Hi Rishi, In first case you can you can copy the vlookup formula from one cell to another cell where you want the result. or just drag the formula. second case this is not posibble because vlookup formula find the exact value. On 9/2/08, rishi dakalia [EMAIL PROTECTED] wrote: Thanks a lot atul. it was really helpful On Thu, Aug 28, 2008 at 10:49 AM, SINGHAL, ATUL. [EMAIL PROTECTED] wrote: Hi Rishi, The formulae in the enclosed file may help you. Regards Atul -Original Message- *From:* rishi [mailto:[EMAIL PROTECTED] *Sent:* August 26, 2008 11:30 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Vlookup Help Hi All, I have a couple of problems : 1. I wanted to know if there is some short cut for using vlookup multiple times . For eg, I have a table with Name , Phone no ,address..etc in a workbook. I have a few names from the master list in the second sheet . Now I want to use vlookup to pull all the details from the first sheet i.e phone no , address , etc . I don't want to write individual vlookup for each column . Wanted to know if there is any short cut . 2. With similar sheet , If the names in the second sheet have some minor spelling mistakes,is it possible to still pull out data from the first sheet . For eg. Shree Ram in the first sheet could be Sri Ram in the second OR Ram Ltd could be Ram Ltd. In the second sheet . Using vlookup in such a case is not working...so is there any other way someone can suggest ? Thanks in advance . Rishi -- Thanks and Regards, Rishi Dakalia +91 9811182746 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---