Answer Questions

• jdrawmer A Better Solution

  I have a table in my Word document (Table1). How do I move the insertion point to the last row of that table And, can this be done even if the insertion point is not currently located in the table Thank you. After a little looking around, I found the syntax I was looking for. The following line of code places the contents of textString into the second column of the first row in myTable. myTable .Cell(1, 2).Range.Text = textString The following is better because it does not require the insertion point to be in the table: Dim oTable As Table Dim rngRow As Range Dim iRow As Integer Set oTable = ActiveDocument.Tables(1) iRow = oTable.Rows.Count Set ...Show All

• Joel Harris Action Pack Question

  I am interested in the Action Pack. I understand that it comes with the Vista upgrade, not the full edition. I do not have 10 licensed copies of XP Pro to upgrade from. So does that mean I will need to purchase a licensed copy of XP Pro for each machine that I want to put the Action Pack upgrade version of Vista on The idea of providing upgrades in the Action Pack is ridiculous, the ammount of time it takes to install XP just to meet this requirement shows what Microsoft really thinks about it's partner's and how it values our time. For most Action Pack users I imagine that they will be buying or building new PCs due to the beefier requirements of Vista. I only hope it doesn't require SP2. (I am doing an XP build on a new PC as I t ...Show All

• XNA Rockstar Is there a today() function in VBA?

  I've been trying to get the current date a few ways in VBA. I tried using the today() function in a spreadsheet and getting the data from that cell and also calling it explicitly in a vba script and have had no success. any help will be appreciated. i use now() to enter the date for new entries into my database - i would assume that it also works for excel Offcourse. (^_^ ) The only difference between Now and the one's i've suggested is that Now contains both the current date and time while Date and Time are seperate commands for the date and time. (^_^ ) It all depends on which information you need. You can use "MyDate = Date()" for that. (^_^ ) If you wa ...Show All

• Jack of All Trades checkbox value on Workbook_Open

  I have a checkbox on my worksheet, that I would like to check the value of it when the workbook opens. Simple example would be: If the user saved the workbook with the checkbox checked, then when he opens the workbook again, then cell A1 = 1, else A1 = 2. I cannot figure out how to obtain the properties of this control (or any other toolbox control) from the Workbook_Open event. I am using Excel 2002 (10.4302.4219 SP2). Any help will be greatly appreciated. Mike How do I indentify a specific control This is what I have: 2 combo boxes that have their ListFillRange populate data from 2 other worksheets in this workbook. Then the LinkedCell is used by a VLookup to display information on the ...Show All

• ozitraveller excel rowheight

  Hi, I know how to set the rowheight of a row to zero using macro. Is there a way to do this in the formula section Something like : if there is a value in cell A2 then delete the row or set the height of the row to zero. p.s. no macro is allowed for business reasons. Thanks I do not think this can be achieved with a formula, you either do it manually or with VBA. Alternatively you may use conditional formatting (Format > Conditional Formatting) to make the text in the cell "disappear", i.e. make it the same color as cell background color. ...Show All

• soung LCS/Office Communicator.. add contacts to users Communicator at Login (script)?

  I'm trying to use the lcsaddcontacts.wsf command to add contacts (is there another way to do this) I'm using the format of the command lcsaddcontacts / usersfile:users.txt and /contactsfile:contacts.txt I'm assuming I need both files... The users.txt file contents is like this: sip:userA@domain.local While contacts.txt is: sip:testuser@domain.local For some reason the script fails with an error stating "invalid class" at line 104. (In vista, or in XP, it just runs but no contacts get added).. I'm assuming the users.txt represents who I want to add the contacts to.. the sip:userA should match the LCS login name or the AD login Also.. does anyone know of a way to install the client and have the ...Show All

• A.Kahn Using VBA through word, lost all menus (file, edit, etc.)

  Edit: Started Windows from prompt using /a.  Problem solved. In VBA through Word, all the menus, tool bars, etc are gone.  How do I get them back   I assume there is a shortcut key   I cannot see the Stop, Run, Pause buttons or anything, I can see my code and nothing else. Are you trying to do this using th internal vb in word called VBA. These forums are intended for VB.NET use The following may be some resource ot use for your VBA issues. Office Automation: office.developer.automation newsgroup http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US These deal specifically with Office development and ...Show All

• kwirky Question: How do I hide the Title Bar?

  Howdy... I'm writing a program in Excel and I was wondering how to hide the Title Bar. The one with "Microsoft Excel" and the min., restore, and close button. If that's not possible, is it possible to deactivate the close button I'm not working with Forms....I want to hide the application title bar. Set the forms borderstyle property to none. Hi, Have a look at Stephen Bullen's FunForm workbook. http://www.oaltd.co.uk/Excel/Default.htm I know his code is designed to apply the formatting to a userform. But by changing the code in the class to use the application window handle rather than the userform the effects still work. But be very careful when playing around with application se ...Show All

• philknight Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional

  This problem has been mentioned by many other users (in a different thread subject), so I wanted to start a new thread. I have tried many suggestions, but none have worked for me. My MODI has been a print option for me until just recently. It disappeared from my printers folder. I have repaired, removed, and re-installed Microsoft Office. The MODI will still not appear in the printers folder. Please Help! I had the same problem and the only solution I found was to give up on Microsoft Document Imaging and install PDF Creator (http://www.pdfforge.org/products/pdfcreator). You can print to PDF's as well as TIFF and other formats. Best of all . . .it's FREE! Oh, yeah, and it actually works. ...Show All

• Danny Thorpe MSFT vlookup

  Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata Hi, How about some like this Dim rngLookupValue As Range Dim rngtable As Range Dim lngColIndex As Long Dim blnRangeLookup As Boolean Set rngLookupValue = Range("O2") Set rngtable = Workbooks("Consolidated list of supplier.xls").Worksheets("Sheet3").Range("$A$5:$F$218") lngColIndex = 6 blnRangeLookup = False vntResult = Application.WorksheetFunction.VLookup(rngLookupValue, rngtable, lngCol ...Show All

• ahmedilyas Post-Empower ISV Options

  Hi all, The company I work for has been in the Empower ISV program for almost two years. During that time, we have completed version 1.0 of a very large (about 800,000 LOC) enterprise application. We have made a few sales, but we're not rolling in the cash yet (hopefully that will change soon). We are still adding new features to our product, fixing bugs, etc, and as such we still need development tools. Since all of our tools are covered under the Empower ISV program, we'll have to switch to something else once our subscription expires. What exactly are our options Is there anything that isn't going to cost us an arm and a leg I doubt there's anything that's as cost effective as the $375/year we've been paying for Empower ISV, but is th ...Show All

• Ashraf Hameeda T Problem automatic opening of .doc's with WebTools elements fails

  Hi Folks ... Ok, opening a .doc file with a button and converting it to rtf ist simple. But currently I'm facing a very interesting problem. I use a VBA Script to open a specific .doc file on my local hd. This works fine, but when this document contains for example an input field (from the WebTools) the following code fails without an error message (or better with an empty vba error box) on the documents.open(.. line. Dim wordApp As Word.Application Set wordApp = New Word.Application wordApp.Visible = True Dim wordDoc As Word.Document Set wordDoc = wordApp.Documents.Open("c:\test\MyDoc.doc", _ AddToRecentFiles:=False, Format:=wdOpenFormatAuto) ... The problem occurs on Office XP and 2003. Any ideas ...Show All

• RLN ADODB.Connection.Open fails (MS Access VBA)

  Here's the code: cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "User ID=Admin;" & _ "Data Source=R:\Recycle_be.mdb" cn.Open R: is a mapped computer located in a separate location on the network. It's a user's machine. On his machine is some information that needs to be retrieved and updated. I've used this code before and it worked fine. But recently, he received a new XP machine. Previous was Profressional 2000. Now when this code is run, and the user is logged in, the open fails with the following message: Run-time error '-2147467259(80004005)' Could not use "; file in use. When I link to the machine, I cannot access the .mdb by ...Show All

• Pavel Nechai Can't open regedit

  Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks Which version of Windows are you running thanks, -brenda (ISV Buddy Team) I can't ope regedit everytime Itry it I get the same error message saying that the file is being used by another program The dutch version would be the same globally. I am wondering if you click start- then run- then type in regedit if you are using capital letters instead of lower case. For example Type in REGEDIT that's all, no exe or period. If it's st ...Show All

• timmy44 WMI.Net 2.0

  The next manged code library for WMI was discussed at TechEd this year and has popped up in a couple of webCasts. -- The WMI.Net 2.0 is supposed to provide writeable properties and invokable methods from managed code. Is there an update on the release Beta program etc... -- We are looking to ship this WMI enhancement in Orcas (WinFX 3.5). This was mentionned during the MSDN Architecture Webcast June 2006 about .NET Application Instrumentation Using WMI.NET 2.0 (Level 200). The first beta will be available during the course of next year with the Orcas CTP builds. HTH. /Alain Is there any documentation on this new implementation I have done little bit experimenting with it using the reflector tool ...Show All