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!

  • Congratulations Mike Lewis 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: *

  1. DeGeus

    Decimal seperator and Excel 2000

    Hi, I have existing excel sheets which have to be transformed to XML files. I'm living in the Netherlands where as default the "," (comma) is the decimal separator. Now for the XML file the "." (dot) has to be the decimal separator. At home I have Excel XP and there I have a function decimal...
  2. DeGeus

    Translate menu items

    Can anybody help me with a list of the different menu items translated in the following languages, English, dutch, german and french. I need this for because some of my clients are in those countries and when they ask me a question they have to open a certain menu. But I have no idea how this is...
  3. DeGeus

    Uploading document to the internet

    I want to upload an excel document to a internet location with help of a VBA macro. Now I found something in the helpfile but I think I have the following problem. When I want to upload something to my homepage I have to supply a password. But this is not incorparated in the code. Can anybody...
  4. DeGeus

    Selecting multiple sheets in Excel

    Yes I did. But there was another procedure in the same module for wich I declared some things outside the procedure. Now I removed this procedure an dit works Now it works. You get a big, big star from me for your patience and good advices. Many many thanks Leendert de Geus WWW.CEC-CES.nl
  5. DeGeus

    Selecting multiple sheets in Excel

    The program works until this line: Sheets(Bladen()).Select Then I get an Error 9 message. For your info I'm working with Micrososft Excel 2000 SP-3 And again many thanks foor your support so far Leendert Leendert de Geus WWW.CEC-CES.nl
  6. DeGeus

    Selecting multiple sheets in Excel

    This helps me partly. Because I don't know the contents of the array. You have given an example of three sheets. But this can be one to lets say ten sheets. Also the names of the sheets is not fixed. So is there a way to make that flexible then it's the perfect solution. For example. I have a...
  7. DeGeus

    Selecting multiple sheets in Excel

    I have a excel workbook which can have a different number of sheets. With a VBA program I check the the content of the sheets. For this I have to loop trough the sheets. Now I want to select multiple sheets but this can differ from run to run. als the sheet names can differ from run to run. I...
  8. DeGeus

    Importing XML file into Excel 2000

    It is possible to open an XML file in Excel. But when I do that all records are placed on two lines. One header line and one data line. Now I can't find any program to help me out. Must the XML file follow certain rules? I don't have acopy of the file here. (I a'm at the office now and it is a...
  9. DeGeus

    Maxium size Excel file

    When I make an Excel file and it exeeds the size of 100Mb its impossible to open it the next time. Does anybody know this problem and has anybody a way around. (Making the file smaller is no option) Used excel version: Excel 2000 RAM memory of the PC: 512Mb Leendert de Geus WWW.CEC-CES.nl
  10. DeGeus

    Auto increment in Excel

    When I enter f.e. X1 in a cell an dI pull this down it will increment to X2, X3 etc. A single number 1 doesn't. There is no formating applied Thanks for the quik reaction Leendert de Geus WWW.CEC-CES.nl
  11. DeGeus

    Auto increment in Excel

    Can anybody explain what are the rules for Excel to apply aut increment. Somtimes when I enter a number into a cell and I pull the cell down the number increments and sometimes not. When I enter to numbers in two cells beneath each other and I select them both and then pulls the right lower...
  12. DeGeus

    Translation of functionsnames

    @ byundt This is exactly what I'm looking for. Many, many thanks. You've received your star already. [2thumbsup] @ Patrik thanks for your help, but as yoe read above, byundt offerde me the solution. Leendert de Geus WWW.CEC-CES.nl
  13. DeGeus

    Translation of functionsnames

    @ Patrik I value your posts but the problem is that for example a german person calls me and asks me for a certain function. Than I do know the gramar in dutch but don't know the gramar in german (for example) So on that moment it would be handy to have a list with translations lookup in...
  14. DeGeus

    Printing notes in Powerpoint on more then one page

    When I make notes in a powerpoint presentation and I wan tt o print them not the hole note is printed. (I know I make long notes) I've adjusted the model but still there is to much text to print on one page. Is there a possibility to print notes on multible pages? Leendert de Geus WWW.CEC-CES.nl
  15. DeGeus

    Warning when not responding to meetingrequest in Outlook

    The problem is that i'm not a participant of the meetings, so their not in my private agenda. So its a bit difficult to check them a day before the meeting takes place. So the idea is good, but not functional for me. Leendert de Geus WWW.CEC-CES.nl
  16. DeGeus

    Translation of functionsnames

    I have contact with office users wich use different languages. Most used are dutch, englisch and german. I'm normally working with the dutch version of Excell 2000 but sometimes somebody calls for help on a certain problem. I do know then the formula name in dutch but have no idea how it's...
  17. DeGeus

    Warning when not responding to meetingrequest in Outlook

    When organizing a meeting with Outlook I can invite people for attending the meeting. The get a e-mail in wich they can accept the invitation or not. But because I organize several meetings on behalf of different people it is difficult to follow if everybody responds. For example, I organized...
  18. DeGeus

    Enter symbol in word cann't be removed

    In word there is a button to toggle the visibility the enterbutton symbol on the screen. For some reason this function doesn't work anymore. can sombody give a solution I'm working with Microsoft Word 2000 SP3 Leendert de Geus WWW.CEC-CES.nl
  19. DeGeus

    Words changed with spelling starts with capital

    When I type an e-mail in Outlook 2000 and I use spelling to correct mistypes of me then every word wich si changed starts with a capital. The position in the sentence doesn't matter. In Word there are no problems and are words correctly replaced. Can somebody give a hint or a solution to...
  20. DeGeus

    E-mail adresses disappear by some receivers

    We use Exchange 2000 and Outlook 2000 When I make a distribution list containing names out of the following sourses: - the general adres list of mail system - contacts from outlook When I use the distribution list the mail is send to everybody in the list. But the mails sent to the people from...

Part and Inventory Search

Back
Top