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...
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...
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...
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
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
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...
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...
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...
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
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
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...
@ 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
@ 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...
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
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
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.