Search results for query: *

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 =...

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...

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...

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...

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...

I want to do this: I have an excel spreadsheet with some graphs. every week I update all the data and I have to present in a ppt all the updated graphs. Now my bosses want to show all this stuff not in a ppt format but in a web format. so I have to take all the graphs from excel and put them in...

Hi, I have a table in one worksheet. In anoter worksheet I link the firts cell on the left on top. I erase the dollars in the formula and I drag and drop the cell so I can import in this new worksheet the table. They are made something like: =[Book3]Sheet1!A1 =[Book3]Sheet1!B1 ..... Now I...

Hi, I want to pass to a user made VBA function non only a range bu a multiple range. In particular, in excel it is possible to make something like: =SUM(Sheet1:Sheet3!A1) and it makes the sum of Sheet1!A1 +Sheet2!A1+Sheet3!A1. I'd like to have a function that can manage the same type of...