Answer Questions

• stefan.w Setting Chart Title through VBA sometimes works sometimes doesn't.

  Hello folks, Wonder if anyone has the solution to the following problem. Got an Excel addin that the user can use to generate Charts. The users are very lazy and want the addin to set the titles for the chart as well as for the axis. When I tested the code everything works fine and the charts including it's titles are set. Everyone is happy. However in certain spreadsheets the code throws an error. Method 'HasTitle' of object '_Chart ...Show All

• Xtian Mendoza 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

• Jason_25 VS Code Editor

  Hi, I've seen numerous examples people implementing the Windows Forms Designer in their application, I was wondering if it's possible to do something similar with the Code editor too   I would like to offer my users the capability of writing their own plug-ins.  It is ok if VS has to be installed on their PCs. I've asked this question many times before, and just had a lot of deer in headlights faces stare back at me. Cheers. Paul ...Show All

• jg3333 After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. The code in blue below may help. MacroSave is my global variable Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim sa As Boolean sa = SaveAsUI If Not MacroSav ...Show All

• Gino Abraham how to close a userform in workbooks.open method

  I am trying to open excel file which has a userform opening in Workbook_Open() method. I need to close that userform when i open that excel workbook. should i pass any parameters to Workbooks.Open , so that the user form will be closed automatically. Is any way to handle that. Hello, Can you not just remove the code that opens the userform . or better you could write th ...Show All

• Morgan1339 Questions on ISV's and regarding end users

  1) Are there different types of ISV programs If so, what are the differences between the programs   2) How does the Royalty program differ from other ISV programs 3) Does each program offer different benefits to the end customer   4) How does the Royalty program differ from other ISV programs to the end customer     5) Does Microsoft have a brochure or a list of the benefits for the end c ...Show All

• patelucla provider cannot found with MDAC 2.8 Win XP sp2

  Hi, We have an app that is part VC 6 and part VB6/VBA, we have a fair number of installed on WIN XP SP2 with XP SP2 We've just installed on a brand spanking New Sony Vaio laptop with a preinstalled XP Pro sp2 image, and get a "provider cannot be found" msesage when the vb element of our app connects to a data source via ADO. The VC6 element of the app has at this point already successfully connected via ODBC. Problem occurs w ...Show All

• MartinaM Extracting Text from body of Outlook email into excel

  Can anyone help me to finish off this code I am extracting text from the body of email messages in Outlook into Excel. The email messages are standard format and look like this: Questions answered by: joy smith ID #:25555 Total number of questions answered: 20 Total number of incorrect answers: 3 Grade as percentage: 85 % List of question(s) with incorrect answers. The incorrect choice is in brac ...Show All

• zzhao Protecting the Source Code

  I have a couple of spreadsheets that have VBA code in them. I wish to share these projects with other employees but I am leary of doing so because I don't want them to claim the work I did as their own or screw it up somehow. Is there a way I can protect my code Is there a way to insert a digital signature that others can't edit Thanks Tiger Hello Tiger, You can add a password to prevent people lo ...Show All

• AlbyRock87 VBA in EXCEL - Connect to SQL Server

  I am a new programmer try to write some VBA codes in excel to get data out from the Sql server database. When I try to compile the codes, it said "compile error: user defined typed not defined" for the following sentences Dim dbsCurrent As Database Dim qdfPassThrough As QueryDef Dim qdfLocal As QueryDef Dim rstTopFive As Recordset Dim strMessage As String What I need to define for Database,recordset or QueryDef Please help! ...Show All

• Robert Bruckner Can not generate Proxy class for web service from Excel 2003

  When I have used web services references in Excel 2003 to generate Proxy class for web service, some web services have been generated proxy classes successfully. However, I got a problem with some other web services, the web services toolkit does generate all the proxy classes. but it throw me the error at the end as "You must open a document or load a project before you can create Web service proxy classes, and you must have full pe ...Show All

• Ben Pryor MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. ...Show All

• Mike Ut VBA macro from office 2000 excel does not run after downloading current office 2000 upgrades

  I have a large/significant macro (program) with dialogs that has been working just fine on various previous Windows OS's until now. The last version was Win ME. I have Office 2000 for all this time. Now I have upgraded to Win XP and I don't remember if I had ever executed the macro/program for a short time under the SP1 version. I have just recently upgraded to SP2 with all it's changes. I would have executed it twice per month for payroll ...Show All

• microvibratom Runtime error 1004 when adding a seriescole to a chart

  Hi all, this is a very stubborn problem of VBA and I have had to deal with it for years already: Excel version 2003 Error: Runtime error '1004' Unable to set the name property of the series class the macro creates several graphs with multiple seriescollections. Strangely, the first couple of graphs work perfectly! only after a couple of graphs the macro stops at the line ".Seriescollection(ibatch).name = batchfile(ibatch ...Show All

• Morten Teinum Vote

  Current MSDN Universal subscribers get a free upgrade to their choice of one of the Team editions of Visual Studio 2005 when its released.  What about current EmpowerISV members   And what will future members get   I'm planning on joining the program, but I want to be sure I know what my team will be  getting long-term, especially as it relates to Visual Studio Team System. I understand tha ...Show All