Answer Questions

• Dondata MailMergeToDoc Office 2003

  I am getting a 509 error when running there old program and was looking for a quick solution to allow them to use their old program with few changes in office 2003. Works fine with 98. Thanks Will ...Show All

• chadhowell Microsoft Platform Test for ISV Solutions

  Hi. My company is getting ready for the "Microsoft Platform Test for ISV Solutions". Can I find more detailed directions and resources to set the designated application for the test i.e. to pass "managed code" tests- I know that the application is free from 'DllImport', but I'm not sure that: This is enough. One of the components I'm using works with unmanaged code. Further more, the document provided by Microsoft (" Guidelines for products that appropriately target Microsoft platforms and technologies " version 0.93) Declares that: Note: It is acceptable for assemblies sourced from third parties that are installed with the application under test to ...Show All

• AlexKL Combo Box Syntax Error

  rs.FindFirst "term= ' " + Me.Combo72.selectedvalue + " ' "     ...Show All

• iowa242943 Microsoft Ecosystems

  Can someone explain the how Microsofts Ecosystem works, and whats in it for Microsoft and the Partner Thanks The Microsoft Partner Program offers resources and benefits to support ISVs throughout the development lifecycle. In addition to development resources, ISVs also can take advantage of marketing and sales opportunities. By helping ISVs successfully build solutions on the Microsoft platform, Microsoft benefits too. You can get a great overview of the benefits for each partner level from http://msdn.microsoft.com/isv/partnering/default.aspx . Basically, the Partner Program is tiered and you can engage at the level that is most beneficial and appropriate for your company. I hope this helps ...Show All

• GDigrego Access data to Excel workbook

  Hi I use Access VBA to export a recordset into an Excel template. I then save the template as a .xls file. Everything works fine except when I open the Excel file the Workbook is hidden. I have to use Menu:Window:Unhide to unhide the workbook. How can I fix this with VBA from Access Thx Code------------------------------------ Set xl = CreateObject("Excel.Application") Set xlWrkBk = GetObject(FPath & "/FS_Template.xlt") Set xlsht = xlWrkBk.Worksheets("Window & Exterior Door Schedule") do the recordset stuff into cells FName = xl.Application.GetSaveAsFilename xlWrkBk.SaveAs FileName:=FName Set xlsht = Nothing Set xlWrkBk = Nothing Set xl = Nothing ...Show All

• Templarian An issue with Outlook Express 6 attachments

  When a client of mine tries to add an attachment to an e-mail, the file (when shown in the attachment address bar) comes up as a .lnk file. This is strange because it happens with every type of file she tries to input. We, so far, have tried a Word document, Excel spreadsheet as well as many other file types. In the folders, they are viewed with their regular file extension, however, as soon as they are attached to the e-mail, the extension changes to .lnk every time. This causes a problem because of the security settings Outlook automatically creates which blocks all executable files, including .lnk. I know there is third party software and regedit that could allow us to open these types of files, but its not worth it to do so on every co ...Show All

• takobell Elegance (and performance) Problem

  Hello, I developed a class (class CMatrix, that holds a lot of functions not really related to the other class) to use in another class. Currently, it's working real fine, but I don't know if there's a better way to handle with this. What I do today is, in the main class: Dim Matrix As CMatrix ... somewhere in a sub or property Matrix = CMatrix.MergeSort(Matrix) ... rest of the code If my CMatrix could acess the data in the main class, it would be fine, bc I wouldn't have to pass nothing. Thx in advance =] thx, I think I've got it now In most cases, you don't want to use pass by reference. It usually make the function unintuitive, unless you need t ...Show All

• Kevin F Jones Error while editing Tasks\Announcements etc. in Sharepoint 2007

  Hi, I have Sharepoint Server 2007 beta 2 with TR installed. I created a a site with the Intranet Portal available, and created the required site hierarchy. All was going well and working fine, but all of a sudden I started getting the following error page while updating any content in my web sites Go back to site Error This Page has been modified since you opened it. You must open the page again. Refresh page. Troubleshoot issues with Windows SharePoint Services. No changes whatsover was done on the server and this error came up popping suddently. If anyone has faced a similar error, please let me know if you already have a solution. Ashish This KB Article provides a fix - but its ...Show All

• bola shokry Browse hard disk with VBA

  Hello, I want to read a text file into Excel with VBA. This all works fine with some code I found, the only problem is that the text file I want to open should either be written in the code, or in a textbox but than I have to type the complete location (C:\MyDocuments....) what I would like to have is a browser, similar to the one from Windows on "Ctrl O", which opens when I push a button so I can browse for the file on my hard disk and select the file I want to read into Excel. Does anybody know if this could be made in VBA, and if it is possible how Barry Hi, You can use the GetOpenFilename method in Excel to browse for a particular file. This is straight out of the ...Show All

• danleis Running a macro at a certain time

  I would like to have a macro that automatically runs once every day at a certain time. Is this possible and does Excel and the spreadsheet need to be open in order for the macro to execute Any help is appreciated! I would use the windows scheduler to open the Excel Spreadsheet at the designated intervals and have an auto-run macro setup so that every time the sheet is open your macro executes Ok thanks alot!! Last question I hope, do you have to be logged in to Windows in order for this to work The computer is on at all times but at night when I had planned to let the macro execute no one is logged on to the computer. Would be very grateful for your help! Thank you very much for your answers!! ...Show All

• Astericks Cell Equal To EXACT Value

  Hi all, prob a very simple question for you guys. How do you check if a cell equals an exact value of "Product" I am currently using: Cells(i, 1).Text = "PRODUCT" though this is also picking up any cell which contains the word Product, such as cells which contain the word Production. So how do you check for an exact value During my experience with programming, i found that using the command to convert the value to Lower Cased characters would solve a lot of problems in a search function. Since it will be a user who's typing most of the values in a sheet or database, consistency is one of the things which will missing when it comes to the content. In short, i usuall ...Show All

• mark hsu Summing up hours on form based on parameter query

  Hi there - im finalising my new activity system but i have one issue. on an activity form i have certain fields for information purposes that are non editable - they are 'hours worked with client' , 'hours worked this month' and 'hours worked for the day'. The first 2 fields are populated automatically by opening recordsets on form load or companyname exit and summing up the hours based on the relevant query where the criteria ensures that the query is already populated. However for the 'hours worked for the day' field the query is a parameter query (qrytodayhours) where activitydate = Forms![frmactivity]![activitydate] and i was then hoping to enter the following code to sum up the hours using a recordset on the on exit of the acti ...Show All

• daydreamsy2k Parse Text from displayed Desktop

  Hello Everyone, Is there anyone here who worked with parsing text from the display of desktop I want to get the prompt texts, the title of the windows open; and use the value to my excel sheet. Is it possible in any ways Thanks, MUSIC ...Show All

• WinBase Controls in a Word Document

  This is my first post =). I am using Word VBA in which I have controls such as CommandButton1 and Terminal1. Whilst CommandButton1 is a "Word VBA" control. The Terminal! is I think what is called an ActiveX control. It is part of a DLL file. My problem is that since we have gone Windows XP Professional, every now and then my macros stop working and the debug screen comes up. This is because the control names have changed (seemingly by themselves). The macros are password protected and I don't think any of the users would even know how to change the control names! There is also a pattern to how the controls are renamed. CommandButton1 becomes CommandButton11 Terminal1 becomes Terminal11 if I had say a control cmb ...Show All

• kangalert Printing comboBox Items

  Hello All, I have a program where I add all errors to a combobox using the addItem method. Sometimes there are quite a few and I would like to have them printed to paper. (Say via a commandbutton_click event). Is there any way to do this without having to add the list of errors into a Word or Notepad or Excel document and then printing it For us oldies, I guess I am asking if there is an equivalent of the old LPRINT command there used to be in in BASIC. Cheers Chas Hi, There is no "direct" print command for VBA to print to printer directly. However, as you already add the error item to a combo box, you don't you just add the error to the spreadsheet and then use the Act ...Show All