$$Excel-Macros$$ Re: QC results update tool
Hi Nevin, I am also looking for similar solutions, please let me know if you have figured out the solution of uploading test result from excel to Quality Centre. Thanks, Tushar On Wednesday, November 7, 2012 10:28:45 AM UTC+11, Nevin wrote: Hi Friends, Did you guys find time to look into my Question.I tried a lot but was unsucessfull today. Below code is what we used for connecting quality center with no sucess.This code might work for QUality center 10. But in HP ALM(Quality center 11) methodologoy is slightly different after entering user name,password we need to click on the authenticate button then we need to select domain,Project and then click on the Login button. It failes wehn we used the connect method (QCcon.Connect Domain, Project).Iam suspecting it has to do something with the authentication button Please suggest me. Sub CreateConnection() Dim qcUser As String Dim qcPassword As String Dim qcDomain As String Dim qcProject As String Dim qcHostName As String qcUser = Username qcPassword = Password qcDomain = DomainName qcProject = ProjectName Set QCcon = CreateObject(TDApiOle80.TDConnection) QCcon.InitConnectionEx HP ALM url QCcon.Login UserName, Password QCcon.Connect Domain, Project MsgBox connection established End Sub On Wednesday, October 31, 2012 11:49:01 AM UTC-5, Nevin wrote: Hi Friends, Iam not able to find the right kind of code which is used to connect QC test lab folder using macros.Objective is to update around 1200 tc using macros. It would be great if somebody is guiding me and iam very new to using macros.. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Formula Required
please share the example . Enjoy Team XLS On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur prabhakarthak...@gmail.com wrote: Dear Team, I need a formula for create unique ID. Unique ID=first character of first Name + last name first character + dob + first character of Home Town. Name Dob Town Ram Kumar 15-Oct Kota Ram kumar Mishra 18-Sep Patna Ram rajat kumar Mishra 20-Jul Delhi Thanks, Prabhakar Thanks, Prabhakar Thakur New Delhi +919953736776 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Formula Required
Hi, Example like this Name Dob Town Ex Ram Kumar 15-Oct Kota RK15102013KA Ram kumar Mishra 18-Sep Patna RM18091988PA Ram rajat kumar Mishra 20-Jul Delhi RM20072013DI Thanks, Prabhakar Thakur New Delhi +919953736776 On Tue, Oct 22, 2013 at 3:36 PM, xlstime xlst...@gmail.com wrote: please share the example . Enjoy Team XLS On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur prabhakarthak...@gmail.com wrote: Dear Team, I need a formula for create unique ID. Unique ID=first character of first Name + last name first character + dob + first character of Home Town. Name Dob Town Ram Kumar 15-Oct Kota Ram kumar Mishra 18-Sep Patna Ram rajat kumar Mishra 20-Jul Delhi Thanks, Prabhakar Thanks, Prabhakar Thakur New Delhi +919953736776 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Fwd: Most people think there’s only one way to use Excel’s VLOOKUP
-- Forwarded message -- From: My Online Training Hub webs...@myonlinetraininghub.com Date: Tue, Oct 22, 2013 at 9:16 AM Subject: Most people think there’s only one way to use Excel’s VLOOKUP To: Kuldeep Singh naukrikuld...@gmail.com ** [image: logo] Home |http://clicks.aweber.com/y/ct/?l=8_pdkm=LOiHI6Kx_WUPXZb=Dj81qQIoyXZlL7xPANaX4gBlog | http://clicks.aweber.com/y/ct/?l=8_pdkm=LOiHI6Kx_WUPXZb=VV0hroxiwxZ3ldbq4t0hlQ Loginhttp://clicks.aweber.com/y/ct/?l=8_pdkm=LOiHI6Kx_WUPXZb=xjsMs.UoIhqsKFKJuf.5RA -- Hi Kuldeep, VLOOKUP is my favourite Excel Formula! It helps me get analysis and calculations done in minutes that would take hours manually. And I find I have the occasion to use it all the time. Interestingly there's two ways you can use it but I find that most people know one way or the other, and only a few know both. One way to do a VLOOKUP is what I call the Sorted List VLOOKUP, but more on that soon. In this tutorial we're going take a look at the VLOOKUP Exact Match version of the formula, but first let's set the scene. In the list below we want to calculate a commission in column F for each builder. But each builder has a specific commission rate they are entitled to. Thankfully we have this information in a table to the right, and this is where we give VLOOKUP the opportunity to strut its stuff. [image: Excel Vlookup Formula]* * * * *Microsoft Excel describes the VLOOKUP formula as:* VLOOKUP(lookup_value, table_array, col_index_num ,range_lookup) * * *And to translate it into English it would read:*find this value, in that table, return the value in column x of the table, but only return a result if you can match the value exactly) Let's make it even clearer by applying it to our example: VLOOKUP(find the name Doug from cell B2, in the Commission Rates table H2:I9 , return the value in column 2 of the table, but only return a value if you find the exact name Doug in the Commission Rates table, otherwise give me an error) * *[image: Excel Vlookup Formula] * * *Firstly let me clarify some points:* 1) *'Return the value in column 2 of the table' *is referring to the column number in the table H2:I9, not the column number of the spreadsheet. The information we want returned is the percentage rate, and it is in the second column of the Commission Rates table. 2) *'Only return a result if you can match the value exactly'* is telling Excel that we only want information returned if it matches our criteria exactly. i.e. Find Doug in our Commission Rates Table, and if you can't find Doug, give me an error. The error displayed will be #N/A. On the other hand, if we told Excel it was ok to *not* find an exact match, it would return the next best result. i.e. If Doug wasn't in our Table Excel would return the next best result. In this example we wouldn't want it to do that, but this option is handy in other situations which we'll cover in another tutorial. OK, now that's clarified, in Excel our VLOOKUP formula in column F for the above example would be: =VLOOKUP(B2,$H$2:$I$9,2,FALSE) Note: Where 'FALSE' is telling Excel we want it to find an Exact Match only. Our Excel table would then look like this with the VLOOKUP formula in column F: [image: Excel Vlookup Formula]* * You'll notice in the formula bar above there are '$' signs around the reference to the table H2:I9. This is called an absolute reference and it allows us to quickly copy the formula down column F without Excel dynamically updating the table range as we copy. *How can we make this VLOOKUP formula even better?* Assuming the end result of our example exercise is to actually calculate the commission $ amount, we could make this formula even better by doing this in one step in column F. Let's say commission is calculated as Total $k x Commission %, our formula in cell F2 would read: =VLOOKUP(B2,$H$2:$I$9,2,FALSE)*E2 And in seconds we can have hundreds of VLOOKUP's and calculations done! [image: Excel VLOOKUP Formula]* ** * * * *VLOOKUP Rules, Common Mistakes and Troubleshooting!** * 1) VLOOKUP formulas read from left to right. You must have the information you are looking up (in our example Doug in the Commission Rates Table), in a column to the left of the information you want returned, in our example the 'percentage rate'. i.e. it has to go 'Doug', then '% rate'. Excel wouldn't be able to find it if it went '% Rate' then 'Doug'. 2) You can have as many columns as you like in your Table, just so long as you follow the 'left to right' rule above. 3) The 'Table' you are looking up can be in the same spreadsheet, or a different sheet in the same workbook, or in a different workbook altogether. 4) The table doesn't have to be sorted in any particular order, but you must not have duplicates, unless the information on each duplicate is exactly the same. For example, if Doug appeared twice in our Commission Rates table with different percentage rates for each instance,
Re: $$Excel-Macros$$ Formula Required
As Requested, PFB the solved one. Regards, Anoop Sr. Developer On Tue, Oct 22, 2013 at 3:36 PM, xlstime xlst...@gmail.com wrote: please share the example . Enjoy Team XLS On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur prabhakarthak...@gmail.com wrote: Dear Team, I need a formula for create unique ID. Unique ID=first character of first Name + last name first character + dob + first character of Home Town. Name Dob Town Ram Kumar 15-Oct Kota Ram kumar Mishra 18-Sep Patna Ram rajat kumar Mishra 20-Jul Delhi Thanks, Prabhakar Thanks, Prabhakar Thakur New Delhi +919953736776 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. UniqueID.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Formula Required
PFA updated with little change as described above. On Tue, Oct 22, 2013 at 4:18 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: As Requested, PFB the solved one. Regards, Anoop Sr. Developer On Tue, Oct 22, 2013 at 3:36 PM, xlstime xlst...@gmail.com wrote: please share the example . Enjoy Team XLS On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur prabhakarthak...@gmail.com wrote: Dear Team, I need a formula for create unique ID. Unique ID=first character of first Name + last name first character + dob + first character of Home Town. Name Dob Town Ram Kumar 15-Oct Kota Ram kumar Mishra 18-Sep Patna Ram rajat kumar Mishra 20-Jul Delhi Thanks, Prabhakar Thanks, Prabhakar Thakur New Delhi +919953736776 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. UniqueID v0.2.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Extract data in worksheet in xml format to another sheet
Hi guys I have an excel that has 44800 lines(I have a xml that I insert in the excel), it is inventory information, my doubt is How can I copy the lines that start with quantity unitOfMeasure.? To another sheet? Thank you very much -- Best Regards, Jorge Marques -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: Continuation of VBA for Excel to Word
Still getting error 462 every other time I run the macro. not sure how to beat this error. On Monday, October 21, 2013 8:21:02 AM UTC-7, Justin Pulley wrote: I don't know how to mark something uncompleted. The code works every other time. code Sub CreateReportPDF() Dim wdapp As Word.Application Dim wddoc As Word.Document Run CopyData Set wdapp = Word.Application Set wddoc = wdapp.documents.Add Application.ScreenUpdating = False wdapp.Visible = True With wddoc.PageSetup .Orientation = wdOrientLandscape .PageWidth = InchesToPoints(17) .PageHeight = InchesToPoints(11) End With For Each sh In Worksheets(Array(Power Report, ATS Data)) ThisWorkbook.Sheets(sh.Name).UsedRange.Copy With wdapp .Visible = True .Selection.Paste End With Next Application.CutCopyMode = False Application.ScreenUpdating = True wddoc.SaveAs2 MyDocuments \ Power Report Format((Date), mm - dd - yy) Format((Time), hhmm) 'change file name as u like MsgBox The power report has been generated and saved to your My Documents Folder wddoc.Close wdapp.Quit Set wddoc = Nothing Set wdapp = Nothing End Sub /code The first time you run the routine it works no issues. The next time you run the routine it fails on error 462. Then you can run it again and it's fine. Error 462 occurs every other time. I have tried every fix I can find for that error and none of it seems to work. There are some sites that claim you should not use a With command when using a word application object. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Formula Required
another way :) =UPPER(LEFT(A2,1)LEFT(TRIM(RIGHT(SUBSTITUTE(A2, ,REPT( ,99)),99)))TEXT(B2,DDMM)LEFT(C2,1)RIGHT(C2,1)) On 22-10-2013 17:51, Anoop K Sharma wrote: PFA updated with little change as described above. On Tue, Oct 22, 2013 at 4:18 PM, Anoop K Sharma aks.sharm...@gmail.com mailto:aks.sharm...@gmail.com wrote: As Requested, PFB the solved one. Regards, Anoop Sr. Developer On Tue, Oct 22, 2013 at 3:36 PM, xlstime xlst...@gmail.com mailto:xlst...@gmail.com wrote: please share the example . Enjoy Team XLS On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur prabhakarthak...@gmail.com mailto:prabhakarthak...@gmail.com wrote: Dear Team, I need a formula for create unique ID. Unique ID=first character of first Name + last name first character + dob + first character of Home Town. Name Dob Town Ram Kumar 15-Oct Kota Ram kumar Mishra 18-Sep Patna Ram rajat kumar Mishra 20-Jul Delhi Thanks, Prabhakar Thanks, Prabhakar Thakur New Delhi +919953736776 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you