Answer Questions

• KC416 Change a value for a link to another Excel file

  I do not know much about Visual Basic and maybe somebody know how to change the value 100,200,50,75 by a link to another excel document Dim A As Integer Dim B As Integer Dim C As Integer Dim D As Integer A = 100 B = 200 C = 50 D = 75 ActiveSheet.Shapes.AddShape(msoShapeRectangle, A, B, C, D). _ Select Range("B2").Select End Sub Tanks a lot Create a workbook called 'Shapedata.xls' and enter values in A1:D1, then insert this code: Dim dataWB As Workbook Set dataWB = Workbooks.Open("c:\documents\shapedata.xls") 'change to correct path A = dataWB.Worksheets("sheet1").Range("a1").Value B = dataWB.Worksheets("sheet1").Range("b1").Va ...Show All

• madenci returning an array of user-defined types from a function

  Hello, I'm relatively new to vba (and vb in general), so I appologise in advance if this is a dumb quesion. I have a function which I want to return an array of user-define types from. I am getting this compile error, however: "Only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions." This is my code: Type field1 As String field2 As Integer ... End Type ... Function GetArray() ... Dim arr() As MyType ReDim arr(Selection.Rows.Count) As MyType i = 0 For Each Row In Selection.Rows Dim curr_type As MyType curr_type.field1 = ... curr_type.field2 = ... arr(i) = curr_type i = i + 1 Next GetArray = a ...Show All

• jheddings Windows XP - Genuine Microsoft Software Popups

  My Windows XP single user is a genuine copy that I recieved from the University. After I tried to update I keep getting the annoying "You are a victim of software piracy" error. It won't go away, I can't update my Windows, and I don't know what to do to fix it. Any suggestions ...Show All

• Dario Galvani Can't open regedit

  Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks XP Profesional (5.1, Build 2600) I have exactly the same problem, do not know when it started. The information is not helpful. details: XP prof, version 2002, SP2. I can open the registry with an external tool: TuneUp Utilities. Help would be appreciated. First do a search to see if your copy even has it. Click search, type regedit.exe. If it shows up then click run, type in REGEDIT I had this same ...Show All

• Praveen Dayanithi Argument syntax problem

  I have a problem with the syntax of my code. I first have a loop that checks if an object in the selection is a chart. If it is a chart then it passes that chart on to a sub as an argument. In that sub changes are made to the chart in therms of style, size etc. My code: Sub arrayLoop() Dim obj As Object For Each obj In Selection If TypeName(obj) = "ChartObject" Then Call linjeDiagramKnapp(obj.Chart) End If Next End Sub Sub linjeDiagramKnapp(argChart As Object) Dim mySize As Double With argChart.Chart .ApplyCustomType ChartType:=xlUserDefined,TypeName:="Standard" With argChart.Chart .Height = 150 .Width = 150 .Top = 100 .Left = 100 End With My problem is that I do not know how to write the part of the code referring ...Show All

• DanglingChap 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 www.ilog.com There are many companies providing .NET controls for ...Show All

• Solkar Task Scheduler

  I want to open a certain Excel document at the same time every day. I thought about using the 'Programs->Accessories->System Tools->Scheduled Tasks'. But when I choose this it is empty i.e. there are no icons for e.g. 'Add new task'. Is this perhaps due to the fact that I am working on a network and I may not have access to adding new tasks Are there any other explanations I know it is a bit vague but if you know anything then please help me! Thanks! This q is answered here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=555039&SiteID=1 With proper permissions (I don't what that is, but probably local admin) you will see a "Add Scheduled Task" icon. This tool is a GUI for ...Show All

• Piotr Ignaczak How to pass a value of a clicked cell to another cell in a different worksheet?

  Guys, How to pass a value of a clicked cell to another cell in a different worksheet Thank you! Use this in the module, it will pass the "formula" for clicked cell to sheet2 at A1. Use ActiveCell.Value if you want to value instead. You have to triger this macro by hand. About pass the value to a diffrent cell, just be creative. sub PassData() Sheets("sheet2").Range("A1").FormulaC1R1 = ActiveCell.FormulaC1R1 end sub Hi Guys: I work it out. It is very simple. one line of code is enough Private Sub Worksheet_SelectionChange(ByVal Target As Range) Sheet2.Cells(2, 2) = Sheet1.Cells(Target.Row, Target.Column) End Sub simply copy the sub t ...Show All

• bes7252 How do i reference a cell in an unopened workbook?

  I want to get information from a network drive that i have access to and all users will have access to.  Would it be something like workbooks("c:/folder/workbookname").worksheets("Sheet1").range("a5")   Also, is there a way to shorten things a bit so that I only have to declare the location once then use a variable to reference it after that You can make it opening the workbook. Dim wb As Workbook, ws As Worksheet, v As String Set wb = Workbooks.Open("c:\folder\workbookname.xls") Call Windows("workbookname").Activate Set ws = wb.Worksheets("Sheet1") v = ws.Range("a5").Value Call wb.Close MsgBox v Hi, You can make use of the fact that a cell formula can read from a closed ...Show All

• poon23 Action Pack Question

  I am interested in the Action Pack. I understand that it comes with the Vista upgrade, not the full edition. I do not have 10 licensed copies of XP Pro to upgrade from. So does that mean I will need to purchase a licensed copy of XP Pro for each machine that I want to put the Action Pack upgrade version of Vista on I received an answer from Microsoft via email and it stated that I will receive the full Version of Vista Business. Greetings, Although the DVD says "upgrade" you can boot from the DVD and do a clean install of Vista Business, which I've done on 3 different PCs so far (new ASUS P5B, 3 yr old ECS 741GX which is a very wimpy machine in general, and 1 new Dell Latitude D620 laptop). It has recognized a ...Show All

• Will Riley Problem with Microsoft CRM 3.0 Outlook Client

  Hi, I’m having a problem with my MSCRM 3.0. When I install the Outlook Desktop Client, on my computer, everytime I that I log on to the CRM application (on my web browser), the SETTINGS folder is no longer available. If I unnistall the Desktop Outlook Client, when I log on to the application trough the web browser, the SETTINGS folder shows up gain. How can I solve this problem I need them both working. Thanks, The web access needs to have a different alias than the outlook access. Use Server Netbios name for one and IP address for the other... See page 18 - Working with Microsoft Dynamics CRM 3.0 - M. Snyder et al. Per the support engineer: I’ve researched the issue. I think the installation of ...Show All

• PLeopard creating hyperlink through vba

  hi, i'm facing a bit of a situation that's been driving me nuts for about 12 hours now. in a nutshell, i have a lot of data in access, where i use vba to crunch numbers, and from the same project, i open an existing excel file (thereby now using both excel and access functionality from the same vba code), where i need to paste and format the crunched data (reports) to look pretty, and be user friendly. in the user friendly part, i dynamically need to create hyperlinks from one cell to another cell (in the same workbook, and some even within the same sheet). it seemed straightforward enough, but i have tried EVERY possible approach...using the (worksheet).hyperlinks.add function, as well as trying (worksheet).(cell).formula = "=hyperli ...Show All

• lawrenceville_bruce Automating PowerPoint

  I have a vba procedure within a ppt presentation that creates a new presentation with a set of slides and saves it. This process is repeated until about 30 different presentations are created, but I would like to automatically execute it at a specific time so I don't have to run the code manually everyday. Can you please suggest how I can automically execute my vba code to run thank You! Jenise One possible way around the limitations of Powerpoint is to use Excel to automate powerpoint. As Excel workbooks support the AutoOpen event. You will need to port your code over to excel. And within the code create a reference to Powerpoint. No doubt your code will require other changes in order to wo ...Show All

• GTrz Does anyone know some good places to look for Architects

  My name is Chris Cox and I work for Intuit recruiting technical talent. I wanted to check in this forum to see if anyone knew of any good associations, user groups, blogs, or even good architects. Feel free to email me if you have any suggestions. Thanks, Chris Cox chris_cox@intuit.com Hi Chris, Please let me know what kind of technology you are looking for I will be able to answer. Thank you, Jack I'll contact you by email this evening. Can you provide a bit more information about what you're looking for ...Show All

• Euclidez Making changes to Access database table - via Recordsets or Update Queries?

  Hi, firstly, sorry if this is the wrong part of the forum for this question (things seem to have changed recently). My question is this: I am writing some VBA code to automate a job that I perform regularly, in MS Access. I need to carry out updates to data in an Access table, in a repetitive manner. The data needs to be put in a format that is mailable, I need to create fields like Age (from dob), Age Bandings, Gender (from title) etc. Before I knew any VBA, this was all done with Access Update queries and some lookup tables, but I never bothered writing a macro to speed this up. Now that I understand recordsets a little better, I've written some code to automate much of what I need to do, but to be honest, I dont know whether t ...Show All