$$Excel-Macros$$ Re: Excel blog of the month : Chandoo.org
Hi, I have been regularly visiting this site www.chandoo.org for past couple of years. His comments on various things like dashboarding and charting have been really helpful. Regards, Anand Kumar On May 1, 10:25 pm, Ayush Jain jainayus...@gmail.com wrote: Dear group, As the part of discussexcel.com initiative, we declare Excel bog of the month each month. This is done to appreciate indvidual Excel bloggers and encourage excel blogging. *Chandoo.org* has been selected as blog of the month for *April 2011*. This is a great excel blog which is very active in sharing tips, tricks data analysis techniques regularly. The blog is managed by *Purna Duggirala* who is Microsoft MVP since 2009. I have published the more info on discussexcel.com. Please do visit by clicking this *link*http://www.discussexcel.com/blog-of-the-month/blog-of-the-month-2011/... for more information. *Another great news : We are 7800 strong now...Just 200 away from 8000 milestone...Invite your friends and colleagues to be part of this great group. Thanks* Best regards, Ayush Jain Group Manager -- -- 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
$$Excel-Macros$$ problem in if else function
Hi I am trying to write a code: I want to Call Test only if all the criteria fulfilled or else this should keep msging to get the details.. not able to finish it. Pls help. * * * * *Sub if_Save()* *If Sheet2.Range(M5) = Then* *MsgBox (Please enter Name)* *ElseIf Sheet2.Range(M6) = Then* *MsgBox (Please enter Code)* *ElseIf Sheet1.Range(P5:P9).count 5 Then* *MsgBox (Please fill all the details)* *End If* *Call Test* *End Sub* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - April'11
Congrat Ashish a deserving one! On Sun, May 1, 2011 at 12:57 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Congrate Ashish.. Please keep it continue... On Sun, May 1, 2011 at 10:09 PM, Ayush jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of April'11 He has posted 57 posts in April 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and achieved this recognition from last five months consecutively.This is really awesome. ASHISH, Many Many thanks for the incredible support to group. *I have published the same on discussexcel.com homepage.* Regards Ayush Jain Group Manager -- -- 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 -- -- 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 -- syed aliya -- -- 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
$$Excel-Macros$$ Need Help
Dear, pls let me know how i can create excel macros in MS ACESS 2003. thanks in advance... regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ problem in if else function
Hi, Sub if_Save() If Sheet2.Range(M5) = Then MsgBox (Please enter Name) ElseIf Sheet2.Range(M6) = Then MsgBox (Please enter Code) ElseIf Sheet1.Range(P5:P9).count 5 Then MsgBox (Please fill all the details) Else Call Test End If End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Pravin Kumar Envoyé : lundi 2 mai 2011 10:38 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ problem in if else function Hi I am trying to write a code: I want to Call Test only if all the criteria fulfilled or else this should keep msging to get the details.. not able to finish it. Pls help. Sub if_Save() If Sheet2.Range(M5) = Then MsgBox (Please enter Name) ElseIf Sheet2.Range(M6) = Then MsgBox (Please enter Code) ElseIf Sheet1.Range(P5:P9).count 5 Then MsgBox (Please fill all the details) End If Call Test End Sub -- -- 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Help
Create a Object of Excel in Access...the work with that Object. On Mon, May 2, 2011 at 5:44 PM, rohit gupta gupta1.ro...@gmail.com wrote: Dear, pls let me know how i can create excel macros in MS ACESS 2003. thanks in advance... regards, -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ problem in if else function
*Sub if_Save()* *If Sheet2.Range(M5) = or **Sheet2.Range(M6) = or ** Sheet1.Range(P5:P9).count 5** **Then* *msgbox (Pleaes FullFill Entry Vbcrlf Name Shoud Be Enter Vbcrlf Code Should be Correct Vbcrlf Value Should be lesser then 5, vbinformation* else * * *Call Test* * End If* *End Sub* On Mon, May 2, 2011 at 2:07 PM, Pravin Kumar pravin.si...@gmail.com wrote: Hi I am trying to write a code: I want to Call Test only if all the criteria fulfilled or else this should keep msging to get the details.. not able to finish it. Pls help. * * * * *Sub if_Save()* *If Sheet2.Range(M5) = or **Sheet2.Range(M6) = or ** Sheet1.Range(P5:P9).count 5** **Then* *msgbox (Pleaes FullFill Entry Vbcrlf Name Shoud Be Enter Vbcrlf Code Should be Correct Vbcrlf Value Should be lesser then 5, vbinformation* else *End If* *Call Test* *End Sub* -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Help in Access
Dear Maries, Thanks a lot, for help. Is it possible to get all information from original tables for these unmatched items Regards, Prashant -Original Message- From: Maries [mailto:talk2mar...@gmail.com] Sent: 02 May, 2011 5:13 PM To: excel-macros@googlegroups.com Cc: Prashant Subject: Re: $$Excel-Macros$$ Help in Access Hi Prashant, Find the attachment... I hope that it will bring unmatch as per your new tables... Code: SELECT Lanpos.Match FROM Lanpos LEFT JOIN Bank ON Lanpos.[Match] = Bank.[Match] WHERE (((Bank.Match) Is Null)) UNION SELECT Bank.Match FROM Bank LEFT JOIN Lanpos ON Bank.[Match] = Lanpos.[Match] WHERE (((Lanpos.Match) Is Null)); Regards, Maries. On Mon, May 2, 2011 at 10:51 AM, Prashant pawleprash...@gmail.com wrote: Dear Maries, Sorry for delayed reply, many thanks for below code, it worked fine for that table. But I tried to use that union function in my actual data sheet, coz of my limited knowledge not able to get desired results. Attaching herewith two data tables namly bank lanpos , only match is the common filed. I want unmatched data as a my query results from both data tables Thanks once again Regards, Prashant -Original Message- From: Maries [mailto:talk2mar...@gmail.com] Sent: 30 April, 2011 10:26 PM To: excel-macros@googlegroups.com Cc: pawleprash...@gmail.com Subject: Re: $$Excel-Macros$$ Help in Access Hi Prashant, Find the attached file.. I hope this will fulfill your requirement... We can arrive it with help of union query by using following SQL codes. SELECT Bank.card, Bank.aut, Bank.amt FROM Bank LEFT JOIN lanpos ON Bank.[card] = lanpos.[card] WHERE (((lanpos.card) Is Null)) UNION SELECT lanpos.card, lanpos.aut, lanpos.amt FROM lanpos LEFT JOIN Bank ON lanpos.[card] = Bank.[card] WHERE (((Bank.card) Is Null)); Regards, Maries. On Sat, Apr 30, 2011 at 4:54 PM, Prashant pawleprash...@gmail.com wrote: Dear All, I am trying to create unmatch data query thru access. I have two tables namly bank lanpos, my qry is throwing only unmatched data from lanpos table, where as I want unmatched data of both tables as my result Please help. Regards, Prashant -- -- 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 -- -- 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
$$Excel-Macros$$ Re: Macro to print a filtered data in into word or pdf file
Chris, Use Sub ExportToPDF() ActiveSheet.Range(A6:J15000).ExportAsFixedFormat Type:=xlTypePDF, _ Filename:= _ Environ(USERPROFILE) \Desktop\Myoutput.pdf, Quality:= _ xlQualityStandard, IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=True End Sub but before that, please reduce your print area. It currently has some 750 pages!! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help in Access
Hi Prasath, Both table data heading description is not matching except MATCH field. Also no. of column is not same. because of this two reasons, it is difficult to combine respective content with unmatch datas. If you rectify above, we can bring all information. Regards, Maries. On Mon, May 2, 2011 at 5:36 PM, Prashant pawleprash...@gmail.com wrote: Dear Maries, Thanks a lot, for help. Is it possible to get all information from original tables for these unmatched items Regards, Prashant -Original Message- From: Maries [mailto:talk2mar...@gmail.com] Sent: 02 May, 2011 5:13 PM To: excel-macros@googlegroups.com Cc: Prashant Subject: Re: $$Excel-Macros$$ Help in Access Hi Prashant, Find the attachment... I hope that it will bring unmatch as per your new tables... Code: SELECT Lanpos.Match FROM Lanpos LEFT JOIN Bank ON Lanpos.[Match] = Bank.[Match] WHERE (((Bank.Match) Is Null)) UNION SELECT Bank.Match FROM Bank LEFT JOIN Lanpos ON Bank.[Match] = Lanpos.[Match] WHERE (((Lanpos.Match) Is Null)); Regards, Maries. On Mon, May 2, 2011 at 10:51 AM, Prashant pawleprash...@gmail.com wrote: Dear Maries, Sorry for delayed reply, many thanks for below code, it worked fine for that table. But I tried to use that union function in my actual data sheet, coz of my limited knowledge not able to get desired results. Attaching herewith two data tables namly bank lanpos , only match is the common filed. I want unmatched data as a my query results from both data tables Thanks once again Regards, Prashant -Original Message- From: Maries [mailto:talk2mar...@gmail.com] Sent: 30 April, 2011 10:26 PM To: excel-macros@googlegroups.com Cc: pawleprash...@gmail.com Subject: Re: $$Excel-Macros$$ Help in Access Hi Prashant, Find the attached file.. I hope this will fulfill your requirement... We can arrive it with help of union query by using following SQL codes. SELECT Bank.card, Bank.aut, Bank.amt FROM Bank LEFT JOIN lanpos ON Bank.[card] = lanpos.[card] WHERE (((lanpos.card) Is Null)) UNION SELECT lanpos.card, lanpos.aut, lanpos.amt FROM lanpos LEFT JOIN Bank ON lanpos.[card] = Bank.[card] WHERE (((Bank.card) Is Null)); Regards, Maries. On Sat, Apr 30, 2011 at 4:54 PM, Prashant pawleprash...@gmail.com wrote: Dear All, I am trying to create unmatch data query thru access. I have two tables namly bank lanpos, my qry is throwing only unmatched data from lanpos table, where as I want unmatched data of both tables as my result Please help. Regards, Prashant -- -- 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ HELP SECOND MAIL
Hi it would be great if u could explain some steps; it seems confusing, keep it as simple as you can; which is the first step, what are the 6 vlookups ? which workbook contain base data of your pivot. On Mon, May 2, 2011 at 10:07 AM, Prathima R prathima@gmail.com wrote: Hi Experts, Due size constance i am sending in two zip folders please check second mail for excel files dump. (This is Second mail please check this one as well -- thanks for cooperation) This report is sent on daily basis please help in this concern if it is automated it could be very much thankful really wonderful thing . please find the attached sop and zipped folder which contains all the raw data . Please kindly help in this concern if it is possible . it has 6 v lookups and two pivot tabs. Thanks for your help in advance. Regards, Prathima -- -- 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 -- -- 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
$$Excel-Macros$$ cdbl to a string with D
Hi, I have just run across a problem while converting a string to a double using cdbl in VBA. I am using Excel 2003. VB produces the same value (3.282E+63) while converting these 2 string to double: 3282D0060 and 3282E0060. Side note: Since Excel automatically converted 3282E0060 to a scientific notation when the value is pasted into Excel I have a UDF to convert it back to its orgininal format (string). Am I doing something wrong or Is this Microsoft Excel problem? Thanks. lmn -- -- 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
$$Excel-Macros$$ Copy/Paste Code
For the life of me I can not figure out why this code will work fine if more than 2 or more rows are Copied and Pasted. But if only one row is copied and pasted It will not work. Any help at all, please! Thanks in advance! The code stops at ActiveSheet.Paste Private Sub CommandButton2_Click() 'Copy contents from Worksheet2 Columns A B Sheets(Worksheet2).Select Range(B3).End(xlDown).Select Temp1 = ActiveCell.Address Range(A3 : Temp1).Select Selection.Copy 'Paste contents on next available blank row on Part Numbers Surface Area in Columns A B Sheets(Part Numbers Surface Area).Select Sheets(Part Numbers Surface Area).Range(A2).End(xlDown).Offset(1).Select ActiveSheet.Paste Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False End Sub -- -- 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
$$Excel-Macros$$ Web Data Queries
I just downloaded the Excel 2007 Web Data Add-in...I have two general questions: 1. I cant seem to get a web page from a secure server (https) to load...are there any issues here? 2. I have gotten data from a page like Yahoo finance, but once the data is imported it is static...how do you keep the data dynamic. For example how do you have the DJIA (Dow Jones Industrial Average) change in the spreadsheet as soon as it changes in Yahoo? Im guessing these questions may be addressed in the tutorial, but the link to the tutorial is broken...so I would appreciate any insights. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Outlook 2007 Calendar Meeting Setup to Excel 2007
see this link , that's what you need http://office.microsoft.com/en-us/outlook-help/export-calendar-data-to-excel-HP001087241.aspx Chilexcel 2011/4/27 Susan 1 sunni...@gmail.com Hi, Does anyone know if it is possible to import or export an Outlook calendar template into Excel 2007. See attached of the page I'd like to be able to either iimport into Excel from Excel, or export out of Outlook into Excel. Or can I somehow save an extension .ics as .xls or .xlsx? Thanks, ~Sunnie -- -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- 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