$$Excel-Macros$$ Trying to ExportAsFixedFormat - getting error expected end of statement
Hi! I'm new to VBA and I'm trying to start out by creating a pdf out of my worksheet. This is my code: Sub PrintWorkbookPDf() ' ' PrintWorkbookPDf Macro ' ' Keyboard Shortcut: Option+Cmd+u ' ActiveWindow.SelectedSheets.ExportAsFixedFormat Type:=xlTypePDF FileName:=“sales.pdf” Quality:=xlQualityStandard DisplayFileAfterPublish:=True End Sub I get an error saying: Compile Error Expected: end of statement Thanks a lot for help! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: saving command button not functioning
thank you very much Kishan On Thu, Dec 8, 2011 at 11:37 AM, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: Please add the following code. rst.update after assigning values to the fields Also instead of using rst.fields(0), --- you can use rst.fields(fileno) which will be more legible and readable. Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(select * from t_main) rst.AddNew rst.Fields(0) = txtfileno rst.Fields(1) = txtempname rst.Fields(2) = txtempdesign rst.Fields(3) = txtdob rst.Fields(4) = txtdoj rst.Fields(5) = txtdor rst.Fields(6) = ttotyrs rst.Fields(7) = ttotmths rst.Fields(8) = ttotdays rst.Fields(9) = txtnonyrs rst.Fields(10) = txtnonmths rst.Fields(11) = txtnondays rst.Fields(12) = txtnetyrs rst.Fields(13) = txtnetmths rst.Fields(14) = txtnetdays rst.Update End Sub Regards, Kishan Reddy, K -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)
I'm getting a run-time error '424': Object required for the following code: Sub ExportPDF() Sheets(OOF2_EIF).Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=“sales.pdf”, Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub Help would be greatly appreciated! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ choose column when running macro
Hi I have a little macro that copies values from one column to another then returns the first column to zero, what I would like to achieve is every time I run the macro it either asks me which column I wish to paste value into or auto progresses through the column i.e. B Then C then E each time in runs Preferably the first where it asks me which column to paste the ranges into Code: Sub copy_hours() Worksheets(sheet1).Range(a1:a20, a22:a44).Copy Worksheets(sheet1).Range(c1, c22).PasteSpecial Paste:=xlPasteValues Dim Rg As Range Set Rg = ActiveSheet.Range(a1:a20, a22:a44) Rg.Value = 0 End Subcould anyone suggest how I might achieve this -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)
Dear Rikiko, Please use this one.. *Sub ExportPDF() Sheets(1).Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=\Sales.pdf, Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub * -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Dec 8, 2011 at 3:44 PM, Rikiko r...@openoceancapital.com wrote: I'm getting a run-time error '424': Object required for the following code: Sub ExportPDF() Sheets(OOF2_EIF).Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=“sales.pdf”, Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub Help would be greatly appreciated! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Trying to ExportAsFixedFormat - getting error expected end of statement
Hi! Thanks! I'm actually on Mac Office 2011 and it has a save as PDF option. That might be it, but I can't find a plug-in for mac... -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel to PDF
Dear Abdulgani, Please use this one, and Change your path as per your requirement... Sub exltopdf_converter() On Error Resume Next flname = Application.GetOpenFilename(MultiSelect:=True) For Each flnm In flname Workbooks.Open Filename:=flnm sheetname = ActiveWorkbook.Name ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=* D:\VBA_Class\* sheetname .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False ActiveWorkbook.Close Next On Error GoTo 0 End Sub On Sun, Dec 4, 2011 at 6:18 PM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: Dear Noorain, I have gone through your code of Excel to PDF, but it is not working. Please guide where I am wrong. Sub exltopdf_converter() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1) ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub -- Shaikh AbdulGani A R ITP, STP, TRP, STRP -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ xls to Pdf in VBA error
Dear Prabhu, Please try through below Code. Sub OnlyforActivesheet() On Error Resume Next sh = ActiveSheet.Name ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=\ sh .pdf, Quality:=xlQualityStandard, OpenAfterPublish:=True On Error GoTo 0 End Sub On Thu, Sep 1, 2011 at 10:41 PM, Prabhu prabhugate...@gmail.com wrote: Hi Noor, It is working.. If i needs to create PDF only for active sheet then how to change the above VBA code. Plz help regards, Prabhu -- -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Single Quotes at the Start and End of the data in a cell
reply to me with your file. dguillett1 @gmail.com Don Guillett SalesAid Software dguille...@gmail.com From: ajinkya natu Sent: Wednesday, December 07, 2011 8:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Single Quotes at the Start and End of the data in a cell Hello All, Firstly, Thanks for all the contribution to this wonderful community. Has been a lot of help always. Coming to my Query...I need to get the data in certain cells (text and numeric) to display single quotes at the start and the end. Have tried this saving the excel sheet in all formats. However, either the leading single quote doesn't show up in the cell itself (though 1 can see it in the formula bar) or it just goes off once u save the file (in CSV). All in all i need is for the cells to display the value as 'Excel' (text) and '256454' (Numeric). Also have tried using two single quotes. but wont suit my purpose ..just need 1 at the start and the end and the cell to display that. Would greatly appreciate the help. Thanks in advance. Regards, Ajinkya -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook
aw,gee... Don Guillett SalesAid Software dguille...@gmail.com From: Susan 1 Sent: Wednesday, December 07, 2011 11:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook Great Macro Don! Very helpful for my task... I really appreciate your assistance with this and you were also very fast at responding. You are awesome :-) Sunnie On Wed, Dec 7, 2011 at 4:51 PM, dguillett1 dguille...@gmail.com wrote: Not really. It was using the first Sunday of the current year and adding a 7 days so you would have 52 sheets. I have changed it to use Jan 1, 2012 as the starting date, adding a week for each sheet. See attached, Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Susan 1 Sent: Wednesday, December 07, 2011 6:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook So your macro works, but it is for 365 days, and now I have 365 sheets, I needed the sheets to be named according to the week dates, starting like this Jan 01-Jan 07, 2012 all the way down to Dec 30-Jan 05, 2013 Can you fix the code for me... Thanks again! On 12/7/11, dguillett1 dguille...@gmail.com wrote: Attach your final result for comments Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Susan 1 Sent: Wednesday, December 07, 2011 5:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook I believe then I'll need to make a template sheet :-)... okay thanks for clarifying it! :-) Appreciated!! On 12/7/11, dguillett1 dguille...@gmail.com wrote: The macro assumes that you do, indeed, have a sheet named Template that you want to copy and name jan 03, jan 10, etc. Don Guillett SalesAid Software dguille...@gmail.com From: Susan 1 Sent: Wednesday, December 07, 2011 2:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook I copied and pasted your code from below in a blank spreadsheet and when I run it I received the following error: Script out of range. Please advise. Thanks! On Wed, Dec 7, 2011 at 7:04 AM, dguillett1 dguille...@gmail.com wrote: This macro will copy the template and name each sheet with the start of the week (short names better) If you want the first MONDAY then change ,7 to ,8 Option Explicit Sub addsheets() Dim i As Long For i = Day(DateSerial(Year(Date), 1, 7) - _ WeekDay(DateSerial(Year(Date), 1, 6))) To 365 Step 7 Sheets(Template).Copy After:=Sheets(Sheets.Count) ActiveSheet.Name = _ Format(DateSerial(Year(Date), 1, i), mmm dd) Next i End Sub ‘= Don Guillett SalesAid Software dguille...@gmail.com From: Susan 1 Sent: Tuesday, December 06, 2011 6:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook Hi, I have project at work to create sheets in a workbook , and the sheet names are based on 2012 calendar weeks, (I've attached the workboo). I need to know if there is way to easily add the weeks of the calendar to each sheet. And Also I don't know how to eliminate the circular reference, after you open the workbook. Any help is appreciated! Sunnie -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a
Re: $$Excel-Macros$$ choose column when running macro
Easy enough but let's try to fully automate. Why skip a21?? Are you saying you want to copy/paste values to B if there is nothing in B or to C if there are values in B, to D if values in C??? Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: trawets Sent: Thursday, December 08, 2011 3:02 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ choose column when running macro Hi I have a little macro that copies values from one column to another then returns the first column to zero, what I would like to achieve is every time I run the macro it either asks me which column I wish to paste value into or auto progresses through the column i.e. B Then C then E each time in runs Preferably the first where it asks me which column to paste the ranges into Code: Sub copy_hours() Worksheets(sheet1).Range(a1:a20, a22:a44).Copy Worksheets(sheet1).Range(c1, c22).PasteSpecial Paste:=xlPasteValues Dim Rg As Range Set Rg = ActiveSheet.Range(a1:a20, a22:a44) Rg.Value = 0 End Subcould anyone suggest how I might achieve this -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)
Thanks a lot! Works perfectly! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)
1.. Sub Macro1() Dim sFile As String sFile = S:\Office Documents\Purchase Orders\ ActiveSheet.Range(F5).Text .pdf If Len(Dir(sFile)) Then If MsgBox(Purchase order number already used, Verify and correct purchase order number, vbOKOnly) = vbOK Then Exit Sub 'If MsgBox(File exists; overwrite?, vbYesNo) = vbNo Then Exit Sub End If ActiveSheet.ExportAsFixedFormat _ Filename:=sFile, _ Type:=xlTypePDF, _ OpenAfterPublish:=True, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False End SubModify above to fit your need Don Guillett SalesAid Software dguille...@gmail.com From: Rikiko Sent: Thursday, December 08, 2011 4:14 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat) I'm getting a run-time error '424': Object required for the following code: Sub ExportPDF() Sheets(OOF2_EIF).Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=“sales.pdf”, Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub Help would be greatly appreciated! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ hi can you solve this
*(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* * * *P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources.* -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ hi can you solve this
Hi Renuka, Can you more explain your query.. Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Dec 8, 2011 at 6:56 PM, Renukachari Kasee jva.ch...@gmail.comwrote: *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* * * *P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources.* -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook
Hi in Noorain's code, i would make the following change to the line that starts the same: Sheet1.UsedRange.Copy Sheets(Sheets.Count).Range(A1) then delete sheets created with sheet names from dates in sheet1 and it should work Don's code is more straightforward, something new I have to learn to be honest. Cheers, Pascal On Dec 7, 9:10 pm, Susan 1 sunni...@gmail.com wrote: I copied and pasted your code from below in a blank spreadsheet and when I run it I received the following error: Script out of range. Please advise. Thanks![?] On Wed, Dec 7, 2011 at 7:04 AM, dguillett1 dguille...@gmail.com wrote: This macro will copy the template and name each sheet with the start of the week (short names better) If you want the first MONDAY then change ,7 to ,8 Option Explicit Sub addsheets() Dim i As Long For i = Day(DateSerial(Year(Date), 1, 7) - _ WeekDay(DateSerial(Year(Date), 1, 6))) To 365 Step 7 Sheets(Template).Copy After:=Sheets(Sheets.Count) ActiveSheet.Name = _ Format(DateSerial(Year(Date), 1, i), mmm dd) Next i End Sub ‘= Don Guillett SalesAid Software dguille...@gmail.com *From:* Susan 1 sunni...@gmail.com *Sent:* Tuesday, December 06, 2011 6:25 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook Hi, I have project at work to create sheets in a workbook , and the sheet names are based on 2012 calendar weeks, (I've attached the workboo). I need to know if there is way to easily add the weeks of the calendar to each sheet. And Also I don't know how to eliminate the circular reference, after you open the workbook. Any help is appreciated! [?] Sunnie -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- --- To post to this group, send email to excel-macros@googlegroups.com 330.gif 1KViewDownload -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ hi can you solve this
Hi Renuka, Please find the attached file. I have used the below formula to solve. =SMALL(IF(D2:D11=G2,D2:D11),{7,6,5,4,3,2}) Regards, MARIES. On Thu, Dec 8, 2011 at 5:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Renuka, Can you more explain your query.. Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Dec 8, 2011 at 6:56 PM, Renukachari Kasee jva.ch...@gmail.comwrote: *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* * * *P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources.* -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Solved By Maries 08.12.2011.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Single Quotes at the Start and End of the data in a cell
Sub Quotize() Dim var As Variant Dim rng As Range Const lngColOffset As Long = 0 'Use 0 if you want to overwrite the cell value Application.ScreenUpdating = 0 Set rng = Range(B1:B10) var = Application.Transpose(rng.Value) For Each rng In rng With rng.Offset(, lngColOffset) .Formula = =' rng.Value ' .Copy .PasteSpecial -4163 End With Next rng With Application .CutCopyMode = 0 .ScreenUpdating = 1 End With End Sub Sam Mathai Chacko On Thu, Dec 8, 2011 at 6:34 PM, dguillett1 dguille...@gmail.com wrote: reply to me with your file. dguillett1 @gmail.com Don Guillett SalesAid Software dguille...@gmail.com *From:* ajinkya natu natu.ajin...@gmail.com *Sent:* Wednesday, December 07, 2011 8:38 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Single Quotes at the Start and End of the data in a cell Hello All, Firstly, Thanks for all the contribution to this wonderful community. Has been a lot of help always. Coming to my Query...I need to get the data in certain cells (text and numeric) to display single quotes at the start and the end. Have tried this saving the excel sheet in all formats. However, either the leading single quote doesn't show up in the cell itself (though 1 can see it in the formula bar) or it just goes off once u save the file (in CSV). All in all i need is for the cells to display the value as 'Excel' (text) and '256454' (Numeric). Also have tried using two single quotes. but wont suit my purpose ..just need 1 at the start and the end and the cell to display that. Would greatly appreciate the help. Thanks in advance. Regards, Ajinkya -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ $$ excel - macro $$
Hi experts I urgently need help with a code.Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do --* copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete)* the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet :eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ $$ excel - macro $$
can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh garge...@hotmail.com wrote: Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ $$ excel - macro $$
Hi Ashish, Thanks for your reply.Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data.Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick last date for which the data was updated and update data for all dates after that. One thing i would like to inform is that the destination data and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks again for the help. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:16:52 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh garge...@hotmail.com wrote: Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do --* copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Ashish Koul http://www.excelvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com code 1 try.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ $$ excel - macro $$
It would be helpful to post your code and/or file (if allowed) Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 10:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ $$ excel - macro $$ Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ $$ excel - macro $$
Hi Don, Thanks for the reply and i dont have a code ready , i tried a lot but nohing seemed to work and please find the attached sheet. Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data.Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick last date for which the data was updated and update data for all dates after that. One thing i would like to inform is that the destination data and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:09:11 -0600 It would be helpful to post your code and/or file (if allowed) Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 10:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ $$ excel - macro $$ Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com code 2 try.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ $$ excel - macro $$
Try this Sub UpdateMasterFileSAS() Set ss = Sheets(source sheet) Set ds = Sheets(destination sheet) dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1) ss.Cells(sr, 1).Resize(100, 7).Copy ds.Cells(dlr + 1, 1) End Sub Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 11:00 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Hi Ashish, Thanks for your reply.Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data. Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick last date for which the data was updated and update data for all dates after that. One thing i would like to inform is that the destination data and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks again for the help. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:16:52 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh garge...@hotmail.com wrote: Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Ashish Koul http://www.excelvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Macro to Paste excel cells to powerpoint as picture
Dear Joseph, Please try through below link.. http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-1.html On Thu, Dec 8, 2011 at 10:45 AM, joseph.cam...@gmail.com wrote: Hi Macro team, I have a lot of tables in excel that I need to paste on powerpoint. Please help me. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ $$ excel - macro $$
Hi Ashish I had just one more question and i just thought about it that is for the first of every month the destination workbook would be blank as no data would have been consolidated and this code doesn't work.Please help. Once again thanks for all the help. Thanks and Regards, Gargee Singh From: garge...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 22:58:21 +0530 Hi Ashish, Thanks for such quick reply and time. This is fantastic :) .Completely meets my requirements. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:51:54 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com open destination file run the macro and choose the source file On Thu, Dec 8, 2011 at 10:44 PM, gargee singh garge...@hotmail.com wrote: Hi Don, Thanks for the reply and i dont have a code ready , i tried a lot but nohing seemed to work and please find the attached sheet. Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data. Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick last date for which the data was updated and update data for all dates after that. One thing i would like to inform is that the destination data and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:09:11 -0600 It would be helpful to post your code and/or file (if allowed) Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 10:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ $$ excel - macro $$ Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.
RE: $$Excel-Macros$$ $$ excel - macro $$
Hi Don Thanks for your time and help , one fellow group member helped me with the code and it seemed to work fine. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:24:55 -0600 Try this Sub UpdateMasterFileSAS() Set ss = Sheets(source sheet) Set ds = Sheets(destination sheet) dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1) ss.Cells(sr, 1).Resize(100, 7).Copy ds.Cells(dlr + 1, 1) End Sub Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 11:00 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Hi Ashish, Thanks for your reply.Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data. Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick last date for which the data was updated and update data for all dates after that. One thing i would like to inform is that the destination data and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks again for the help. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:16:52 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh garge...@hotmail.com wrote: Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Ashish Koul http://www.excelvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure.
Re: $$Excel-Macros$$ Macro to Paste excel cells to powerpoint as picture
Thanks Noorain. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 8 Dec 2011 23:01:08 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to Paste excel cells to powerpoint as picture Dear Joseph, Please try through below link.. http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-1.html On Thu, Dec 8, 2011 at 10:45 AM, joseph.cam...@gmail.com wrote: Hi Macro team, I have a lot of tables in excel that I need to paste on powerpoint. Please help me. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ $$ excel - macro $$
in that case u can type the staring date of month manually in cell a2 in destination file before you run the macro rember date fromat should be same On Thu, Dec 8, 2011 at 11:11 PM, gargee singh garge...@hotmail.com wrote: Hi Don Thanks for your time and help , one fellow group member helped me with the code and it seemed to work fine. Thanks and Regards, Gargee Singh -- From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:24:55 -0600 Try this Sub UpdateMasterFileSAS() Set ss = Sheets(source sheet) Set ds = Sheets(destination sheet) dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1) ss.Cells(sr, 1).Resize(100, 7).Copy ds.Cells(dlr + 1, 1) End Sub Don Guillett SalesAid Software dguille...@gmail.com *From:* gargee singh garge...@hotmail.com *Sent:* Thursday, December 08, 2011 11:00 AM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ $$ excel - macro $$ Hi Ashish, Thanks for your reply.Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data. Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick last date for which the data was updated and update data for all dates after that. One thing i would like to inform is that the destination data and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks again for the help. Thanks and Regards, Gargee Singh -- Date: Thu, 8 Dec 2011 22:16:52 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh garge...@hotmail.com wrote: Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* ** *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
Re: $$Excel-Macros$$ $$ excel - macro $$
Minor correction to mine Sub UpdateMasterFileSAS() Set ss = Sheets(source sheet) Set ds = Sheets(destination sheet) slr = ss.Cells(Rows.Count, 1).End(xlUp).Row dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1) ss.Cells(sr + 1, 1).Resize(slr, 7).Copy ds.Cells(dlr + 1, 1) End Sub Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 11:41 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Hi Don Thanks for your time and help , one fellow group member helped me with the code and it seemed to work fine. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:24:55 -0600 Try this Sub UpdateMasterFileSAS() Set ss = Sheets(source sheet) Set ds = Sheets(destination sheet) dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1) ss.Cells(sr, 1).Resize(100, 7).Copy ds.Cells(dlr + 1, 1) End Sub Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 11:00 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Hi Ashish, Thanks for your reply.Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data. Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick last date for which the data was updated and update data for all dates after that. One thing i would like to inform is that the destination data and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks again for the help. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:16:52 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh garge...@hotmail.com wrote: Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Ashish Koul http://www.excelvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners
RE: $$Excel-Macros$$ $$ excel - macro $$
Hi Ashish Yes , that's what i had thought, seems a good idea. Thanks for the help once again.. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 23:18:02 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com in that case u can type the staring date of month manually in cell a2 in destination file before you run the macro rember date fromat should be same On Thu, Dec 8, 2011 at 11:11 PM, gargee singh garge...@hotmail.com wrote: Hi Don Thanks for your time and help , one fellow group member helped me with the code and it seemed to work fine. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:24:55 -0600 Try this Sub UpdateMasterFileSAS() Set ss = Sheets(source sheet) Set ds = Sheets(destination sheet) dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1) ss.Cells(sr, 1).Resize(100, 7).Copy ds.Cells(dlr + 1, 1) End Sub Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 11:00 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Hi Ashish, Thanks for your reply.Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data. Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick last date for which the data was updated and update data for all dates after that. One thing i would like to inform is that the destination data and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks again for the help. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:16:52 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh garge...@hotmail.com wrote: Hi experts I urgently need help with a code. Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do -- * copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i cannot delete) * the condition to copy data is that the code should copy data from the next applicable date for which there is no data in the destination sheet : eg: if the destination sheet has data only till 6 dec then the code should copy data for 7 8 December and exclude all the data for 6th december Please help me as this is urgent and if i have not followed the correct path to post a query please let me know so that I can follow the correct route. Everyone's time on this is sincerely appreciated. Thanks and Regards, Gargee Singh -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Ashish Koul http://www.excelvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum
Dear Haseeb I am surprised of your wonderful command Alt+0160 in Find What box: and click Replace All can you brief that what is the meaning of 0160 with Alt command is there further more commands available in excel. Regards, Aamir Shahzad On Wed, Dec 7, 2011 at 10:54 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Also, select col_E press Ctrl+H to activate Find/Replace, from the keyboard NUMERIC side (right side of the keyboard, not the top row) Press Alt+0160 in Find What box: and click Replace All. Now you can do a simple SUM. Or use this Array Formula, =SUM(IFERROR(--SUBSTITUTE(E2:E18,CHAR(160),),0)) ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Sumproduct for multiple criteria lookup
Dear group, I have got an excel file getting sales volume of different customers in buying different services on a daily basis. I want to use sumproduct formula to get the sales volume buying services on a monthly basis. However, the desired results are not found. Please help. -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Excel Sumproduct questions.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup
Dear Darwin, Please see attached sheet. Hope it will help you.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Dec 9, 2011 at 8:03 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Dear group, I have got an excel file getting sales volume of different customers in buying different services on a daily basis. I want to use sumproduct formula to get the sales volume buying services on a monthly basis. However, the desired results are not found. Please help. -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Excel Sumproduct questions(Solve).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup
Thanks Noorain, I got the problem solved!! 2011/12/9 NOORAIN ANSARI noorain.ans...@gmail.com Dear Darwin, Please see attached sheet. Hope it will help you.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Dec 9, 2011 at 8:03 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Dear group, I have got an excel file getting sales volume of different customers in buying different services on a daily basis. I want to use sumproduct formula to get the sales volume buying services on a monthly basis. However, the desired results are not found. Please help. -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ I want to do or learn VBA coding and MACRO
Dear All, I don't know anything about macrosand about programming or VBA to create and use macros. But I want to do or learn seriously. Can anybody help me related this. Related basic book or rule or anything plz guide me how can I proceed. Regards LAKSHMAN 9582279261 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Convert XLS to XML
Hi Gurus, I need a macro to convert the content of the file into xml format and the converted file should get saved on desktop in .xml format. Sample file attached. Please help! -- Regards Iqbal Merchant -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Input_Sheet.xls Description: MS-Excel spreadsheet