Recent content by terzaghi

I need to set with a formula (so it changes every time i change values without manula handling) the maximun and minimum scaliing of the Y axis of a bar graph. Does anyone know how to accomplish that? If I try to insert a formula Excel says that an integer is required Thanks! Andrea

Hi, I'm searching a method to write a text file that insert at the end of each line a Chr(10) (web standard) and not a (Chr(13) + Chr(10)) like "Print #" does. I guess I have to write a binary file so I can insert whatever character I want. Can anyone tell me what are the commands to do so? I...

Hi, I use this code: ____________________________________ Sub SendEmailHTML() Dim olApp As Outlook.Application Dim olMail As MailItem Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .to = "aaa@bbb.com" .Subject =...

Combo, I think you made your form and code with Win2000, correct? with win2000 it works fine as I already said, but I tried also with WinXp and the result is that "Me.MediaPlayer1" is not understood by the compiler, insted you have to write "Me.WindowsMediaPlayer1" and the method .Open does...

Thanks a lot! It works very fine. I have only a Problem... How can I detect the end of the movie so I can close the form by utself without a click? I didn't find any method in MediaPlayer activeX. maybe it's because I'm tired...

Hello, is it possible to control Windows Media Player from Excel such as I can execute videos or sounds (voice recording) when a certain condition is obtained? Obviously I check the condition with a macro... I need to open WMP, execute a certain media file and then close it when finished. I'm...

Ok done. Format cell "??/??" (never used this format!!) Bye

Hi, I need to whow numbers in excel cells in this format: Number 3,5 ---> See in Cell: "7/2" number 2,2 ---> See in cell: "11/2" i.e. I need to see a fraction done with integer numbers (i.e. the the fraction with the smalles integer numbers that rapresents that decimal number) does anyone...

Hi, im'trying to automate the sending of email from excel using Outlook. I use this macro: ----------------- ' requires a reference to the Microsoft Outlook 8.0 Object Library Sub SendAnEmailWithOutlook() ' creates and sends a new e-mail message with Outlook Dim OLF As Outlook.MAPIFolder...

If you want to use it in another workbook you have either do copy the module in every workbook where you want to use it or to save it in an .xla module and load in at the starup of Excel.

Skip! It works thaks a lot!

I tryed that but with Microsoft Excel 2000 ver. 9.0.2812 it doesn't work.. which version do you have? Thanks a lot!

Hi. I need to change every month the title of a 25 different graph. Totday the title of the graph is "October" I have to change all the titles in "November" a simple code is: Sub Macro1() ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartTitle.Select...

Yes I know the formula. as you cans see it says A^N/N! where A is the erlangs and N is the number of servers. in our problem erlang is a number like 100 and N is a number like 120 so I have to evaluate a number like 100^120/120! (120! is 120*119*118*....*5*4*3*2*1) so the problem is that exel...

Hi, does anyone has a roubust algorithm to calculate the erlang c formula? I found on the Internet a good algorithm for Erlang B formula. The Problem is that, in order to evaluate the result, it is necessary, in practical situation, to calculate numbers such as 200^100 and 200! thanks to...