All Tags » macro (RSS)

Browse by Tags

  • Macro Doesn't Work in Word 2007

    User has a macro that inserts and formats a text box in a Word document. The Macro works great in Word 2003 and it works in Word 2007 when in compatibility mode. When the user converts the document to the new .docm format the macro stops working. The macro errors out with a Run-Time error '5917'...
    Posted to Word (Forum) by microsoft on 03-12-2010
  • How do I query an Excel 2007 table using VBA in Access 2007?

    Background: I have an Excel file, used for data tracking purposes, with columns of information changing depending on the month and year when the file was downloaded from the server. I can't tap into the server using SQL or something else, and I can't stop the output file from randomizing some...
    Posted to Access (Forum) by microsoft on 03-12-2010
  • How to add a variable to the .vcproj? (Microsoft Visual Studio project)

    Hi, How can I add a variable that represents some value used in configuration of a project? To be more concrete, I have the C++ project that uses a library of some version (here wxWidgets 2.8.10 but think about it in general). The version of the library is placed in some specific directory (here c:\wxWidgets...
    Posted to Visual Studio Express (Forum) by microsoft on 03-10-2010
  • Macro security level and digital signature setting on terminal services

    Hi I am aware there are a number of posts already with a similar issue, however this appears to be on a machine by machine basis. I have a terminal server that users run an application on which essentially is a access database. A copy is made from the source when run which the individual user then works...
    Posted to Access (Forum) by microsoft on 03-06-2010
  • Excel question, macro for summing a group of cells sharing a similar attribute and pasting summed data below

    Hi, I sell clothing, I need to count the number of times an item style is listed, ignoring the size, and then copy and paste the data into the fields below. Here is an example. The data is in 5 fields Item # Style Brand Color Size 5275 Ziggy Electric Navy/Tan S 5276 Ziggy Electric Navy/Tan M 5277 Ziggy...
    Posted to Excel (Forum) by microsoft on 03-05-2010
  • What does this excel macro do?

    Hi, What does this excel macro do? I have them from EE but just cant remember ... An help to explain what these 2 macros do Sub ChangeToPropercode() For Each cell In ActiveSheet.UsedRange cell.Value = WorksheetFunction.Proper(cell.Value) Next cell End Sub And the below code Regards Sharath Code Snippet...
    Posted to Excel (Forum) by microsoft on 03-01-2010
  • Message Bar Check Box Disabled.

    Hi, I have OFFICE 2007 installed and I have a word file with some macros. If my macro security settings are set to ENABLE ALL MACROS it works fine if I set macros security settings to DISABLE WITH NOTIFICATION, when I open the file I got e message box from "Visual Basic for Application" telling...
    Posted to Word (Forum) by microsoft on 02-27-2010
  • Gotorecord function in Macro

    Experts: I have a macro that use the action "GoToRecord" and the record is "next ". When I run this macro which runs on a form I get this error message when it hits the last record "record cannot be specified maybe reached the end of recordset". How can avoid this message...
    Posted to Access (Forum) by microsoft on 02-25-2010
  • Excel 2007/2003 compatibility - how to remove the _xlfn. from IFERROR

    I have users on 2003 who want to access a spreadsheet we use created under 2007. The 2007 spreadsheet contains lots of formulas such as : =IFERROR(VLOOKUP(G$3,'Week 1'!$A:$H,6,FALSE),0)*1.175 I know IFERROR is not supported under 2003, which is where the problem occurs I created a module in the...
    Posted to Visual Interdev (Forum) by microsoft on 02-25-2010
  • How can I exclude these values from a range?

    brettdj: gave me an excellent way of conditionally formatting cells with values that matched sheet names. Define Named Range: sNames =SUBSTITUTE(GET.WORKBOOK(1),"["&GET.WORKBOOK(16)&"]","") Conditional formatting formula =NOT(ISNA(MATCH(L3,sNames,0))) I have used...
    Posted to Visual Interdev (Forum) by microsoft on 02-23-2010
Page 1 of 61 (608 items) 1 2 3 4 5 Next > ... Last ยป