Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: apeoortje
  • Content: Threads
  • Order by date
  1. apeoortje

    outlook referencing recieved email

    I'm trying the write a peiece of code that verbally noticifies the user of the sender of a incoming message but I'm stuck with not know the object name for a newly recieved email code I have so far is: Set myItem = Application.NewMail bob = myItem.SenderName UserForm1.TextToSpeech1.Speak "you...
  2. apeoortje

    Limiting a SheetBeforeDoubleClick to cell range

    I'm using the following code to enter the time on a goup of cell, is there any way on limiting it'll only work in cells C4:D34? Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Selection.Value = Time End Sub
  3. apeoortje

    How do I reference to a userform in another workbook

    I trying to write a code that when you close close workbook1, if the userform in workbook2 is not active then activate it. My only problem is I don't know how to reference the userform in another workbook
  4. apeoortje

    change link on guest IP address

    I'm trying to write a script that depending on theier IP address the link will change to a different website. I only normaly wirte in VBA, so as you can guess the code below doesn't work!!! any ideas on what I'm doing wrong?!? <HTML> <HEAD> <TITLE></TITLE> <SCRIPT LANGUAGE="JavaScript">...
  5. apeoortje

    Selecting a group of Cells in a unknown row (Excell 2k)

    I'm in the process of writting a macro to a number of cells into another workbook. the only problem I'm having that the Macro I'm writing needs to find the row it's self before it able of copy the Data. What I need to do is to copy Cells on the Active row from A to D collumn. but I stuck!! I...
  6. apeoortje

    TTS in excel 2000 on OS: win2k pro

    I have written a Macro so when it runs it reads the daily totals of a report using Text to speech. I just the quick question is it posable to change the default male voice to a female one?!? ================================================ Application.ScreenUpdating = False Workbooks.Add...
  7. apeoortje

    How to Find the DivID in Excell

    I am trying to wirte a marco to save a page of a work book in to html format. I thought I could do it the easy way and just record the macro, but the DivID changes each time you open the document. Does anyone know how to find out the DivID
  8. apeoortje

    unable to open an page over menu script in a frame

    I'm have 5 buttons each of which open a menu item the same as the one below in a menu frame. but the problem is that once you have a menu in the frame. you can't open another one. Any Idea how this can be change (PS I'm not very good with Java) <html> <head> <title>Cascading Menu</title>...
  9. apeoortje

    Can't open a new webpage over an already open one

    I'm have 5 buttons each of which open a menu item the same as the one below in a menu frame. but the problem is that once you have a menu in the frame. you can't open another one. Any Idea how this can be change (PS I'm not very good with Java) <html> <head> <title>Cascading Menu</title>...
  10. apeoortje

    Can't open a new webpage over an already open one

    I'm have 5 buttons each of which open a menu item the same as the one below in a menu frame. but the problem is that once you have a menu in the frame. you can't open another one. Any Idea how this can be change (PS I'm not very good with Java) <html> <head> <title>Cascading Menu</title>...
  11. apeoortje

    Save Excel Sheet while viewing in Web format

    Does anyone know how I save save an excel workbook while I'm viewing it in Internet explorer. I know you can do it when you go to close by I don't what that. I would like a save button or an auto save or something. Can any one help?? Thanks T
  12. apeoortje

    changing the format on a date to text.

    I have formulars in a sheet which workout the begin and end date of the weeks in a month. unforunatly this info almost spreads itself randomly across the page. So I have a macro which copies the data and puts it in a cell. I use the number to create a week total in a report. with the code...
  13. apeoortje

    External Data

    I have a workbook which is link to many other workbooks, everytime I go to open the workbook which is filled with external data I get this message 'do I want to update the external data'. This is ALWAYS answered yes, does anyone know how to make is automatic click yes?!? I've tried...
  14. apeoortje

    Copy then content of one cell and pasting in another

    I've written an Excel sheet that displays the begin and end date of each week in the current month. unfortunaty these result are almost ramdomly placed in a collum, and are of little use as I still have to put in the information in a cells I want it in by hand. does anyone know if there is a...
  15. apeoortje

    Date Codes in VBA Excel 2000

    I'm having problem with a Excel VBA marco I'm writting, but I need VBA to tell me when the beginning and the end of every week in the current month. At the moment I have it going through an input box, but I want to cut out Human error. Can anyone help me Thanks Terry

Part and Inventory Search

Back
Top