Answer Questions

• Philip Tolk MS Office document and image writer print driver

  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 1. Go to Control panel – Printer and fax 2. Add Printer – select local printer attached then manual 3. In the port option select Document image p ...Show All

• ksvasan Adding Appts to a Group Calendar

  I have a simple Access Application that can add appointments to my (default) personal calendar but I cannot find any way of getting VBA to open a different calendar. I tried the PickFolder method to choose the group calendar but the appointments still end up in my personal calendar. What (simple step) am I missing ........... ...Show All

• figuerres BSC manager - Error connecting to server

  I've installed BSC manager 2005 following these steps: 1. Created a Virtual PC with 512 MB RAM 2. Installed Windows Server 2003 entreprise edition 3. Installed Windows Server 2003 SP1 4. Installed Sharepoint Services 2003 5. Installed Sharepoint Services 2003 SP2 6. Created a site and extended (Port: 46786) 7. Installed SQL 2005 developer edition 8. Configured SPS to use SQL instance 9. Installed BSC manager (server and builder) When i start the BSC builder and try do access the server ( http://localhost:46786 ) I get the following error message "The conection to the server failed. Verify that the connection information is correct". Can you help me What is this server Is it the SQL server create ...Show All

• Raghu Deshpande [OTP] VBA Using combobox in Excel

  H i there,   I'm working on an engineering spreadsheet (Excel) and need some help in manipulating comboboxes / dropdown list.   Say i have 2 list, where list A has the list of countries and list B has the list of cities for the country chose. If all the data source (i.e. countries and cities) are to be extracted from the Excel spreadsheet, is it possible to make list B dependant on list A (that is to say when user selects a country in list A, list B will automatically gives the respective cities) WITHOUT creating a userform If so, please advise how.   Hope you can understand what i'm trying to ask here. Fyi i have minimum VB knowledge so a "dummyproof" explaination would be really ...Show All

• WHats wrong querying/updating linked visual foxpro tables with Access 2003/ODBC

  Using ADO 2.8 SP1 and tables linked to VFP, I get an error # -2147467259 that says "Could not delete from specified tables". I've downloaded latest VFP ODBC driver. The tables are part of an application developed in VFP, and although there is a dbc file, the tables are loose. Any insight or suggestions will be greatly appreciated. Thanks. cbrack You can't delete a table that in linked to other database in MS Access. You can delete the link, but not the table itself. Hope this can help. ...Show All

• Ewild List available printers?

  Hello guys, I am having a hard time to access a list of available printers. How do I do that I am trying to print mail merged labels. When I record the macro, it sets the activePrinter to a string. I wish to set that value using a drop down list GUI. Thank you. This may be your solution http://word.mvps.org/FAQs/MacrosVBA/AvailablePrinters.htm Hope this helps. OMG, it works. Thank you so much. You are my hero. I've been looking as well. The only thing I can find for you is that you can find what the active printer is under application, but that's not what you are looking for. If you have VB, you could write a little program that will return the printers for ...Show All

• Chris Calderon worksheet_change and data validation

  Hi there I have an Excel spreadsheet in which one column has data validation set. So the cells in this column have drop-down lists with the pre-set allowed values. Now I want the cell in the neighboring column to be set to some default value when the user selects an item from the drop-down list. This seemed like it would be easy, using the Worksheet_Change event handler. When a cell in the first column is changed, it initiates a function which sets the value in the neighboring column to some default value: Target.Offset(0,1).Value = "default". The problem is that it doesn't work when using the drop-down list. If the user types in the value manually, or if a cell in the first column is deleted, it DOES fil ...Show All

• Esprit Save Workbook code works fine in Win2000, however given an error in XP

  Wrote a script in VBA (Excel) that builds a workbook based on a list of names. When the script arives at a new name then it saves a copy of a template file using the name in the column. When I run it on Win2000 it works just fine, however when I run it on XP then it produces an error when it reaches this code . newWB.SaveAs ("G:\NSS Bus Ops\Patrick S\Daily Report Dump\" & sName & "_" & Right(Workbooks(abName).Sheets(1).Cells(i, 3), 4) & Left(Workbooks(abName).Sheets(1).Cells(i, 3), 2) & Mid(Workbooks(abName).Sheets(1).Cells(i, 3), 4, 2) & ".xls") Any thoughts as to why this might have happened. The Win2000 & XP machines are running Office 2003 service pack 2. Thanks f ...Show All

• KevMac Can you tell me why Int(1.4 * 100) = 139

  Can someone help me to find solution: Int(1.3 * 100) = 130 Int(1.4 * 100) = 139  (also  Int(1.38 to 1.49  * 100 ) ) Int(1.5 * 100) = 150 (VBA:Retail 6.0.874) Thanks in advace Thank you. I looked it up the reference on those things also. It is pretty interesting. But I am starting to hate VB >o<. Because using those two functions, I will introduce precision problem. Then, I have to patch over patch over another patch. MsgBox CStr(CInt(Int(1.4 * 100))) + vbNewLine + CStr(Int(1.4 * 100)) MsgBox CStr(CInt(Fix(1.4 * 100))) + vbNewLine + CStr(Fix(1.4 * 100)) All give me 139. In order to turncate a long or double. It seems like I have make suree precision ...Show All

• Reza Bemanian Creating a Toolbar and a button that is linked to a macro

  Hello, I'm looking to add toolbar and then a button inside that toolbar that will be linked to a script using vba. Baiscally, on excel start a toolbar would be placed at the end of the existing ones at the top that would have a button named Run and would be linked to a macro named play. On close I want that to be deleted. Thanks Hi I think this is nearly what you want. Create a workbook and put the first part of the code in ThisWorkbook module, and the second part in a standard code module. Save the working program in the folder set in Excel as the one where all files will be opened at Startup. This is actually a cut down version of some code I use, so I've left some extras in that s ...Show All

• arogan On Error not catching problem with a web query

  Why does "On Error" not seem to work in this case Once every few hundred iterations, there will be a failure, timeout, or resource not available error on the last line which invokes .Refresh BackgroundQuery:=False. Any insights would be much appreciated. Regards, Brian code excerpt........................... On Error GoTo query3error With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://finance.yahoo.com/q s=" & ticker, Destination:=Range("A1")) .Name = "q s=" & ticker .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = False ' ...Show All

• IanG Check diff

  I have a sub that is called from a loop. It is supposed to check if the difference between two numbers is greater than a predefined errror tolarnance. However the difference between the two numbers shall only be checked if neither of them are zero. My problem is that no differences are deterected. My code is: Dim dblLocalReturnDiff As Double If rng4.Offset(l, 0) <> 0 And rng3.Offset(l, 0) <> 0 And rng4.Offset(l, 0) <> rng3.Offset(l, 0) Then dblLocalReturnDiff = rng4.Offset(l, 0) - rng3.Offset(l, 0) If Abs(dblLocalReutrnDiff) > dblErrorMarginal Then MsgBox ("Local return skiljer sig at mellan portfoljen och benchmark!" & vbCrLf & "Kolla upp vad detta kan bero p ...Show All

• Toseef Help with highlighting employees nominating each other for awards...

  Hey This is more a mathematical problem I guess rather than a how to do it in VBA. I'm trying to write a simple macro that will allow me to highlight people who are nominating each other for small awards. Basically I get a copy of the datafeed from the server and run it in Excel on a monthly basis. I have a Nominator ID and a Recipient ID along with numerous other information and I want to be able to find out if anyone is continuously nominating each other Been playing about with IF statements and loops but having no joy at all :( Just not mathematically minded enough! Nominator Recip Amount Date Reason etc... Scott Louise $20 12/01/06 ....... Louise Scott $20 1/01/06 Jack Jones ...Show All

• TheViewMaster Trouble installing BSM Reporting Service

  I have a server with both SQL Server 2000 and 2005. And on this server I have SQL 2005 Reporting Service set up. When installing the BSM Software, it fails to see that I have SQL 2005 Reporting and says I do not have SQL 2000 Reporting Service installed. How can I get around this We do not have 2000 Reporting Service. Thanks BSM 2005 will indeed support Reporting Services 2005: Please follow this official link for Instructions for installing Microsoft Office Business Scorecard Manager 2005 with Microsoft SQL Server 2005 http://office.microsoft.com/en-us/assistance/HA101056881033.aspx Follow Installing Prerequisite Software step carefully in above link. ...Show All

• Agent00 Merry Christmas and Happy New Year

  This is the forum I've maybe spend the most time in, although not so much recently but that can't be helped. To everyone who posts here often enough to know my name, and to anyone else to happens to read this... have a great Christmas and New Year... and even if you don't celebrate them I hope you enjoy the holidays. I am new here and have only posted a few posts, but I do know your names, Derek and ADG, :) because going through this forum is one of the first things I do everyday. Wish everybody have a merry Christmas and a happy New Year! Merry Christmas Derek Thanks for all your posts, here and on your Blog. Like many others I read the questions and answers on this forum to expand my know ...Show All