Answer Questions

• j2associates Comparing and filtering data in Excel?

  I’ve been given the task of comparing two sets of employee data, both of which are in the same layout/format, and am required to filter out those which are duplicates i.e. should leave only new starts. I have been told that a Vlookup function can be used to achieve this but don’t know how it can Would this be easier to accomplish using VBA If yes, could I have a brief structure of the code required To elaborate, the spreadsheet contains a unique employee ID and other details such as department, manger, email, etc. One set of data is from the previous months upload and the other is the latest data pull. I need to compare this months data with last months and see who is present that wasn’t before. Any help is much appr ...Show All

• Jim R32874 Call Macro in Closed Workbook?

  Hey Folks, Is it possible to call a macro from a workbook that is closed Joe Yes, but it will open the workbook in order to execute the code. To call it you would use something like this, changing the path, workbook name and routine name. Application.Run "'C:\myworkbook.xls'!RunMe" Thanks. Bummer you have to open the other workbook. ...Show All

• Chris in DFW Excel2003 VBA - Application.quit not stopping code

  All, I have a problem with using the application.quit command - as I understand it, the application.quit should immediately jump to the Auto_Close (if exists) and then close any workbooks and quit Excel - however, when I run it, my code continues to run through the end of the sub (see simplified code attached): Sub test() Application.Quit MsgBox ("Test Message 1!") MsgBox ("Test Message 2!") MsgBox ("Test Message 3!") MsgBox ("Test Message 4!") MsgBox ("Test Message 5!") MsgBox ("Test Message 6!") MsgBox ("Test Message 7!") End Sub When I run this - I get 7 message boxes, then after the 7th, Excel closes. Any thoughts Thank you, ...Show All

• Speedbird186 Question for Windows wizards VBA/VBScript

  [Mods: please feel free to move this to another forum if necessary.] I noticed today while helping a co-worker debug a piece of VBScript that the IIf() function doesn't seem to be implemented in VBScript. Specifically, the function always returns Empty when called. Replacing the IIf(condition,true,false) with an If... Then... Else statement fixes the problem, but I'm curious about why this is so. My theory is this: The parent application's (in this case, Outlook's) VBScript object is created as a COM object. The pointer to "IIf()" is one of many function pointers returned by the IUnknown::QueryInterface() method. However, since the VBScript object in question doesn't support IIf(), the COM object's implementation of IIf() s ...Show All

• nwyork Can you use VBA to access a spread sheet embedded in a word doc?

  I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated. Thanks for the reply! I am incorporating the logic into a routine I am working on and will experiment with killing the excel process. I'll post back if I find pertinent information. OM Gang Yes thanks. Can you tell me what wdOLEVerbHide does and how it is different from wdOLEVerbPrimary Also, do wdOLEVerbs work ...Show All

• chxfryer Attaching Contents of a Folder

  Hi all, Using a macro running on excel, I am trying to attach the contents of a folder in Outlook. The files contained in the folder change, so it is not as simple as writing the code to attach a specific file. I need it to attach all the files regardless of the file name. Is this possible Thanks in advance Hey Andy, When I tried to run your code I got this error message, " The specified module could not be found ". How do I fix it Best Regards Cathrine Andy I am using Outlook as email client. I have tried your solution, but it still not working. Cath Hi C ...Show All

• piknik Do we need to have a strong name for webparts?

  If we use safe control, and create an assmbly in .net for all our webparts, do we need to have a strong name for this assembly, is this a requirement Figured out: We need to deploy in bin not in app_bin We need to specify the version and culture in the safecontrol tag ...Show All

• Igor Kokorin Is this possible? (newby needs help with creating a macro in Outlook 2003)

  Because of the sloppy design of the websites I support, emails I receive at work from customers arrive in plain text when submitted from the various webforms. I use an HTML signature in all of my outgoing mail, which contains links to various items and some other formatting that does not translate to plain text. What I want to do is set up a button on my outgoing mail toolbar that will first convert the plain text response to HTML. After converting to HTML, the button would paste in my complete signature and standard canned information. The format would be as follows: If anyone can help me with this it would be very appreciated. I am not asking for anyone to write the macro for me - I want to learn how. I've tried every way ...Show All

• Michael Gates SQL within a VBA Module

  Hi, I'm new to VBA and have only been using it for 3 months, so please don't laugh! I have a VBA routine in Excel, which connects to a SQL Server database, and I need to know how to incorporate an IF expression into the SQL statement. The SQL looks like this in the MS Access query I am trying to re-create: SELECT IIf(IsNumeric([PromoSource]),"REC",IIf(IsNull([PromoSource]),"OTHER",IIf([PromoSource]="WWW","Web",[PromoSource]))) AS [Promo Source], Count(dbo_tblCustomers.CustomerID) AS CountOfCustomerID FROM dbo_tblCustomers WHERE (((dbo_tblCustomers.DateEntered)>=#1/1/2006#)) GROUP BY IIf(IsNumeric([PromoSource]),"REC",IIf(IsNull([PromoSource]),"OTHER",IIf([PromoSource]= ...Show All

• swagatika_m problem printing with IE 6.0.2 (hopefully resolved in IE 7)

  I created an HTML webpage so that the output was structured on the paper. It took some time adding a <BR> here , removing a <BR> there, Finally I was down to my last <BR> to remove (it was one line too long on the first page). I removed the <BR> and then nothing would print any more. Clicked on the printer icon, no output. The little printer icon would appear in the status line, but would never pass the job off the O/S's printer driver. I added the <BR> back in and Viola, it prints. take it out, no print. This only happens when the document in the browser takes up exactly to the end of the last page. I tried it on more than one machine with more than one printer driver (although both were PCL printers) A ...Show All

• prayami CRM 1.2 Error 80040e2f "the statement has been terminated"

  This error happens when i try to create a CRMUoMSchedule object. SOAP Server Application Faulted ...Show All

• DougMP wrong count of Records in Access.Form

  Hi, I am having troubles with the count of records in a Form. All my Tables used in my Access database are linked tables to an SqlServer. The Form I use is a wizzard created form and the recordsource is simple like "SELECT * FROM tab1 join tab2 ..". I want to display the number of records in the form, but it seems, that the recordset does not load all records at once. What i did is: Private Sub Form_Current() lblRecordCount.Caption = Recordset.RecordCount End Sub But when I open the form, it displays just "16", if i move to a record below, it changes to "28", when i scroll to the end it finally displays "100" - which is really the right count. I tried this also with a new database, where i created a table with 500 reco ...Show All

• saju Commandbar ICon (Excel VBA )

  I m making one AddIns for Excel. I have added a CommandBar. Now I can assign the ICon to CommabBar Using Pasteface method. But this is creating some Problem for me. So is there Any other way to assign Icon to Commandbar... You don't describe the problems you are having, so it's hard to make a sensible suggestion. In later versions of Office (2003 and perhaps 2002), you can modify the picture and mask propery of the button. In earlier versions you are stuck with pasteface, but you may be able to improve the quality of your image. The picture and mask technique is described in Professional Excel Development by Bullen, Bovey, and Green. This book is a must-have for any serious Excel developer. - Jon ------- Jon Peltier, Micro ...Show All

• bxchan WSD (Web Service For Device) code Generation Tool

  Hi, I am currently involved in a project for implementing WSD on printers.WSD talks about a code generation tool. Where can I find that WSDCODEGEN.exe tool Thanks Biswanath ...Show All

• Will Durning How to write a 'Find function' code in VBA for Excel

  Hi, I wrote this code in hope that it would look for the text string 'c6' which is found in one of the cells in range A1:C6. In the end I want it to assign the cell's address to a variable but one thing first. Function finn(x) 'x = Range(A1:C6) Dim y, q y = x q = Application.WorksheetFunction.Find(c6, y) MsgBox q End Function But it won't work! Anyone that knows how to write this properly Grateful for help on this \Jonas Thanks for the replay. Your start combined with some additional studie of the help solved my problem. You could use a foreach construct eg dim cel as Range foreach cel in Range(A1:C6) if x = "c6" then do whatever end if next cel that should find it for you ***The syntax i ...Show All