Answer Questions

• Koelho command button issue

  Hi, I've got 3 command buttons set up in an excel worksheet that each have a macro assigned to it. One of which is a print function. My problem is that whenever I print, the buttons move around on the sheet. I've got a print area set up and the buttons are outside the print area, I'm not sure if that would cause it to do that. Is there a way I can lock the buttons to make them stay in place and not jump around Thanks. This is because the Object Positioning for the Command Buttons have default Move and Size with Cells enabled You can reset this optio, by selecting the properties of the command button using right click --> FormatControl-->Properties just found this thread ...Show All

• Rattlerr Configuration Failed: Windows SharePoint Services 3.0 (Beta)

  Downloaded SharePoint Services 1.I selected Basic Button “install single server stand alone using default settings 2.Closed SharePoint Service Install and checked to start the configuration wizard. 3.Next I said yes to the popup message: The following services may have to be started or reset during configuration: Internet Information Services SharePoint Administration Services SharePoint Timer Service Choose yes to restart the services if required and continue with the configuration wizard or no to exit the configuration. 4.It starts to configuring SharePoint Products and Technologies. 5.Then I get: Configuration Failed One or more configuration setting failed. Completed configuration settings will not be rolled back. Resolve the problem a ...Show All

• Tomay Newbie in VBA Drag and Drop..

  Hi, Do not know if this is possible drag and drop effect of items in dropdown control inside a word application The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done Thanks in advanced. den2005 Hi Derek, Wait, where would I start, should I use vb6 and what template/project type would I use, or use vb.net And how this application be executed when a word document is open Don't know all this. Dennis Hi, You description is clear enough but you know it's still d ...Show All

• Trashey Is Partner program open for non-consulting/non-ISV companies?

  We're a company that is building a web based product to be offered as an online service. Our platform is all Microsoft based using the latest .Net technologies. My question is whether our company is suitable as a Microsoft Partner I'm having difficulty identifying the best Competency for us as a company. Any insights are most welcome. Regards, Neil Hi Neil, I'm pretty sure that your company would be quite welcome as a Microsoft Partner, but unfortunately I can't answer your question more thoroughly. I would suggest that you contact the Partner Resource Center for some advice on which competency would be most valuable to you. Their email and phone can be found on https://partners.microsoft.com/PartnerProgram/ContactM ...Show All

• Kate Boothby Limitations of business scorecard manager

  As I am considering buying Business scorecard manager soon, and since it is an expensive piece of software I would appreciate someone either confirming the issues I am having... or correcting me if I am wrong. If i can get these issues sorted out then Microsoft, you defintely have a sale! Firstly, Am I right in thinking business scorecard manager does not work with more than one dimension attribute from a dimension For example, if I take the time hierarchy to be a year - month hierarchy from a dimension and put that in the column members of a dimensioned scorecard, and I add the branch attribute, from the same dimension, to the row members (so that I would have the data divided up into the different branches down the left hand side ...Show All

• Mirza Ashraf Running external app in ms access 2003

  Hi, I have installed a utility application on my system which process credit cards information. This application installed in a folder named 'cp' I have developed a program in ms access 2003, which has a Tab layout. Now, I need to create a new tab which incorporate this credit card program in access 2003 and execute it from there. As a test, I used a command button to which I write following event procedure Dim stExtfile as String stExtfile="C:\CP\Credit.exe" Call Shell(stExtfile,1) But there is one problem; this application needs a driver to run which is installed in its folder (i.e. C:\CP\). So, clicking over command button to run this application returns an error msg. saying 'driver is needed to run this app ...Show All

• zhengh Creating and Editing Microsoft Access Reports using Visual Basic

  Hi, I am trying to create a report based on the selection from a combo box in a form. i have some data, of which one of the fields is callled "projects". the combo box selects selects a project, and i would like to be able to open a report showing the data that belongs to the specific project on the click of a button. i have written the code below, but the report is only ever blank. i can create a query based on the same sql statement, and it works fine. can someone help Dim thisDB As Database, strSql, projID As String, rpt As Report Set thisDB = CurrentDb projID = existingProjSelector.Value strSql = "SELECT * FROM MyTable WHERE ([PROJECT ID]='" & projID & "') ...Show All

• enric vives Help with a formula

  I need to write a formula for Excel that calculates the amount of fuel that is in a tank. Here is what it is for. We have cylinder tanks that lay horizontaly. Each month we put a dipstick into the tank to measure how many inches of fuel is left in the tank. I need a formula that will take that and calculate it into gallons. Here is the formula I have to work with. / -1 r - h \ V = L * | [ r^2 * cos (--------)] - [sqrt(2rh - h^2) * (r - h)] | \ r / Any Help is appreciated (BTW I am not the best at math so if possible an explination of this formula would be greatly appreciated) Im going to tr ...Show All

• Knvb1123 Can you use VBA to access a spread sheet embedded in a word doc?

  I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated. I can't find any documentation on an msoEmbeddedOLEObject, and wdOLEVerbHide seems to work fine. Also, DoVerb is limited to wdOLEVerb___ enumerations. Nice piece of detective work ;) Hi, Something along these lines. Sub WriteToSS() Dim objSS As InlineShape With ActiveDocument.InlineShapes(1) . ...Show All

• Karg Weng 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 should have added code to remove the new Tools menu item: Sub DeleteToolbar() ' Called from Workbook_BeforeClose and from CreateToolbar 'Get rid of any existing toolbar (err ...Show All

• IamHuM Visio : Search facility using VBA

  Hi, I use VBA to access Visio shapes and manipulate them. But now i have a new requirement that i want to search for a word within the shapes and their comments (all shapes) and display the result. How do i implement this i could not locate an inbuilt method like excels "Find" which will search all the cells.... Or atleast if some one can guide me how to read the comments of shapes in visio it would be of great help Thanks, Deepu After much research i found it out. . For i = 1 to Activepage.Shapes.Count Debug.print Activepage.Shapes(i).name & " -- " & Activepage.Shapes(i).cells("Comment").ResultStr("") Next i Curious how you are ...Show All

• GMS0012 VBA Word Can't find project or library

  I have wrote a VBA macro and in the macro I use visual basic functions such as "RTRIM$( )" and "STR$( )". When running the macro on a client's computer the error "Compile error Can't find project or library" comes up and it stops at the "Rtrim$( )" function. What is missing on the client's computer. Please help Thanks Paul Seo Hi, RTrim is in the VBA library C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL You could get the client to check there references. Within the VBE use Tools > References missing entries will be displayed at the top of the list. Can you share the code you are currently using. Unfortunately the ...Show All

• karthik.sr How to copy pivot table RESULT from Access to Excel

  I need to produce a highly formated pivot table report in Access and can only achieve so much. However, if I could programatically select the pivot table (equivalent of keys [Ctrl]+ ) then copy and paste into Excel, I can use VBA to format the report in Excel. My problem is that I cannot find a way to programatically select the pivot table in Access. I have tried Sendkeys "^A" as a last resort but this doesn't work. Exporting to Excel doesn't work either as it exports the pivot table, not the result . Try this. "str_spreadsheet_name" holds the name of a file that has already been exported and Excel is open and running. "obj_xls" then picks up the open spreadsheet. ...Show All

• ZeroSerenity User form issue

  I am trying to launch a user form from a word document using a command button, but I am getting the following error "Sub or Function not defined." The code for the user form is listed below: Private Sub frmSegment_Initialize() With ListBox1 .AddItem "RNA" .AddItem "ISMC" .AddItem "MHS" End With End Sub Now like I stated earlier I want to be able to launch this userform when a user selects the "launch" command button. And to do that I entered this code for the command button: Private Sub cmdLaunch_Click() frmSegment_Initialize frmSegment.Show End Sub However I am getting that error message. This code happens to be in the "ThisDocument" section while the userfr ...Show All

• Thymen MergeSort for Double Arrays

  Hello There =) I made a MergeSort function for matrices with Double Data. I haven't found this on the web (one that works, that is), so I'm posting here, so ppl can watch, and maybe improve. To use with strings and other kinds of variables, you just have to change the compare statement, and the type (Double). The compare statements are bolded. Cya Public Function MergeSort(Doubles() As Double) As Double() Dim s As Long, i As Long, n() As Double, m() As Double Dim u As Long, l As Long, j As Long, x() As Double ' Only 1 element If (UBound(Doubles) - LBound(Doubles)) = 0 Then MergeSort = Doubles Exit Function ' Only 2 elements ElseIf (UBound(Doubles) - LBound(Doubles)) = 1 Then MergeSort = Ordena2 ...Show All