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'...

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...

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...

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...

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...

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...

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...

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...

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...

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...