Answer Questions

• Aldo Mtz S I want to create a "search" engine within my Excel spreadsheet.

  'm the type of person that likes to teach myself, BUT i'm having difficulties understanding the VB manuals. i figured their would be someone out there that could break it down for me, possibly at a high school level. lol I have a spreadsheet that has many tabs. In one of the tabs it lists client names and information, approx. 260 lines, starting in cell A15 and continuing down so forth. I want to create a "search" feature/engine within this one specific tab that fuctions much like the new media player 11 search engine (as you type the name, the names begin to appear with all the info as well). i want the "search" feature/engine in cell A5, kept seperate from the rest, I have frozen the panes so the search engine doesn ...Show All

• MrSkoby installling business scorecard manager 2005

  I try to install it with SQL server 2005 on Windows 2003 server but I don't find this : "Fournisseur OLE DB Microsoft pour OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)" (it's in french). Can you tell me where can I find it ...Show All

• alpefusk ISV Royalty Program - OA2007

  1) Are there different types of ISV programs If so, what are the differences between the programs   2) How does the Royalty program differ from other ISV programs 3) Does each program offer different benefits to the end customer   4) How does the Royalty program differ from other ISV programs to the end customer     5) Does Microsoft have a brochure or a list of the benefits for the end customers   6) If I was to have a techincal problem with a soultion and I can not get in touch with the ISV that sold me the soultion will Microsoft be able to help me       7) What are the benefits from buying solutions from an ISV to an end user ...Show All

• lalit123 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 Thanks for the link to the article, but ...Show All

• Mortsdeh Deleting tabs when a cell is emptied

  Hello everyone, I have an excel macro where, whenever i put a name into a cell in the range B43 to B77 on the very first worksheet, a new worksheet is created that has the name of whatever is put into the cell. what i would like to be able to do is to create a macro that would, whenever one of the cells is cleared, to delete that specific worksheet that was created when the name was entered. any help is appreciated :D Nick This should be fairly easy to do. Since you've already got code that creates a sheet when a value is added within that range, I'd recommend creating a Collection which contains Items equal to the name of the sheet (the value of the cell) with Keys equal to Range.Address of t ...Show All

• Alvin Kuiper Page Setup in Excel 2003 using VBA

  I can get as far as bringing up the print preview screen using VBA. How do I then get VBA to squeeze my spreadsheet onto one page before printing. There is probably a simple solution out there but I'm currently teaching myself VBA by trial and error... but my boss seems to think I know what I'm doing!!! Assuming all the data you want to print on a single page exists on Sheet1: Sheet1.PageSetup.Zoom = False Sheet1.PageSetup.FitToPagesTall = 1 Sheet1.PageSetup.FitToPagesWide = 1 That should do it. (I won't tell your boss if you don't!) ...Show All

• Nick Gravelyn 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 I actually managed to get it working after many hours of trying! But much more satisfaction when u are able to do it on your own! :) So i added this code into one module... ' ...Show All

• Igor Solodovnikov creating UTF-8 file in Excel Macro

  Hi, I have an Excel Macro that reads a bunch of multi-language cells and creates a text file out of it. Set fs = CreateObject("Scripting.FileSystemObject") Set a = fs.CreateTextFile(sFileName, True, True) For ... a.WriteLine (data-from-cells); Next As you can see here, I set the format to unicode by passing the last boolean parameter. The problem is that the generated file is not in UTF-8 format even though it's a valid unicode format (probably encoded in UTF-16 ). I have to open the file explicitly in Notepad and save in UTF-8 format. Is there any way I can set the charset to UTF-8 programmatically ny help will be really appreciated. I am having th ...Show All

• Programm3r [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

• Rabtok Emails via Excel

  Hey Ladies and Gents, I am a bit new to the world of visual basic so please be kind. I have been set a mini-project here at work and need some assistance. What i am trying to achieve is for a user to click a command button in excel, opening up a new mail message in outlook. This new mail message will include filled areas in to, subject and main body with a hyperlink to the document in which they have just updated. I have managed to produce the following code so far: Sub Button1_Click() Dim theApp, theNameSpace, theMailItem, myAttachment, MessageBody, subject 'create a new Outlook Application Object, 'direct it to the proper NameSpace, 'create a new Mail Item and set the attachments collection Set theApp = CreateObject( ...Show All

• jaegd Internet Explorer Problem?

  Hi, Im having a very strange problem and Im wondering if it is a setting in Internet Explorer. I tried to access an online shopping cart in IE, and could not get to the Payment page. It simply looped around and endlessly asked me for my details. You might be thinking that this is just a badly designed website, however, i tried to do this on other machines and it worked perfectly fine! Is there a setting in IE that doesnt allow access to interactive pages such as a checkout Or is it some other setting of the computer Thanks, Rebecca It might be a security setting. Check if cookies are allowed for this page - a red icon will appear in the status bar of IE if they're not. Some web sites use cookies to i ...Show All

• Derek Burnham Office Communicator 2005 sign-in name, auto populate after install somehow?

  Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users probably wont take the time to enter their info when I have it set to auto start/connect on windows start up. Thanks I would be interested in this solution too. Communicator 2005 can pick out information from Active directory - why cant it pick out their sip name (or email address) too and so not bother the user ...Show All

• SimonS_ Microsoft Ecosystem

  Can someone explain the theory behind Microsofts ecosystem and how it benefits Microsoft and its Partners. Thanks I started to type an answer to this, but I realized that one of my colleagues addressed this issue quite exhaustively in his blog recently. (Sorry to plug a blog here, but it's really a long answer and this is easier): Part 1 Part 2 Some background: we're an ISV, and we've invested heavily in the Microsoft partner ecosystem. It helps us to gain VERY valuable contacts within Microsoft, and also helps us to meet other Microsoft-oriented ISVs, AppDevs, and SIs who may be potential partners. How does it benefit Microsoft Well, Microsoft has succeeded largely because people write sof ...Show All

• R.Tutus Autofilter criteria's

  Hello everyone, This might be really simple but I couldn't find the answer for it.What I'm trying to achieve is that I need to find all the possible autofilter criteria's of a single Excel list field (Column) from VBA. I know I could just iterate over the column's cells and distnictly find the values and store them into an array, but I'd really be intrested to know if there is a property which already gives me that. thanks, Mohamed Hi You could always store the unique values of a column in a collection, below runs down column A until it hits a blank, then lists unique entries in the debug window: Public Sub Listing() Dim x As Long Dim strList As New Collection x = 1 With Worksheets("Sheet ...Show All

• Thegamingchoice when I use the fusion technology and make the aciveX control

  Dear Sir, I have a web application using DSO Framer c ontrol, but when my client wants to view the page. He has to make his security settings low. I know that when I use the fusion technology and make the aciveX control as Windows control and display it by using <OBJECT> tag, then it will act as a normal .net control, can any one help me to do this. Youn can even mail me to : aleem_abdul@akebonosoft.com . Please help me if possible. Thank you. Regards, Aleem. ...Show All