Answer Questions

• Gene Belknap 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

• Dan400Man Printing by using a vba code

  Hi Gents I would like to get excel to print the lables I have created just by pressing the button. Now I know how to record macros and get them to work but in this case it is necessary to know some vba code i guess. Say that today I have created 7 lables and I want excel to print those 7 lables by pressing the button......The problem is that the number of lables changes every day....So How could I get excel to recognise the number of l ...Show All

• VicIbar LCS complience with IMS / SIP standards ?

  1. It seems, to register to Live Communication server from a SIP client, NTLS or Kerbaros authentication is a must. How to register from a SIP client which doesn't support NTLS or Kerbaros Is there any configuration required on LCS to acheive the same 2. If LCS doesn't support HTTP Digest Authentication then its not interoperable with SIP standard rfc 3261 and IMS Please correct me if I am wrong Please revert back !!! Best R ...Show All

• phantastikfan jump to other slides of a ppt by selecting slide number from a combobox

  can anyone tell me how jump to other slides of a ppt by selecting slide number from a combobox how will u first additems to the combobox and then how will you switch to the slide number selected in that combobox thanks in advance amzzz plz someone tell me this...a bit urgent thanks amzzz Hey thanks for trying atleast!! I wasnt hoping anybody would respond.....but thanks Actua ...Show All

• briandra3 report won't run

  Hello all, I have a form that has a unbound field based on a query. Next to it, I have a command button to preview a report based on the selection of the unbound field. For example, a user selects a location from the drop down list. They click the preview button but it's returns a blank report. I have the exact same code on the same form to view a name selected the same way and it works perfectly. Can someone tell be why it doesn't work for loca ...Show All

• Olejka Uniscribe

  What are the current plans with Uniscribe Other than MSDN documentation and only one sample app (please correct me if there are more), it makes me worry about future support. Comment Here is some additional information on UniScribe: As mentioned, Uniscribe is still very much alive and being maintained. We have added support for additional scripts for Vista , and we will continue to work on expanding script ...Show All

• DDressel1 Where is the command button on microsoft visual basic

  Hey, I was wondering if anyone knew where the command button is for Microsoft Visual Basic 2005 express edition. I need to use the command button, and I cant find it, even after using the help button. Can someone please tell me where I can find it. Any help is appreciated. Thanking you in advance, Neil. Hello Neil, The command button should be in the toolbox. If you add a form and display it in design ...Show All

• Krieg38 Excel 2000 - macro not found

  I developed an Excel 2003 spreadsheet with an embedded worksheet form button with an assigned macro written in VBA. The Excel file is hosted on a web server. User will open the Excel file from a web page via IE browser. Customer's Thailand branch office says it doesn't work. So far we tested with Excel 2003 in Singapore branch and no problems at all. I found out that the Thai branch users are running Excel 2000, but don't know if there a ...Show All

• Steve C# Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?

  In a Excel PivotTable, I want to programically hide or show some PivotItems of a PivotField.  To hide, it works fine (just set mPivotField.PivotItems("xxx").visible = False).  However, to show, it does not work: mPivotField.PivotItems("xxx").visible = True.  Program breaks with an error 1004, macro error. When try to record a macro for setting a non-visible PivotItem to visible, macros recorded is to use ...PivotItem("xxx").visi ...Show All

• Josh_G Hyperlink to a subroutine

  Is it possible to get an hyperlink to run a subroutine I managed to get the hyperlink to go to the subroutine but it doesn't actually run it. Thanks for your prompt reply. I am trying in Excel. Here is the code I want to execute from the hyperlink. It is in a module called mdlMain. Option Explicit Public Sub FinishIt()     Application.DisplayAlerts = True     ThisWorkbook.Sav ...Show All

• Kenneth Mitchell extract office file's title into excel

  hi guys! I have a folder which included many office excel and word files. these files have a file properties as "QMS-DOCUMENT-NO", which is created by myself when I create the file. New file will be add into this folder frequently. two questions: 1. I want to creat a excel file consolides what i have in this folder. it shall shows the file "name", "Title", and "QMS-DOCUMENT-NO". is there an automa ...Show All

• Michael Riffel [URGENT] Need Help for "Error 1004: SaveAs Failed"

  I run my VBA macro in a excel file which shown the message "Error 1004: SaveAs Failed". Then I have found that the possible reason(s) for occuring this error: 1. The command "Application.DisplayAlerts = False" failed to run 2. The command "ActiveWorkbook.SaveAs Filename:=sOFnp, FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False" can run but it's still show the error message (when sOFnp ...Show All

• Joe Lutz xp style to vba forms

  hi, i would like to apply the xp theme to my msforms in (excel) vba.  i have not been able to find any information on doing this.  i saw this done in a stand alone xla so i know it works.  any help would be greatly appreciated. -b Per the support engineer: On my side, it is also the same. The reason is that, to  display XP style 1. The display properties on Windows system n ...Show All

• Paulo Silva Jr. Programmatically inserted inline image is dithered in Word 2003

  I am inserting a .tif as an inline image into a Word document. In Word 2003 the image is dithered. Word 2000 Word 2003 (difference in size is due to monitor resolution in Virtual PC) This is how the image is diplayed and printed. Code: 'Logo Dimensions (in inches) Global Const LOGO_HEIGHT As Single = 2 Global Const LOGO_WIDTH As Single = 2 '************************************************************************************** ...Show All

• wscrivens 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