Answer Questions

• Zero_ Can anybody explain this code for me ???

  please tell me what's going on here. Does the string "\[*\]" have a special meaning Do Selection.Find.ClearFormatting With Selection.Find .Text = "\[*\]" .Wrap = wdFindContinue End With Selection.Find.Execute Selection.Delete Unit:=wdCharacter, Count:=2 Loop While Selection.EndOf(Unit:=wdSection) Selection.StartOf Unit:=wdStory Regards, GJVH What the code does is search for a bit of text between square brackets, including the square brackets. To work properly, this line should also be included after With Selection.Find: .MatchWildcards = True The backslash in front of the square brackets tells Word to look for square brackets, since otherwise, they are wildcard characters t ...Show All

• MDesigner Using FindWindow API to Get Focus and Send keys to a window

  I have put together some code in VBA to naviate to a webpage in IE, wait for it to load, find a hyptertext link on the page named "spreadsheet", click it, wait for the "download file" window to load and the go through the process of saving the file into a specific directory using send keys. The problem is, I am constantly losing focus on the windows. My code actually repeats itself 21 times for different webpages I am downloading this spreadsheet from. I need help finding the windows that I need to send keys to. Below is a sample piece of the code to navigate to one webpage: I have put notes to reflect where I am having issues. They are throughout this code and in red Function import_atl_aspec() '(Button As In ...Show All

• MA2005 Reading PDF files from VBA

  Hi Does anyone know if it is possible to access the text in a PDF file from VBA, and if so what references etc are required I have a number of multi page price lists from suppliers that I want to work with in Excel, I have tried using the PDF tool to copy text, but when I paste to Excel there are a number of transpostions in the text which make unusable No, they're not. You can deploy Acrobat Pro to your client machines by purchasing the appropriate license. Hi, How we can deploy Acorbat professional on the client side. Are they providing any redistributables   Harish I seem to recall that Adobe offers an API SDK for doing just this. For old ...Show All

• stockcrack Adding a command button to the toolbar or menu bar in Excel?

  Hi I'm wondering is it possible to add a command button to the toolbar or menu bar in Excel using VBA I came across an excel file before in work that somebody had setup this way but not sure how to go about it! I basically have two buttons that I would like to have added to the toolbar or menu to make the sheet tidier and enable the user to see all the data without having to move the buttons etc. http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_buttons.jpg Any ideas folks Thanks, Scott Thanks Derek. I'm not sure where this fits into the code I've tried it in a new module as part of a sub routine but it brings up errors such as variable not defined etc. can you p ...Show All

• John Oliver (UK)MSP, VSIP searching and copying text in drawing layer?

  greeting, i'm looking for some pointers on how to go about searching and manipulating text in the drawing layer... we use the drawing layer for diagrams. we need to: 1- search and replace strings in the drawing layer; 2- copy strings from the drawing layer into the cells in a spreadsheet... i've searched some of these web sites and found little on this topic... preferably, i'd like to get a script that can do this, or alternately get enough information to write a script to accomplish these tasks... i have excel version 11 on osx 10.4- thanks for any advice anyone can offer- ...Show All

• alimuradjamali wrong count of Records in Access.Form

  Hi, I am having troubles with the count of records in a Form. All my Tables used in my Access database are linked tables to an SqlServer. The Form I use is a wizzard created form and the recordsource is simple like "SELECT * FROM tab1 join tab2 ..". I want to display the number of records in the form, but it seems, that the recordset does not load all records at once. What i did is: Private Sub Form_Current() lblRecordCount.Caption = Recordset.RecordCount End Sub But when I open the form, it displays just "16", if i move to a record below, it changes to "28", when i scroll to the end it finally displays "100" - which is really the right count. I tried this also with a new database, where i created a table with 500 reco ...Show All

• Shanewho what is wrong with this formula? *9 Views & no one knows?*

  =IF((Weeks!D(B1+6))="",1,2)   whats the error with this D(B1+6) is ment to respresent a cell with D    = the value of B1+6   what am i getting wrong Hello Milkshake, This is only a suggestion, but I prefer to stay away from "hard coding" values in my statements. eg If Sheets("Weeks").Cells(B1Value + 6, i).Value = "" Then Sheets("Add Details").Cells(x + 2, "G"). Value = 1 Else Sheets("Add Details").Cells(x + 2, "G"). Value = 2 End If Next x It is better to use declare and use variables instead, this leaves you much more scope for later and is much easier to incorporate code in loops if required. If you remembe ...Show All

• laja access2003 code modules can not be read after a compile and compact and repair

  after finishing up some code behind a form in access 2003 I compiled the database then compacted it. After that I could not access the code modules. I would get an error that the module did not be opened. Any help would be good downard26@msn.com Have a read of this http://archive.baarns.com/excel/develop/vbaperfm.asp especially the bit about opcodes an excodes. I think something has happened to your project relating to these codes, meaning the code might be lost. There could be a repair tool that might fix it or maybe a decompiler. Can you export You got a backup I can not import and forms that has code or modules. I have not created a MDE. I did get and error when it was compiling but ...Show All

• egr9546 MS Office document and image writer print driver & port

  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. I dont have the port, nor the driver on my XP installation. How do I install thanks Borge Hello, I have the opposite problem. I have users who have had the icon for the Office Document Image Writer deleted under Printers and Faxes. ...Show All

• Amde .Net Version in the future?

  Hello, I am wondering are we going to have a .Net Version of Office in the near future. The most important function I want to get out of it, is the multiple library version control. This probably not going to help my current version issues, but I hope we start to using .Net multi-library-version-control as early as possible for the future. Thanks. Hi, yes the next version of Office will take advantage of .NET (Office 2007), although I'm not sure how they are going to do it. I'm under the impression that there might not be a development IDE and instead you need to use Visual Studio for development. You can use .NET right now for developing with Office. There is a Visual Studio addin pack, VSOT (Visual S ...Show All

• axelfxxx Code for end of month activity submission in an activity system

  Hi there - can anyone help with my syntax - when a user presses the submit command button i want the date that they have entered into an unbound drop down date field called 'dls' to be inserted into a field called 'datelastsubmitted' into 'tblusers' and it should enter it against the appropriate user who is logged in (this logged in users are stored in a global variable called 'loginname'). Her is my syntax: Private Sub submit_Click() Dim sql As String dls = Me!dls Dim rsdbase As Database Dim rstemp As Recordset Set rsdbase = CurrentDb Set rstemp = rsdbase.OpenRecordset("INSERT INTO tblusers[datelastsubmitted] VALUES dls WHERE tblusers[loginname] = '" & loginname & "'") DoCmd.RunSQL sql End Sub ...Show All

• rchokler How to create a menu & submenu ?

  Hello, I’m beginner on Access-VB. I try to create a menu and sub-menu programmatically. I can create a menu but not sub-menu. Could you help me Here my code. ------------------------------------------ Sub SubMenuCreation() Dim MyMenubar As CommandBar Dim NewMenu As CommandBarControl Dim MyNewMenu As CommandBarControl Dim NewMenuCtrl As CommandBarControl Set MyMenubar = CommandBars.ActiveMenuBar Set NewMenu = MyMenubar.Controls.Add(Type:=msoControlPopup, Before:=10, Temporary:=True) NewMenu.Caption = "Menu" If Mid$([Forms]![frmLogin]![Acces], 11, 1) = 1 Then Set NewMenuCtrl = NewMenu.Controls.Add(Type:= ...Show All

• collide IsError function from VBA6.3 to v6.0

  Hi All, I'm having problems with a small VBA script that I wrote in v6.3 but need to implement in 6.0. Excel 2002 -> 2000. The following code works fine in the later version: For i = 2 To LastRow ' select the next row based on loop vString = "A" & i If IsError(Application.VLookup(Range(vString).Value, vRange, 31, False)) Then Y = "NEW" Else Y = Application.VLookup(Range(vString).Value, vRange, 31, False) End If ' write the result to the active workbook Cells(i, 31).Value = Y Next i But won't work in the earlier version as there's a type mismatch at the If Iserror ... line. Any ideas why or thoughts on a workaround Thanks, Steve. ...Show All

• SQLme Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following: Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039) as well, the Alerts won't install because of the message: Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components I understood that this version was compatible with SQL 2005. Any idea how to bypass these checks and install the software properly Been able to resolve a couple of the issues: You must install the AS/2000 piviot table services (PTSLite) in order for the installer to proceed even if you're not planning on using this feature. Hopefully, the installer will be update ...Show All

• Andreia M ADO Recordset CursorType Property

  I want to create an updateable recordset, whereby the values in a particular field in the recordset once opened are changed to something else if certain conditions are met. However, I do not want these updates to change the underlying datasource, otherwise I would be in trouble! I would therefore need to set the recordset's cursor type property prior to opening the recordset, of which there are 4 constant values: adOpenForwardOnly, adOpenKeyset, adOpenDynamic and adOpenStatic. I'm guessing the last one of these is the one I need, but can anyone confirm this is the case before I start Are there any other recordset properties I need to consider as well Cheers! Keith Solution 1: After you have y ...Show All