Answer Questions

• tattoo Set oHyper = ActiveDocument.Hyperlinks.Add( --- giving a runtime error 4198

  I have created a macro button which when clicked opens a website passing the current doc name, this is to enable the user an easier way to upload docs. This works fine for smaller docs, but I have tried this with some larger docs, in the range 200KB, not particularly massive and I get the error following error "Run time error '4198' command failed This is being returned at the call to following code section Set oHyper = ActiveDocument.Hyperlinks.Add( _ Anchor:=ActiveDocument.Range, _ Address:=tempString) All of the code for the macro is given below. Is there a size limitation on the size of document for which a hyperlink can be added As an aside - does anyone know the equivlent to ActiveDocument in PowerP ...Show All

• Tim Xue Can't make ISEVEN() work

  Problem solved! See code further down But I am still interested to now why ISEVEN() wouldn't work! Hi all, I having trouble with the ISEVEN() function. I wrote the following code without succsess. Error 'Sub or function not defined' appers when compiling the code.. I tried the command directly in a workbook with out success. It returns #Value for =ISEVEN(1) I have checked Analysis Tool-Pak VBA in Add-ins.         i = 1         For i = 1 To myLegends.Count         .ApplyDataLabels Type:=xlDataLabelsShowLabel, _                &nbs ...Show All

• sl333 Regarding Conditional Formatting.

  Hi All, I am using Excel in my VBA application. Is there a ristriction of using the Conditional Formatting If yes how many conditions I can use in a WorkBook Thanks, Basav Hi Basav, Your limited to 3 conditional formats in a work book using Excel's front screen. If your using VBA then you can program unlimited conditional formats by handling the Workbook_SheetChanged event and putting the logic and formatting in there. Hi Derek, Thank you very much for the reply. It is very helpful for me as of now. Thanks Again, Basav ...Show All

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

• ghw123 Creating MROUND function

  Hello, MROUND is a built-in function in Excel that round a number to a specific multiple. eg. =MROUND(21,5) rounds 21 to the nearest multiple of 5, which gives 20. For some reason this function is not available in my Excel (2003) and so i thought it may be useful to write the function myself using VBA. However i'm not very familiar with VBA so can someone please help me to kick start my first VBA function. Thanks! ps. i've found out after that to add the function all i have to do is go Tools --> Add-ins and tick Analysis ToolPak in the dialog box. Hi The solution is actually very simple. The following code gives the result you were looking for Option Explicit Function MyRound(Number As Double, Multiple As ...Show All

• Spider-link How to track changes

  Hi Can any one tell me how to track the changes brought by other admin users in ISA server or any option modified by them. Any log or .... any one The problem is, that Microsoft do not believe that companies big enough to have multiple administrators would use an ISA server. We have the exact same problem. Best bet is to look in your event log to see who logged on to the server when changes was done. MS needs to make basic security, lige segregation of duties, part of the minimum standard for their products. Muhammad Essa wrote: Hi Can any one tell me how to track the changes brought by other admin users in ISA server or any option modified by ...Show All

• lukef01 Excel Chart: How to change chart data source formula when object "Series.Formula" is too short?

  How to change chart data source when Formula object is too short I know that: I can assign data source 1) Series.Values=Range(...) - suitable 2) Chart.SetSourceData souce:=range(...)... - suitable 3) Series.Formula/FormulaLocal="" - not suitable because string is too short I can read data source 1) x = Series.Formula/FormulaLocal - not suitable because string is too short The question is: How to read data source not using Formula object Jon, I have what is probably a very basic question which is similar to that covered in this post. I've been putting together automated Excel spreadsheet macros for quite a while ... but I'm no expert. One thing I haven't bee ...Show All

• kwirky hung app help for web developer

  This is not a spyware or temporary internet files problem, I am a developer at a large website and the few clients who receive this error get it on every IE browser they encounter (we have logged in as them in a lot of places). I figured I would get that clear from the start. The problem is probably related to iframes and some DHTML, but it works well in Mozilla Firefox for all. When IE (6) is used to access the page, the page freezes and the error that is submitted to Microsoft is this: szAppName : IEXPLORE.EXE     szAppVer : 6.0.2900.2180     szModName : hungapp szModVer : 0.0.0.0     offset : 00000000 Please help. We advertise that Internet Explorer is the browser ...Show All

• slaprade Count characters in a string using VBA in excel

   Hi all, How can I count the number of characters in a string so it works as the example below Len() works quit well but I would like it to stop on blanks. <some function> (me) ''' return 2 <some function>(me_rest) ''' return 7 <some function>(rest s) ''' return 4  Thankful for help. \Jonas   Thanks both of you. I appreciate your help a lot! Best regards Jonas Hi, you can use something like this: Function LenOfFirstWord(byval YourString As String) As Long   Dim i As Long   i = InStr(YourString, " ")   If i > 0 Then     LenOfFirstWord = i-1   Else     LenOfFirstWord = Len(YourString)   End ...Show All

• Peejj VB MACRO IN SHARED WORKBOOK(EXCEL)

  HI, PLEASE UPDATE ME HOW TO RUN VB MACROS IN SHARED EXCEL WORK BOOK THANKS, Aravinda ChassAA ~ I'm working to set up a resource library that utilizes macros to take a user through menu options. This resource library needs to be accessible as a shared workbook so that more than 1 user can be in it at a time. Please advise the best way to protect and share the workbook but still maintain the various vb macros. Description of set-up: There are multiple tabs within the workbook but only one tab displays at a time depending on the menu selection. It is set up to run with a topics menu, category menu for each topic, resource menu for each category, and a file menu for each resource. Step through example: The ...Show All

• Obrzut 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 I'm trying to get the Add-In to work but am having some problems. I created the Add-in, but I only want it to work for those specific presentations and not for every presentation I work with. I also only want it to run only once. Once my macro runs and saves the presentations on the drive, I went back ...Show All

• Stormin Error Handling in Excel VBA

  Hello, I am trying to connect to a database through a userform. The database expects a valid user name and password. I do I handle the error if someone puts in an invalid user name and password I want to display the error message which the system returns to the user. Kindly help Thanks something like this: in this example 'user' is the name of the text box on the form for user name input and 'password' is the name of the text box for password input 'Check to see if data is entered into the UserName combo box If IsNull(user) Or Me.user = "" Then MsgBox "You must enter a User Name.", vbOKOnly, "Required Data" Me.user.SetFocus Exit Sub End If 'Check to see if data is ...Show All

• j.harkness Elegance (and performance) Problem

  Hello, I developed a class (class CMatrix, that holds a lot of functions not really related to the other class) to use in another class. Currently, it's working real fine, but I don't know if there's a better way to handle with this. What I do today is, in the main class: Dim Matrix As CMatrix ... somewhere in a sub or property Matrix = CMatrix.MergeSort(Matrix) ... rest of the code If my CMatrix could acess the data in the main class, it would be fine, bc I wouldn't have to pass nothing. Thx in advance =] Even if I pass the variables by reference, so I can change them right away, would it be wrong In most cases, you don't want to use pass by refer ...Show All

• djmikke Recommend a book please

  I am in the very early stages of trying to teach myself VBA for MS Word. I have some knowledge of programming in Java and C++. I need a good book to get me started. I have found it is not the code itself that I am having trouble with, it is how the environment works that has me confused. I need to see how to implement solutions to some basic real world problems. Seeing code examples in isolation is not proving to be of much use, I can work that out. I need to see examples of how you implement the code and incorporate it into documents for use, and then how you use it. For example I need to know the whats, hows and whys of projects, modules, class modules, objects, user forms, references, MS Word objects and templates etc. All these term ...Show All

• NewInput Need help with Winsocket control in Microsoft Access Database form.

  I'm trying to create a telnet session within my microsoft access form. I included the microsoft winsocket control and some text boxes to place the recieved data. The problem I'm having is I recieve data but it is all scrambled like yt%yy and it doesn't take any of my data I'm entering. The current telnet software I'm using is using VT101 emulation if that might have something to do with the scrambled info, but I dont want to use this software and Access. I would like to keep it all in one application if possible. I just need some help where I might be going wrong or any other idea's. Here is a sample of the code I'm using. Option Explicit Const EchoPort = 23 Private Sub cmdConnect_Click() Dim temp As String temp = ...Show All