Answer Questions

• Mcduck Worksheet.Copy causes execution to stop

  Hi I am experiencing an odd behaviour from my VBA code in Excel. I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way. My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing. <CODE> On Error GoTo ERROR: Worksheets(SN_MonthYearAct).Copy After:=Worksheets(Worksheet.Count) .... ERROR: MsgBox(Err.Description) </CODE> The variable SN_MonthYearAct is a constant containing the string "MonthYear Act", and a sheet with this name does exist. Worksheet.Count returns currently 8, and there are 8 sheets in the workbook. I have trie ...Show All

• Ramraj_Velmurugan 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. Here's a list of support articles that I ran across regarding runtime issues with Word that might be helpful while the support engineer looks into your issue. http://support.microsoft.com/search/default.aspx qu=Office+10+%5C+winword.exe+runtime+error -brenda (ISV Buddy Team) I'm having the same problem as well after using PCMover - una ...Show All

• kjsteuer Testing for a Null date/Time field

  This is driving me mad, it should be all so simple, I have a date/time field on an Access form that I want to test if it is unfilled (null), if so put a check in a checkbox field, so .. if me.reminded = null then is what I'm doing, but it seems that the field is NEVER null (even though it is, str(me.reminded) gives an "Invalid use of Null" error) Someone help before this laptop goes through the window Thanks a million Hi See IsNull Function e.g. if isnull(me.reminded) then ...Show All

• ttfo Challenge writing a macro for setting Mergefields properties

  Hi, I have about 400 Word documents which all use the same set of MergeFields in different layouts. I need to figure out a way to write a macro which will loop through all the MergeFields in a doc and set the "Preserve formatting during updates" checkbox. When I manually did this for a field and recorded a macro, the code that got generated was: WordBasic.FormatField Field:="MERGEFIELD ReqDate " ...which didn't really help since it created a new field when I ran it. Is there any way I can do this Thanks, JGP   OK, so this hack seems to work for me in Word 2003, but I can't claim any "best-practice-ness" about it.  So take it with a caveat that furt ...Show All

• Lucian Wang Access 2000 RecordSet Sort problem

  hi there, using ms access 2000 with vb 6.3. I am using a form with a button to first off filter results in a table and copy all the relevent rows into a temp table so that additional tasks can be performed. This works successfully. Part of the problem is that the order in which the data is entered into the first table means it is never in order (this cannot be prevented due to the nature of how the data is imported from several excel documents) The temp table needs to be sorted so that the calculation algortihms will be able to calculate and generate revelent infomation. Currently defining and opening a recordset and after moving all the data to the temp table i am using: recordset.Sort = "TextValue desc" Where TextValue is my co ...Show All

• Kestutis Limit Macro to current workbook

  I have two Excel files with two macros in each one. One Macro Protects the all Worksheets and the other one Unprotects them. The difference between files is that one needs a password protection and other one doesn't. If I don't have both files open at the same time, they work fine, but as soon as I'm working with both files at the same time, then macros from one file can be used in the other one. Is there a way to avoid that and to limit macros from other files being execute when they share the same Shortcut keys. Here a sample code for the file with Password protection: Sub UnprotectSheets() ' ' UnprotectSheets Macro ' Macro recorded 7/12/2006 ' Keyboard Shortcut: Ctrl+Shift+U ' Dim shtCurrent As Worksheet Dim strP ...Show All

• PeterVrenken Can i embed MS Access database inside Visio and query it using VBA

  Hi , Iam Deepu. Is it possible to embed an MS access database file in a Visio drawing and when i click on a shape, query and display the information related to the shape from the database in a msgbox or so My requirement is that i do not want an additional file to be carried along with the visio document. That is why i wanted to embed it in the same drawing. Welcoming all your suggestions. Thanks. Deepu Hello Deepu, I doubt very much you will be able to embed a database into a visio document, but that doesn't mean you cannot embed the data. For example you could have a module that contains all the data you want to search as an array or as a collection. Its not a database in the classic ...Show All

• createdbyx Unable to infopath form in browser

  ERROR: The form cannot be displayed in the browser because the use of session cookies has been disabled in the current browser settings. In order to load the form, session cookies must be allowed. Any pointers would be appreciated I have the exact same error when trying to connect to some Sharepoint 2007 infopath pages which are in the Local Intranet Zone. Path: WrkTaskIP.aspx ID=2&List=87365a5d-e84f-42fb-9244-28abe8dfbee9&_InfoPath_Sentinel=1 According to Microsoft all cookies are automatically accepted from Web sites in the Local Intranet zone. So why am I getting this error. I have changed my IE privacy setting to "always allow session cookies" but still get t ...Show All

• manasia How do I create and use 3D ranges in Excel-VBA

  It is easy to create and use 2D range in excel. The following code will do Option Explicit Sub Demo3DRange() Dim sh As Worksheet, r As Range, vData Dim Row As Integer, COl As Integer Set sh = ThisWorkbook.Sheets("Sheet1") Set r = sh.Range(sh.Cells(1, 1), sh.Cells(100, 2)) vData = r.Cells.Value For Row = 1 To 100 For COl = 1 To 2 Debug.Print vData(Row, COl) Next COl Next Row End Sub When we execute the above code, the variant vData will become a 2D array of 100*2. Now my question is following: A)How do I create a 3D range in VBA code B)Can I assign that 3D range to a variant, and get a 3D array, just as I get 2D array in case of 2D range Thanks -Rahul ...Show All

• ccutrer Help Deploying VBA changes across hundreds of Word Temlates

  I have been asked to "clean up" existing Word templates that have VBA code in them. Basically what I need to do is to remove the old code that is currently in the ThisDocument class module of the template and replace it with the new code. I've exported the "good" code to a .bas file and I have worked out how to import it back into the Word Template but the only problem I have is that I am importing it as a new module and the original code for the template is stored in the ThisDocument module. I don't know how to either clear the ThisDocument module programmatically (using VBA) or how to replace the contents of it with the "good" code. There are hundreds and hundreds of these templates and I am looking fo ...Show All

• Mike Southerland SendKeys open application

  Hi! I try to open a program from a macro in Excel and login (the Bloomberg professional, (not the website)) using SendKeys. With some help from other programmers I got the following code. It does not work at all though and I am lost. Can someone please help me with this My problems are: 1) I get error on the WaitFor …line. ”Sub or Function has not been defined” 2) If I delete the WairFor line I get error on the AppActivate("1-BLOOMBERG") line. “Illegal procedure call or argument” Sub bbg_login() AppActivate("1-BLOOMBERG") Application.SendKeys "{BREAK}",false WaitFor timevalue("00:00:01") Application.SendKeys "user_Name", false Application.SendKeys "{ ...Show All

• dnweb DLookup help?

  Hi there - im building a contact management system and require some help. I have previously had help with VBA in terms of defining what users can and cant do within the system when logging in via a username and password which was incredibly useful. Im now at further along the route and now want to incorporate an activity system that will record all hours that employees will have worked against clients. However we have a lot of clients! The users login name('login_name' which is held in 'tblusers') is also entered into a 'leadofficer' field in 'tblcompany' so that we know which user is responsible for managing that client - this is done through a combo box on the company entry form so it looks up the values from the table 'tblusers'. On th ...Show All

• jim- I am unable to move down in excel cells by VB code

  I need to move by two cells down in excel by writing a code in visual basic by the click of a cammand button Example: Now I am in cell A10 and I need to be moved by two cells down by pressing a cammand button. That is after clicking the cammand button My active cell should be cell A12. Try the following Sub X() Dim rngCurrent As Range Set rngCurrent = ActiveCell ActiveSheet.Cells(rngCurrent.Row + 2, rngCurrent.Column).Select End Sub Thanks PSHK The codes given by you are perfect for my programme and I found it works the way I expected. Regards... Ajamilan Sub Y() ActiveCell.Offset(2).Select End Sub - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTec ...Show All

• Arska opc

  I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it Genius That's a wee bit over the top, let's just say I've experienced a thing or two about OPC. However, if you're fishing for a response, flattery will get you everywhere :) As the other replies pointed out, the question is a bit open ended. 'using .NET technology' offers a few possibilites, depending on your develpoment language C#, VB.NET, managed C++, etc. The easiest way, would be to make use of the OPC Client .NET wrapper supplied by the OPC Foundation. You do have to ...Show All

• mareczek84 ComboBox itemData as Long => error

  Hi, I have a problem with a ComboBox. It is in fact a ListBox, containing String. These String are getted from a database (Oracle 9i), and their ids are big (300 000 for example), which does nto fit in an Integer. So when a do this : Set rstListe = cmdDefliste.Execute cmb_ListeOrg.Clear If Not rstListe.EOF Then Do While Not rstListe.EOF cmb_ListeOrg.AddItem CStr(rstListe.Fields(1)) cmb_ListeOrg.ItemData(cmb_ListeOrg.NewIndex) = CInt(rstListe.Fields(0)) rstListe.MoveNext Loop Else cmb_ListeOrg.AddItem "Aucun organisme trouve" End If I have an error saying that I have a "depassement de capacite" in french, so that the capacity of itemData is too small. How ...Show All