Search results for query: *

Thanks JulieInMaine. Carlos Cesar tanaka Curso de Excel / Access MPR Informatica

Yes I vê done this. It seems correct. I assigned $1 for each resource cost, is that right. Carlos Cesar tanaka Curso de Excel / Access MPR Informatica

Hello, I need to compare the amount of finished work ( % finished work) against the the ideal work (work without delays) finished in a status date. How could I obtain the last one? Thanks in advance. Carlos Cesar tanaka Curso de Excel / Access MPR Informatica

The solution presented by SkipVought has worked, besides it is simpler. Thanks. Carlos César tanaka Curso de Excel / Access MPR Informática

Hi, I am trying to create a Dynamic Chart using named ranges. 1. I created two named ranges as follow: CatX - workbook scope, with the formula: =OFFSET(INDIRECT("'Week Data'!$B$" & Metas!$C$4+2);0;0;Metas!$C$5-Metas!$C$4;1) CatY - workbook scope, with the formula...

Hi, How can I create a report of kind cross reference with: Resources, tasks and note in the lines Time in the columns Duration in the Data area (intersection between lines and columns) Thanks in advance. Carlos César tanaka Curso de Excel / Access MPR Informática

Hi Gruuuu, I have understood you did not used POST options in VBA before, but I think you really can help me. Here is a code that uses this method, that I adapted from site http://www.business-spreadsheets.com/forum.asp?t=103 You have to create an account and change in the constants below...

Thanks again, One more doubt, I have seen the code place you have posted above. Shouldn´t we also send two more parameters which appear some lines below in the code of Resumo_semanal_index.asp? These parameters are: rdResumo selCombustivel Carlos César tanaka Curso de Excel / Access MPR...

Hi Gruuuu, I have researched this subject and discovered that is possible to make a Excel Web Query to a site that has a form using POST method. It has to use a IQY file, separating URL from parameters. My problem is I am not being able to discover what are the parameters (names). Could you...

Thanks Gruuuu, I am trying to extract data from that table using HTML elements. I would like to know if it is possible to make a web query (using Excel / Data) to navigate through links of web page and options of forms, and then extract a table, like that I described in the previous post. I am...

Hello, I cannot import data from teh following site: http://www.anp.gov.br/preco then link "SEMANAL - RESUMO I" Select option button ESTADOS, combo box GASOLINA Submmit - Processar The resultant table, starting with word "ESTADO" in light blue, has spanned cells (in the header), I think Web...

Thanks for the answer. I use Project 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000), Brazilian. The default working period is 9:00 to 18:00. THe hints you have made did not solve the problem. Have you followed the steps before to verify if that problem really exist? I think it could be a...

Hi, I am having a problem working with nondefault calendar. I am using MS Project 2007 (office with SP2 - Language Portuguese) Situation: 1. Start a new project. a. create a task with duration of 1 day in a friday b. create a second task with duration of 1 day and make a constraint Finish...

Hello, I have a SBS 2008 Standard Server with Backup Exec 12.5. I would like to have some cheap redundancy, so I thought about having another server in the net (a Windows Server 2008 Std) configured as a secondary server, plus the data on the first server. For the data I want to use backup Exec...

Yes that works. It follows my idea, the difference is that I create variables to make changes flexible. If one do not need parameters just cut them off. Carlos César tanaka Curso de Excel / Access MPR Informática

David, I have upload an example. It´s a Excel 2007 macro enabled file. See that. Carlos César tanaka Curso de Excel / Access MPR Informáticahttp://www.4shared.com/file/102994187/a6037408/copiar_lista_para_outra_planilha.html

David, I assume that, the sheet with all data is named sheet1 the sheet with the results is named sheet2 You can add VBA code to the sheet1 (Go to VBA Editor, then double click Sheet1 on the project explorer) Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim start As String Dim...

You can change the default application. Open Windows Explorer, then find out a Excel file. Right click this file then choose Open with Choose Excel 2000 Application, use the Find button. Usualy Excel 2000 application is in: C:\Program Files\Microsoft Office\Office9\excel.exe After choosing the...

Nick0 The text you read in manual maybe a little trick. You must use a direct cable to connect A LAN PORT of 3c857 TO THE WAN PORT of the same 3C857. It must work. Carlos Cesar Tanaka