Re: $$Excel-Macros$$ Re: SAVE As file name
pl tell how to exit out of this group? On Fri, Jul 5, 2013 at 10:28 AM, sandeep shivpujan singh mandy07s...@gmail.com wrote: Hi, You can use below code also. I think you want to save a blank sheet with the required name. 1. Code to save one sheet with the data given in cells 2. Dim strPath As String strPath = ActiveWorkbook.Path \ ActiveSheet.Copy ActiveWorkbook.SaveAs Filename:=strPath Cells(2, 1) - Cells(2, 2) - Cells(2, 4) .xls ActiveWorkbook.Close MsgBox done 2. based on number of rows you have.. each row data can be used and saved as a new sheet. 'for saving each row value as new xls you can try this. Dim i, j As Integer i = 4 ' i can be any number of row you want. For j = 2 To i 'two is for starting from 2nd row as 1st row is heading. ActiveSheet.Copy ActiveWorkbook.SaveAs Filename:=strPath Cells(j, 1) - Cells(j, 2) - Cells(j, 4) .xls ActiveWorkbook.Close Next j Thanks, Sandeep On Friday, 5 July 2013 09:41:01 UTC+5:30, Pankaj wrote: Dear All, Please help to SAVE As file name as per record entered. [image: Inline image 1] -- Thanks Pankaj Kumar 9910075248 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Ram Chartered Accountant 9990484446 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Condensing Multiple Worksheets Into One ...
Dear Customer, You have consumed 100% of your total quota allotted on Reliance Netconnect+. Now speed will be up to 144Kbps till next bill cycle. On Jun 7, 2012 1:22 AM, Greg gamoun...@gmail.com wrote: Hello, I am Hello, I am trying to process an Excel macro I found online from the following weblink: http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = Combined ' copy headings Sheets(2).Activate Range(A1).EntireRow.Select Selection.Copy Destination:=Sheets(1).Range(A1) ' work through sheets For J = 2 To Sheets.Count ' from sheet 2 to last sheet Sheets(J).Activate ' make the sheet active Range(A1).Select Selection.CurrentRegion.Select ' select all cells in this sheets ' select all lines except title Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select ' copy cells selected in the new sheet on last line Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2) Next End Sub According to the description, I can either use the Excel Consolidate tool or the above macro. Unfortunately, I didn't have much luck with the Consolidate tool because I don't understand how to reference each of the worksheet ranges. Once I run the macro, it appears to be doing something because I can see it trans-versing through each worksheet. When the macro has completed, the first sheet in the workbook is not named Combined, and it contains no data from the other worksheets. Thanks in advance for any assistance you can provide. Kind regards, Greg -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Hi
Dear All,my query may be a bit of a challenge.I want to protect my sheet while allowing user to play with grouping that forms on the left most part of the worksheet when you use sub total.Hope it is clear and understandable to all. -- Regards Ram 9990484446/011-46087206 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets
Dear dguille...@gmail.com,please be informed that spreadsheet is other name for work sheet. On Sat, Sep 10, 2011 at 8:24 PM, dguillett1 dguille...@gmail.com wrote: Please give clear before/after examples and how you get from before to after. Be advised that a file is called a workbook a sheet within a workbook is called a sheet or worksheet. There is NO such term as SPREADSHEET -Original Message- From: Jose Costa Sent: Thursday, September 08, 2011 3:34 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets Hi all, I'm trying to build an Excel solution that would do the following: - User select a given spreadsheet/worksheet/column(**sample below), where file location may vary and exchange rate column will vary (based on Month) - Allows target selection: User selects target spreadsheet(s) and worksheet(s) within spreadsheet(s) User selects currency and amount columns for each worksheet/ spreadsheet User defines target rates (CAD and USD) into target columns (e.g. CAD @ G, USD @ I) Logic converts values and writes to target columns Currency Name Currency Code Base Rate Nov10 Dec10 Jan11 UNITED STATES DOLLARS USD CAD 1.026115 0.997437 1.001006 ALGERIA DINARS DZD CAD 0.013764 0.013383 0.013726 ALGERIA DINARS DZD USD 0.013414 0.013417 0.013712 ARGENTINA PESOS ARS CAD 0.257947 0.251244 0.249783 ARGENTINA PESOS ARS USD 0.251383 0.251889 0.249532 ARUBA GUILDERS AWG CAD 0.573249 0.557227 0.559221 ARUBA GUILDERS AWG USD 0.558659 0.558659 0.558659 AUSTRALIA DOLLARS AUD CAD 0.984433 1.019336 0.997949 AUSTRALIA DOLLARS AUD USD 0.959379 1.021956 0.996946 BAHAMAS DOLLARS BSD CAD 1.026115 0.997437 1.001006 BAHAMAS DOLLARS BSD USD 1.00 1.00 1.00 BAHRAIN DINARS BHD CAD 2.721465 2.645160 2.655154 BAHRAIN DINARS BHD USD 2.652203 2.651957 2.652485 BANGLADESH TAKA BDT CAD 0.014586 0.014118 0.014139 Can you help? Thanks in advance! JC -- --**--** -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/** exceldailytip http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/**groups?gid=1871310http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.**blogspot.comhttp://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.**comhttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.**comhttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com ** Like our page on facebook , Just follow below link http://www.facebook.com/**discussexcelhttp://www.facebook.com/discussexcel -- --**--** -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/** exceldailytip http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/**groups?gid=1871310http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.**blogspot.comhttp://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.**comhttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.**comhttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com ** Like our page on facebook , Just follow below link http://www.facebook.com/**discussexcelhttp://www.facebook.com/discussexcel -- Regards Ram 9990484446/011-46087206 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel