Answer Questions

• Rajesh R VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• MitchV What significant contribution has Microsoft made to the US Government?

  Hey all...i dont know if this is the proper place to post this but i needed a fast answer... I am doing a report on Microsoft, and i stumbled upon a question that i for some reason cant quite answer...What significant contribution has Microsoft made to the US Government Hi, The agency that handles Microsoft Public Policy and Governmental Affairs is: The Glover Park Group Wa ...Show All

• VBnerd Do we qualify for an ISV buddy?

  Hope this is the right place to ask a question like this. I apologize if it is not. I am a developer for an IT group within the Federal Aviation Administration. Would we qualify for an ISV Buddy We don't actually sell software but we do develop software for other federal govenment agencies. If we don't qualify is there a program similar to ISV buddy within Microsoft that we may qualify for Thanks in advance. Doug ...Show All

• sereleg Difference between FORMS and CONTROL TOOLBOX

  Hello there, my questions goes to the difference between using the FORM TOOLBAR or the CONTROL TOOLBOX When do I have to use each one Are they both Visual Basic for Applications It is the same SAVING A MACRO and CREATE ONE in the Editor The difference between programming in a SHEET, MODULE or a USER FORM I have just started today with VB, I am used working with MATLAB (Engineering Program) but in most organizations used VBA, so eventhough ...Show All

• Zeonz Program levels requirements

  Hello, the requirements for Microsoft partnership is based on partner points. Generally the points an be accumulated through certifications of application, solution or technical. Why don't you consider also the MVP award Thanks, Pierre Hi Mustafa, partner points follows some rules (here the italian version http://www.microsoft.com/italy/partner/partnering/program_2005/crediti.mspx  and english one https://partner.microsoft. ...Show All

• ctartman getting web pages from VBA?

  Dear VBA gurus, I would like to open and process a web page in a function in VBA version 6. (I am calling VBA from Excel 2000.) Thank you! k - coro Below an example of reading a table on a web-page Making More Posible ;-) Kind regards, Dirk Option Explicit Sub CreateWebQuery() ' ' CreateWebQuery Macro ' Macro recorded 31-01-2006 by cDirk Bouwman With ThisWorkbook Sheets.Add ActiveSheet ...Show All

• Bimlesh Visual Studio vs SharePoint/Front Page

  What is the 'connection' between these two seemingly unrelated development tools I have been reading some evangelical blogs on the sharepoint v3 site, and it seems as though Sharepoint v3 will offer a lot of "infrastructure" (security, web parts, asp.net) for business-oriented / collaboration / scheduling web sites that may require a lot more effort using Visual studio. From the look of things, it's apparent to me that Microsoft is be ...Show All

• noslen Event handling for dynamically created control on userform

  hi, I am creating few controls say a command button on an userform(which is created either during design time or run time). Now I want to add an event handled to this command button. How do I do it CreateEventProc adds events to controls on userforms I tried it but couldn't. I could see samples which add events to Class modules using CreateEventProc. But I couldnt find one for adding events to controls created on userforms. I am using excel ...Show All

• GNE VBA Out Too?

  Started by ncaplan at 03-14-2005 11:02 AM. Topic has 1 replies. VBA Out Too I just read an article stating the elimination of VB. I'm totally shocked! http://news.zdnet.co.uk/software/developer/0,39020387,39190953,00.htm   What about VBA, is that going to end as well We have and still are developing so many automated processes using VBA, it would have a major impact on our company. ...Show All

• Limason Office 10 \ winword.exe runtime error

  I have downloaded the service pack 3 but I'm still encountering the problem when I try to open MS Word. MS Excel, MS Outlook , MS Powerpoint & MS Viso all work fine. Any time I try to open MS word I receice a Box vissual c++ runtime library. This application has requested the runtime to terminate it in an unusaul way. Microsoft Office\Office 10\Winword.exe. Hello I have been having exactly the same probl ...Show All

• Dev Chris ACCESS 2003 OLE

  How to insert link (local folder) into ole field named “station layout” (control source for bound object frame named “station layout bound” on form “station layout”) ! The files in the local folder are named the same as the field named “Station ID Number” From table “Station Information” The last part of the link = the value in “Station ID Number” field from table “Station Layout”! THANKS FOR YOUR HELP! ...Show All

• Michael Oberhardt Selecting Data By....

  the color of a cells Is this possible Tiger ASAP Utilities ( http://www.asap-utilities.com/ ) is a free Excel add-in loaded with lots of useful tricks. One of them is the ability to select cells based on color. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com Hi tiger, Yeah it should be. This is code that sets the colour of a selected c ...Show All

• Bose vlookup on unions

  I have two ranges on a sheet; rngOne and rngTwo, they both contain 2 columns and 5 rows of random numbers I want to run a vlookup in VBA on the union of the two ranges so I run the following code:   Sub test()     Dim a As Range, b As Range, c As Range, d As Range     Set a = Range("rngOne")     Set b = Range("rngTwo")     Debug.Print Application.VLookup(0.52011206 ...Show All

• NicoV Program code fro sorting coloumns in a listbox VB Excel

  Hi I have in my UserForm a listbox, where I capture the A2:G10 in Spreadsheet1 And my problem is that I want to manage to click on the column header (in the listbox of the userform) to sort the coloumns. I hope that someone pls can help me sort this out! tullaolsen;)   Hi Derek and Wassim, Thank you for your help! I have now managed to get a sorting code for the commando button. Thank you both! The ...Show All

• msulmanch Help On Error GoTo

  Hi Everyone, I`m creating a Workbook that protect and unprotect the sheets... The part of protect and unprotect is ok! But, the part of tratament of errors I don't get to do... I want that when the workbook show the error, it go to Erro: Hi, This solution not resolved my problem... Sub desp_ws() On Error GoTo Erro Dim pa pa = ActiveSheet.Name Application.ScreenUpdating = False For Each ws In ActiveWorkbook.Sheets ...Show All