Answer Questions

• Zep-- Using Paste in the File Save as window

  Hi all I only know a little about VB but have made a form on word that copys a word from the document saves itself to a folder prints a copy and then exits word. it all works fine except i cannot get it to paste the word from the document in the fileName when it saves. The script is below with red showing the problem. Any help on this would be much apreciated Mark Sub Process() ' ' Process jobsheet macro ' Macro recorded 09/01/2007 by Mark Smith ' ActiveDocument.Shapes("Text Box 6").Select Selection.WholeStory Selection.Copy ChangeFileOpenDirectory _ "E:\Global Internet Learning Ltd Files\Duplication Centre\Client Job Sheets\" ActiveDocument.SaveAs FileName:= , FileFormat:= _ wdFormatDocume ...Show All

• scribework "Building Custom Report Views Webpart"

  Hi, I downloaded "Building Custom Report Views Webprt" white paper from the Microsoft site and tried implementing it. I intially created a Windows Control Library project and created a usercontrol. I built this application in to a DLL,created a strongname to it and then put this asembly in GAC. I then created a pmbuilder.exe.config file in the location given below. "C:\Program Files\Microsoft Office Business Scorecard Manager 2005\Builder" The content of the file is given below:- <configuration> <configSections> <sectionGroup name="Bpm"> <section name="CustomReportViews" type="System.Configuration.DictionarySectionHandler, System, Version=1.0.5000.0, Culture=n ...Show All

• Matt354245 Range

  Hello, I'm developing a macro to do some calculations on a worksheet, but I always get a problem when I pass a Range as an argument to my function. I need to pass the range as argument. For example: Sub Name() Dim A As Range Set A = Worksheets("Sheet1").Range("CD4") MyFunction(A) End Sub Function MyFunction (ValueDoRange As Range) etc... End Function Thanks Excuse me for my bad english I Have this code: Function InterpMatriz_lin(Rango, x, y) Dim T(1 To 100) Dim R(1 To 100, 1) Dim S(1 To 100) Dim A(1 To 100, 1) Dim U(1 To 100) Dim B(1 To 100) NumFilas = Rango.Rows.Count NumCols = Rango.Columns.Count For i = 2 To NumF ...Show All

• JSarna Gantt Chart component/library

  Hi, I am looking for a component or a library or a framework to draw Gantt Charts much like MS Project. Either a free or a paid solution will do. I need to be able to incorporate it with my .Net application (written in C# 2005). I have searched around and found several solutions which more or less come close to what I am looking for. But I would like to hear from someone who might have researched it in the past and know about some good components or libraries out there. Basically, I would like to simulate MS Project's project management charting solution, but in a simplified version. Thanks in advance for any pointers. Mehdi If you are looking for a Gantt Chart control to edit tasks in a project ...Show All

• alwayssmiling Help with comma separated values in report

  Hi! A bit of a stuck-up. It’s no problem in creating a coma separated fields in .txt kind of file. But I have another problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line. If anybody is familiar with the solution just show me the direction and I’ll try to solve it by myself. Thanks in advance 1. Have you check your SQL string Is there any typo in it Try to build a query to verify it. 2. The textbox.text wouldn't work, try textbox.value instead. Hi Kdee, did u find the solution, me too have a same pr ...Show All

• Vivek Natani Own Right-Mouse-Click Menu item in Outlook

  Hi everyone! Can somebody tell whether it is possible to have like an extra menu item in the right-mouse-click menu. Say, if I had a Macro called "DoThisOrThat" then it this would appear in the right-mouse-click menu What would be the code for this (maybe even: what's the code for this if it was to appear as "start a new group", ie. with a dividing line to the other menu options) I think you can do this in Excel but I don't know the code (plus, whether it is the same for Outlook!) I would really appreciate if somebody could help me with this problem! Thank you very much in advance! Marc Hello Marc, I normally write Excel Macros and converted the code you wanted for Powerpoint for some reason and then saw th ...Show All

• PareshGheewala Get Excel Sheet Names

  Hi: I am trying to connect an Excel file and get all sheet names in the file. When using ADO.Net, the sheet names contain letters "$, or ' " around the sheet name, not getting the exact sheet name. I wonder why. I am also trying to get sheet names by using Excel as a Com object in VB.Net, like: myExcel =CreateObject("Excel.Application") myWorkBook=myExcel.WorkBook.Open("my Excel File") For i = 1 to myWorkBook.Sheets.Count     myTableName(i) = myWorkBook.Sheets.Item(i).ToString Next But the code does not work. Does anyone know how Thanks. Okay, that's a good starting point. Does the code I suggested work for you I don't have a copy of VB.NET on this machine, so I ...Show All

• xyligun 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 Anyone have a suggestion for this 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 Prereq ...Show All

• steveareno Form Locking

  Hi, I am creating an EPOS system in access/vba, with an SQL 2005 connection. Learning as I go I have managed to create a login keypad which checks your code input against the database to see if the login is valid. The way I see this keypad being used, is everytime the application is flagged as locked, the keypad appears and locks out other open forms until the correct code is entered. Am I thinking about this the right way is this the way that access would work, IF i knew code to do it Thanks, Dan Perfect :) thanks.. Moving to the VBA forum: When you want to lock your application show the keyboard form modally and don't dismiss the keyboard form u ...Show All

• dlcollison Insert Macro

  Hello, I want to write a macro where on inserting a new row in the active worksheet, the newly inserted row will become yellow in color. But I dont know how to do this. kindly help Thanks Hi In order to run your macro it needs to be triggered by an event. I don't think that there is an event generated by inserting a row. There is no event handler for inserting a row. However, you can add a row and turn the background color to yellow with VBA. For example Sub X() Dim rngCurrent As Range Set rngCurrent = ActiveCell rngCurrent.Insert (xlShiftDown) With ActiveSheet.Rows(rngCurrent.Row & ":" & rngCurrent.Row).Interior .ColorIndex = 6 .Pattern ...Show All

• sandyk - MSFT finding index in an array

  Hi all, I want to find out which index in the array that corresponds to the maximum value in a array. ff = Application.WorksheetFunction.Max(Hist) finds the value to which I would like to find the index for. Hist is an array containing several thousands of numbers. So I would like to avoid looping through the array to save time. Any ideas out there Grateful for help \Jonas Hi, You don't show the details of the array Hist but if you can use the Max function maybe you can make use of the Match one to. Sub Test() Dim vntMaxValue As Variant Dim lngMaxIndex As Long Dim Hist(1 To 5000) As Double Dim lngIndex As Long For lngIndex = 1 To 5000 Hist(lngIndex) = Rnd() * 10 Cells(lngIndex, 1 ...Show All

• CesarDev10 can you help ?

  Hi, I have an error in my vba application. It occours only in excel 2003, but not in 2000. Its a: "Application-defined or object-defined error" Error code 1004 In the follwoing method the error occurs: Public Function SaveResultsToExcelSheet(RangeOfValues As Range, ValuesArray() As Double) As Boolean On Error GoTo Error: SaveResultsToExcelSheet = True Dim OutputSheet As Worksheet Dim OutputCell As Range Dim Counter As Long Counter = 0 For Each OutputCell In RangeOfValues OutputCell.value = ValuesArray(Counter) Counter = Counter + 1 Next OutputCell Exit Function Error: Err.Clear SaveResultsToExcelSheet = False End Function The error occurs in the line "OutputCell.value = ValuesArray(Counter ...Show All

• riemerg MS Access User Defined Permissions

  Hi there - im building a contact management system and require some help with coding. I have a table (tblusers) for users that contains their information e.g. user name , password and tick boxes that will hopefully allow them to edit certain levels within the hierarchy of the system e.g 'allowcompanyedit' tick box will allow users with that box ticked to create and edit company information, 'allowcontactedit' tickbox will allow users with that bx ticked to create and edit contact information etc etc. I have created a user login screen and added code to a command button that checks their credentials against what is held in the users table to see if they should be allowed to log in or not. I would like to add additional code that will also ...Show All

• Tryin2Bgood VBA marco in Outlook disappears

  Does anyone know why a macro would disappear after a period of time, typically about 2 to 3 months I installed the merge to word macro from "Ten Tips for Office Developers(Feb 2003). Modified it for Word 2003 - referenced MSWORD.OLB. Running XP SP-2 with Office 2003. Thanks At least in Outlook 2003, VBA code is normally stored in "Documents and Settings\%user name%\Application Data\Microsoft\Outlook" in a file called "Outlook.OTM". If this file is overwritten as part of an upgrade or patching process, your macros will be wiped out. Is it possible this is what happened ...Show All

• MJC2006 Commandbar excel bug for "Document Recovery" commandbar

  Has anyone heard of a bug with the Document Recovery commandbar I have a VBA program that uses the ScreenUpdating property to save time; however, if Excel comes up with a document recovery list, and I close the document recovery commandbar prior to executing the macro, the commandbar still reserves this portion of the screen as a blank. Can click it - can't do anything. Looking at the application it is clear that once you close the document recovery command bar - there is no more commandbar called document recovery in the application - yet this thread is still running in the foreground - preventing excel from working properly. The workaround is to resolve document recovery issues so that excel comes up without any documents - o ...Show All