Answer Questions

• fscarpa58 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

• riemerg Limit Macro to current workbook

  I have two Excel files with two macros in each one. One Macro Protects the all Worksheets and the other one Unprotects them. The difference between files is that one needs a password protection and other one doesn't. If I don't have both files open at the same time, they work fine, but as soon as I'm working with both files at the same time, then macros from one file can be used in the other one. Is there a way to avoid that and to limit macros from other files being execute when they share the same Shortcut keys. Here a sample code for the file with Password protection: Sub UnprotectSheets() ' ' UnprotectSheets Macro ' Macro recorded 7/12/2006 ' Keyboard Shortcut: Ctrl+Shift+U ' Dim shtCurrent As Worksheet Dim strP ...Show All

• Gianpi 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. Hi OM Gang, For me, in the very limited testing I did, the excel.exe thread was created and destroyed using that code. I can't find any documentation on an msoEmbeddedOLEObject, and wdOLEVerbHide seems to work fine. Also, DoVerb is limited to wdOLEVerb___ enumerations. Hi Jon, When I test that it leaves the ...Show All

• Chandra4332 bracketing "ifs" and "ands" and "ors" in VBA over Excel

  How would I write this in VBA if (code1 = 13 and answer1 = 15) or (code1 = 14 and answer1 = 16) then do ...... it seems not to like brackets and if answer1 has several possbilities if (((code1 = 13 and answer1 = 15) or answer1 = 20) or answer1 = 24) .... where do the brackets go  Thanks again, Hamish             The operator "AND" has a higher precedence than the operator "OR". Therefore, the "AND" operator will always be evalutated before the "OR" operator when there is no bracket. Hope this can help you. A "dialogue", to show a simple message with a couple of buttons ...Show All

• SkyCyclePilot opc

  I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it Thanks Everyone, Right now, i am using Advasol http://www.advosol.com/ opc client components for my opc client development. It looks ok till now :) I was looking for some help developing a C# OPC client using the OPCAutomation wrapper when I stumbled upon your conversation. Here is a link to a VB.Net sample OPC client that helped shed some light on using .Net to develop OPC clients using the wrapper. http://www.kepware.com/Temp/Simple_VB_dot_Ne ...Show All

• Matias Saguir Loop til you drop

  I have a loop in which I am trying to search for a cell with a ceratin textline ("Sec type"). I want to search the entire spreadsheet but if it it possible to search only some used range that is preffered. If I find the cell I am lokking for I want to check to see that it is not on the same row as some other things. These rows are specified by segment.row and secID.row. My problem is that the loop never stops running and I do not know what is wrong with it. I guess it is the Loop-line that is erronous but I do not know how to fix it. Please help me out if can! Thanks! With Range("b1:aa500") Set c = Worksheets("Berakning").Cells.Find("Sec type", LookIn:=xlValues) If Not c Is Nothing Then ...Show All

• Jules23 open a workbook with events turned off

  Is there a way to open a workbook with the events disabled   In other words, I would like to open a workbook so that links can be updated, but without executing the workbook_open or workbook_activate event procedures. Aparrently, you can do it by disabling events just before opening the other workbook and reenabling the events just after closing it. This only works if you do not execute an enableevents in the other workbook while processing in it. Hi, If you set your Macro security to medium or high then when you open the spreadsheet you will be prompted to enable or disable macros. If you select disable then your sheet will open but no code will run. Than ...Show All

• Saurabh Kulkarni Countdown / Automatic Recalc ?

  so...i'm writing a program in Excel for my friend who works at a small pool hall. I've created a countdown (initiated when the user clicks a table) and some other cool stuff. I posted a pic of the excel file here: http://jeremy.haynie.googlepages.com/rackems.jpg so right now I've got the countdown cell (17 min. 15 secs in the pic) as a normal worksheet cell...now - start time. and i've got a macro running every x seconds which makes the cell look like a countdown. I've got vlookup functions bringing back the dollar amount. here is the code i'm using to recalculate and the one to close the workbook. Basically, I've got the recalculate stuck in a loop until the user closes the workbook. Is there a better way to do this Sometimes the workboo ...Show All

• rtayek How to write a 'Find function' code in VBA for Excel

  Hi, I wrote this code in hope that it would look for the text string 'c6' which is found in one of the cells in range A1:C6. In the end I want it to assign the cell's address to a variable but one thing first. Function finn(x) 'x = Range(A1:C6) Dim y, q y = x q = Application.WorksheetFunction.Find(c6, y) MsgBox q End Function But it won't work! Anyone that knows how to write this properly Grateful for help on this \Jonas You could use a foreach construct eg dim cel as Range foreach cel in Range(A1:C6) if x = "c6" then do whatever end if next cel that should find it for you ***The syntax isn't perfect, its only a rough guide Thanks for the replay. Your start co ...Show All

• ShivaanKeldon CRM 3.0 doesn’t save my settings

  Hi, I’m having another problem in CRM 3.0. When I change any setting in the CRM system, everytime that I clicked in the OK button it should save my new settings and that’s not happening. How can I solve this Thanks, Hi We recently installed CRM 3.0. I have come across the same problem of not being able to change the system settings. Specificly the : - Settings -> Organizational Settings -> System Settings The appplication pool is using the network service account. Could you please be of assistance. Thanx in advance. Hi I found the solution in the microsoft dynamics troubleshooting guide www.microsoft.com/dynamics/crm/using/troubleshootin ...Show All

• Cavida SeriesCollection(i).Delete

  Hi, I added some series to a chart and .seriescollection.count results = 6. That's OK. Now, series(6) references to empty cells. I want to delete the series but that's not possible. Err. 1004. Series with data can be deleted without problems. How can I access the series 6. Chris That is cooool! Incredible! Thanks Chris Hi, Empty cells certainly cause problems when dealing with charts via the object model. A way around the problem is to change the chart type. Column charts are quite happy of empty data series to be deleted. With ActiveSheet.ChartObjects(1).Chart With .SeriesCollection(6) .ChartType = xlColumnClustered .Delete End With En ...Show All

• Michael_Shao CRM

  I am having problems with sharing "Leads" I upload into crm with the rest of my inside sales folks. what can I do so. ...Show All

• WehSo Log in with Active X

  Hi! Every night I have a macro that is supposed to run and open and login to a program (the Bloomberg professional) and download some data. My problem is the log in process from my macro. Now I use SendKeys but that seems VERY unreliable. Does anyone have any links with code that shows how to use some better techniques e.g. Active X to log in to a program Any help appreciated! Thanks a lot in advance! AndersBank, Logging into any program is conceptually the same process, enter a user name and password, lookup the user name in an identity store (database) and check the passwords match, and set a flag that says the user is authentic. However, behind the scenes each application/web site cou ...Show All

• iq0 (Vitual IP Problem ) Web Farming using NLB in windows server 2003 Enterprise Edition

  Hi All, We have a requirement of setting up web farm for our application.  I tried setting up with the following setup. We have setted up two Windows 2003 Enterprise edition servers both having complete application with IIS configured. I have followed the instructions for setting up the Network Load Balancing utility (NLB) comes with Win2k3 and configured two clusters. I have configured correctly with a virtual ip being used by two nodes and both the hosts in the cluster and converged correctly. But the issue is i could able to browse the url of the dedicated ips of the machines thru lan, but thru the virtual ip (or load balanced ip)  i cannot able to view the application. Since the virtual ip if i can access then only the applic ...Show All

• Izzy545 iexplore.exe - Application Error

  I get the following error message when I close my internet explorer. The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program. Any ideas what is causing this I discovered the problem. It was because of Yahoo Toolbar add on. I uninstalled it and now it works fine. Marty It sounds like you might have a badly-behaved control on your system, if you're using IE6 on XPSP2 or IE7 you should be able to use 'manage add-ons' to disable it. just disable it or add some activex control through 'manage add-ons' afte ...Show All