Search Results

Search found 7704 results on 309 pages for 'excel 2011'.

Page 83/309 | < Previous Page | 79 80 81 82 83 84 85 86 87 88 89 90  | Next Page >

• Excel 2007 UDF keeps failing, why?

  - by Zan

  I've been trying to browse info about this for a while now. The user defined functions in Excel 2007 just make no sense to me whatsoever. According to all the tutorials, it should be really simple. Just press alt + f11, insert a new module, and enter the VBA code there. At this point typing '=FUNCTIONNAME(parameters)' into any cell should make it work. It did, at first. Then upon closing and reopening the worksheet it stopped working. I checked to see that macros were enabled, but either way, that didn't help. Then I browsed the graphic UI from the function button to locate user defined functions. I found it there by name of 'MyExcelWorksheet.xls!FUNCTIONNAME.FUNCTIONNAME' and clicking that, it started working again. Now, a day later, I get back to working on this and it's broken, again. I just get #NAME? error or some "Function Arguments - Function doesn't use any arguments" -popup (translated from Finnish Excel, not sure what that msg is in English) when I select the function from the GUI. So what does it take to just create a function, and actually make it work and KEEP working? For the life of me I can't figure out why this has to be so difficult. :) I'm starting to think my company has some weird settings enabled or whatever, because judging by the lack of information I've found on the subject, this isn't supposed to happen.

  Read the article

• Excel - Best Way to Connect With Access Data

  - by gamerzfuse

  Hello there, Here is the situation we have: a) I have an Access database / application that records a significant amount of data. Significant fields would be hours, # of sales, # of unreturned calls, etc b) I have an Excel document that connects to the Access database and pulls data in to visualize it As it stands now, the Excel file has a Refresh button that loads new data. The data is loaded into a large PivotTable. The main 'visual form' then uses VLOOKUP to get the results from the form, based on the related hours. This operation is slow (~10 seconds) and seems to be redundant and inefficient. Is there a better way to do this? I am willing to go just about any route - just need directions. Thanks in advance! Update: I have confirmed (due to helpful comments/responses) that the problem is with the data loading itself. removing all the VLOOKUPs only took a second or two out of the load time. So, the questions stands as how I can rapidly and reliably get the data without so much time involvement (it loads around 3000 records into the PivotTables).

  Read the article

• Exporting and reformatting data out of MS Excel

  - by Matt H

  I have a huge Excel spreadsheet containing telephone calling rates to a number of different countries. The format of the columns is: Country, RateLocality, Prefixes, Rate, Wholesale e.g. Afganistan, Default, 93;930;931;9321;9322;9323;9324;9325;9326;9327;9328;9329;9331;9332;9333;9334;9335;9336;9337;9338;9339;9341;9342;9343;9344;9345;9346;9347;9348;9349;9351;9352;9353;9354;9355;9356;9357;9358;9359;9361;9362;9363;9364;9365;9366;9367;9368;9369;9371;9372;9373;9374;9376;938;939; $ 1.023, $0.455 These rates change every so often and I need to get them into another system that can import them using CSV. The eventual format is: LD PREPEND CODE ie. 00 or 011,CountryCode,Area Code,Comment,Connect Cost,Included Seconds,Per Minute Cost,Pricelist,Increment So to convert that above line I'd have 00,"Afganistan",93,"Default",1.023,60,1.023,10 00,"Afganistan",931,"Default",1.023,60,1.023,10 ... 00,"Afganistan",939,"Default",1.023,60,1.023,10 Where 00, 60 and 10 are hard coded and merged with the other data from excel. How can I export this data into the required format given that I need to reformat it as it goes. Should I export to XML and use XSLT or some other process to massage the data into CSV? If that is the case, how do I do it simply and quickly.

  Read the article

• Reduce file size for charts pasted from excel into word

  - by Steve Clanton

  I have been creating reports by copying some charts and data from an excel document into a word document. I am pasting into a content control, so i use ChartObject.CopyPicture in excel and ContentControl.Range.Paste in word. This is done in a loop: Set ws = ThisWorkbook.Worksheets("Charts") With ws For Each cc In wordDocument.ContentControls If cc.Range.InlineShapes.Count > 0 Then scaleHeight = cc.Range.InlineShapes(1).scaleHeight scaleWidth = cc.Range.InlineShapes(1).scaleWidth cc.Range.InlineShapes(1).Delete .ChartObjects(cc.Tag).CopyPicture Appearance:=xlScreen, Format:=xlPicture cc.Range.Paste cc.Range.InlineShapes(1).scaleHeight = scaleHeight cc.Range.InlineShapes(1).scaleWidth = scaleWidth ElseIf ... Next cc End With Creating these reports using Office 2007 yielded files that were around 6MB, but creating them (using the same worksheet and document) in Office 2010 yields a file that is around 10 times as large. After unzipping the docx, I found that the extra size comes from emf files that correspond to charts that are pasted in using VBA. Where they range from 360 to 900 KB before, they are 5-18 MB. And the graphics are not visibly better. I am able to CopyPicture with the format xlBitmap, and while that is somewhat smaller, it is larger than the emf generated by Office 2007 and noticeably poorer quality. Are there any other options for reducing the file size? Ideally, I would like to produce a file with the same resolution for the charts as I did using Office 2007. Is there any way that uses VBA only (without modifying the charts in the spreadsheet)?

  Read the article

• TechDays 2011 : Microsoft expose sa vision de « la vie du futur » avec les interfaces naturelles, l'école et le bureau de 2015-2020

  TechDays 2011 : Microsoft expose sa vision de « la vie du futur » Avec les interfaces naturelles, l'école et le bureau de 2015-2020 Le troisième jour des Techdays s'est résolument placé sous le signe des tendances numériques qui seront au coeur de notre quotidien, dans la vision du futur de Microsoft, à l'horizon 2015-2020. « L'informatique de demain sera une informatique intuitive, grâce notamment aux nouvelles interfaces naturelles.» explique Bernard Ourghanlian. « L'ordinateur se met toujours plus à notre service. Il interprète nos comportements, il anticipe, il agit en notre nom.» souligne-t-il. « Avec le développement de capteurs évolués, nos bras, nos mains,...

  Read the article

• Ask the Readers: Browser Wars – Which One will be Victorious in 2011?

  - by Asian Angel

  With each passing week it seems like the browser wars are becoming more fierce as all of the participants add new features and release versions more often. This week we would like to know which browser or browsers you think will be victorious in 2011 Latest Features How-To Geek ETC How to Change the Default Application for Android Tasks Stop Believing TV’s Lies: The Real Truth About "Enhancing" Images The How-To Geek Valentine’s Day Gift Guide Inspire Geek Love with These Hilarious Geek Valentines RGB? CMYK? Alpha? What Are Image Channels and What Do They Mean? How to Recover that Photo, Picture or File You Deleted Accidentally Now Together and Complete – McBain: The Movie [Simpsons Video] Be Creative by Using Hex and RGB Codes for Crayola Crayon Colors on Your Next Web or Art Project [Geek Fun] Flash Updates; Finally Supports Full Screen Video on Multiple Monitors 22 Ways to Recycle an Altoids Mint Tin Make Your Desktop Go Native with the Tribal Arts Theme for Windows 7 A History of Vintage Transformers: Decepticons Edition [Infographic]

  Read the article

• L'essor des tablettes affecte les ventes de PCs, le marché a été très touché à Noël et cela pourrait continuer en 2011

  L'essor des tablettes affecte les ventes de PCs, le marché a été très touché à Noël et cela pourrait continuer en 2011 Fin 2010, le Père Noël n'a pas eu les mêmes cadeaux dans sa hotte que douze mois auparavant. En effet, en cette période de l'année où les constructeurs enregistrent le plus de ventes, les achats de PCs ont diminué. Deux études menées parallèlement et indépendamment l'une de l'autre sont arrivées aux mêmes conclusions : au quatrième trimestre 2010, le succès phénoménal des iPads et autres tablettes ont fait baisser le chiffre d'affaires mondial des ordinateurs. La hausse des ventes de PCs, comparativement entre décembre 2009 et décembre 2010, ne serait en effet que de 3.7% pour Gartner (et 2.7% pour I...

  Read the article

• Windows Phone 7 Developer Tools &ndash; January 2011 Update

  - by TechTwaddle

  Note: I am currently in the process of relocating my blog from http://www.geekswithblogs.net/techtwaddle to my new address at http://www.techtwaddle.net I suggest you point your feed readers to the new address as I slowly transition to my new shared-hosted, ad-free wordpress blog :) If you haven’t heard already, the Jan 2011 update of the windows phone 7 developer tools is out, er, in Feb. You can download the installation files from here, http://www.microsoft.com/downloads/en/details.aspx?FamilyID=49b9d0c5-6597-4313-912a-f0cca9c7d277 The performance increase with the new emulator is clearly noticeable and the first time deploy is real quick! The emulator image should also be a precursor to the windows phone 7 OS update that we’ve been waiting for ever. The emulator image includes copy-paste functionality which is enabled by default on all textboxes, password boxes and edit controls within web browser control, so existing apps get this feature for free. Go ahead and give the new tools a try. If you want to experiment more you might be interested in a unlocked emulator image, follow the link for more information. http://windowsphonehacker.com/latest_windows_phone_7_emulator_unlocked-02-05-11.php

  Read the article

• What is the best HTML specification to be used as of Q1 2011?

  - by Rob McKinnon

  While developing a web application, what is the best spec to use? HTML4.01 HTML5 XHTML trans XHTML1.1 I was taught to use XHTML1.0 strict in uni and to avoid applet/iframe/tables(except in forms). I noticed that some deprecated tags are available in HTML5. Is it safe to code in HTML5? If so should I use target='', and the aforementioned tags? I have noticed that there are many alternatives to choose from including canvas, object. I have no preference, although Iframe tags are being dispensed from sources like Facebook/Google/etc. What would be the best avenue to take for Spec as of now(Feb 2011)?

  Read the article

• Does attending the upcoming Devdays 2011 have some value for a resume?

  - by systempuntoout

  This fall I'm 99% going to London to attend the awesome Devdays 2011; I have many reasons to go there and some of them are: Professional stuff Great people Awesome topics Unicorns Passion London :) Obviously all the cool technologies that will be discussed are light years far from my daily work but useful for my side projects and maybe for some future employment. Now, to get to the point; a coworker said to me that he won't come with me because Devday London is expensive, and something expensive should reward you with a certificate, a certificate that could have some value to the eyes on an employer. Is he right? Do you think that attenting to this kind of event have some value on a resume? Should it be highlighted? Does it have any value for a future employer?

  Read the article

• What new games are available for Ubuntu in 2011?

  - by Oli

  I know there have been other questions like "What native games are available?" and they often have issues because they turn into a never-ending list of every game ever released for Linux. But I'd like to know what's coming out this year. Good answers can include: A game that's coming out in 2011 A Linux port being released for games that might be older (eg Trine) As much information and as many screenshots and links as possible Few old games unless they're doing a major update that changes the game very significantly. One game per answer, add as much information as possible and work with each other to build a catalogue of awesome things to look forward to this year.

  Read the article

• Will the MacBook Pro Early 2011 work better with Ubuntu than the Air Late 2010?

  - by AllanCaeg

  I got this late 2010 11" MacBook Air. I'm having issues with NVIDIA graphics, especially with GNOME Shell. I'm thinking about selling this to switch to the new MacBook Pro, particularly the entry level 13" (see specs here), because of the Intel HD Graphics 3000. I assume that it will be more FOSS-friendly. I just want to point out that there are non-negotiable reasons why I'm keeping an Apple hardware at the moment, so let's keep this on topic. Will the MacBook Pro Early 2011 work better with Ubuntu than the Air Late 2010? Any other factors than the graphics hardware? Should we expect better NVIDIA graphics anytime soon?

  Read the article

• Autodesk Maya et Qt : la version 2011 est la première à se baser sur Qt, uniquement pour le meilleur

  Autodesk vient de lancer une nouvelle version d'un de ses produits phare, Maya 2011. Cette version est un peu spéciale : elle est sortie en 2010, certes, mais c'est aussi la toute première version de Maya à se baser sur Qt ! Dans tous les derniers films d'animation, jeux vidéo, et tout ce qui se fait en trois dimensions, il est plus que très probable que des parties ont été créées à l'aide d'Autodesk Maya, un des logiciels de modélisation 3D les plus répandus et les plus avancés depuis une dizaine d'années. Ce logiciel, compatible avec les trois plateformes principales, Windows, Linux et Mac OS X, est à même d'animer les rêves les plus fous de n'importe quel studio d'animation. Si, auparavant, quelques plug-ins étaient réalisés avec Qt afin d'être compatible...

  Read the article

• Pwn2Own 2011 : BlackBerry et l'iPhone 4 vaincus lors du concours de hacking, les produits Google demeurent intouchés

  Pwn2Own 2011 : BlackBerry et l'iPhone 4 vaincus lors du concours de hacking, les produits Google demeurent intouchés Mise à jour du 11.03.2011 par Katleen Pour sa deuxième journée, le Pwn2Own a encore fait quelques victimes, mais en a aussi épargné certains. Les victimes potentielles de la journée étaient les systèmes d'exploitation mobile mais aussi Firefox (3.6), le navigateur qui n'avait pas été malmené hier. Seulement, Sam Dash, qui devait lui régler son compte, ne s'est pas présenté au concours. "Je ne peux pas écrire une code d'exploitation viable" pour ce challenge, s'est-il justifié. En revanche, l'iPhone 4 et le BlackBerry Torch sont tombés. Pour le s...

  Read the article

• Emploi : Bilan mitigé pour l'année 2010 pour les postes IT, vivement 2011 ?

  Emploi : Bilan de l'année 2010 pour les postes IT, que prévoir en 2011 ? L'année 2010 touche à sa fin, aussi, avant l'avènement de l'année suivante, il est bon de faire un bilan des rebondissements qui ont animé la rubrique emploi de Developpez.com ces douze derniers mois. Premier constat : c'était mieux qu'en 2009, année catastrophique en raison des répercussions de la crise économique. Cette année, le marché s'est réveillé. Certes, la reprise est modeste, mais elle est là, et ça se voit. Le nombre d'embauches a augmenté par rapport à l'année précédente. Les recrutements ont connu une belle croissance : la note trimestrielle de conjoncture du marché de l'emploi des cadres diffusée fin octobre 2010 par...

  Read the article

• TechDays TV : la Catch TV gratuite des TechDays 2011 pour revivre les moments forts du rendez-vous des professionnels informatiques

  TechDays TV : la Catch TV gratuite des TechDays 2011 Pour revivre les moments forts du rendez?vous des professionnels informatiques de Microsoft La cinquième édition des TechDays, l'évènement de Microsoft réunissant les développeurs, professionnels et décideurs IT, s'est achevée la semaine dernière. Cette édition a été marquée par une actualité riche et de nombreuses innovations. TechDays TV permettait ainsi aux personnes n'ayant pas eu l'occasion de se rendre sur place d'assister à plusieurs sessions et de suivre l'événement en direct. Aujourd'hui, Microsoft propose la rediffusion intégrale et gratuite des contenus de cette WebTV (conférences plénières, sélections des meil...

  Read the article

• La RC de Internet Explorer 9 disponible pour la clôture des TechDays 2011, téléchargez-là et faîtes nous part de vos avis

  La RC de IE9 est disponible Avec Do Not Track, le support de WebM et met encore plus l'accent sur la sécurité Microsoft vient d'annoncer l'arrivée de la Release Candidate de IE9. Une nouvelle qui clôt en beauté les TechDays 2011, son salon dédiée cette année au Cloud Computing. Avec cette nouvelle étape, Internet Explorer 9 intègre toutes ses fonctionnalités finales. Il ne reste plus à l'équipe du projet qu'à corriger les bogues et les dernières imperfections avant la sortie officielle. Cette RC bénéficie d'un très léger toilettage de l'UI avec des onglets carrés (et non plus aux angles arrondies) qui peuvent à présent être placés en dessous d...

  Read the article

• Imagine Cup 2011 : présentation de la catégorie Développement Embarqué du concours de Microsoft pour les étudiants, inscriptions jusqu'au 27 janvier

  Imagine Cup 2011 : présentation de la catégorie Développement Embarqué Du concours de Microsoft pour les étudiants, inscriptions jusqu'au 27 janvier La désormais célèbre compétition de développement organisée par Microsoft pour les étudiants touche aussi au développement embarqué. Une catégorie exigeante mais dont les résultats peuvent être impressionnants. Dans cette catégorie, le but est de développer une application sur une plateforme Windows CE qui aura elle-même été adaptée aux besoins des candidats organisés en équipe de 1 à 4 membres (la présence d'un mentor est conseillée). Rappelons que les version Embedded de Windows sont particulièrement conçues pour être modulables et ...

  Read the article

• Excel.Range.Find method

  - by Sathish

  I am using Excel interop object and trying to find a date in a specified range by below method Excel.Range rngFind = WS.get_Range(strFromRange, strToRange).Find(strFind, Type.Missing, Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, false, false, false); but i get rngFind as null always my strFind = "Sep-08" i tried with both Excel.XlFindLookIn.xlFormulas and Excel.XlFindLookIn.xlValues my excel file looks like this Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 where as wheni click on Sep-08 cell i get 9/1/2008 in the formula field in Excel i have also tried searching for 9/1/2008 but it varies system by system as per the RegionalSettings Date format... Please help me. basically i am doing to get the cell address of the finding string

  Read the article

• Strategy in exporting to Excel with formatting from ASP.NET?

  - by Jiho Han

  So this is another exporting to Excel question. I have a page that has a table with formatting by stylesheet. When I export the page by setting the ContentType to application/excel and Content-Disposition to attachment, I can export the table to Excel (not CSV). However, it loses all formatting. I think it's because Excel does not load CSS and I guess that's reasonable. So, in a scenario where I have to show the table on the web and also export to Excel, both with similar (even if not exact) formatting, what would be the best approach without using something like NPOI? I am trying to minimize the work and keep the single template if possible. Is it necessary for me to create two separate templates: one with stylesheet, the other with embedded style in the table itself for Excel? Having a single template with conditional formatting inside would be very messy. Any ideas?

  Read the article

• Redimming arrays in VBA

  - by Mike

  I have 3 arrays of data, that are filled by reading off of an excel sheet, some of the points of data are missing and as such have just been entered into excel as "NA" so I want to look through my array and find each instance of these NA's and remove them from the array since the information is useless. I need to update all three arrays at the same time. Sub group_data() Dim country(), roe(), iCap() As String Dim i As Integer For i = 1 To 3357 country(i) = Workbooks("restcompfirm.xls").Worksheets("Sheet1").Range("C1").Offset(i, 0) roe(i) = Workbooks("restcompfirm.xls").Worksheets("Sheet1").Range("AP1").Offset(i, 0) iCap(i) = Workbooks("restcompfirm.xls").Worksheets("Sheet1").Range("BM1").Offset(i, 0) Next i End Sub So if I find a "NA" as one of the values in roe or iCap I want to get rid of that piece of data in all there arrays.

  Read the article

• Excel VBA and InternetExplorer causing errors on website

  - by SWD

  I have some "clever" users who have written an excel spreadsheet that automates some of their tasks on our intranet/timesheet. It seems as if the instance of Internet Explorer that is created is not doing everything I expect a browser to do, e.g. set cookies. Is there a way to detect if a user is hitting a web site with a VBA com object instance of Internet Explorer? I can't keep users from building creative solutions but I want to be able to handle them. thanks

  Read the article

• How to create xml plist for Xcode from Excel spreadsheet

  - by JK

  I have a spreadsheet, the contents of which I would like to include as an xml plist in my Xcode project. However, I can't figure out how to actually perform the export from Excel and the import into Xcode. Any help would be greatly appreciated please.

  Read the article

• MS Access 2003 - Embedded Excel Spreadsheet on Access form

  - by Justin

  lets say I have an embedded Excel Spreadsheet on a Microsoft Access form. I call the object frame ExcelFrame and I add a text box on the form called txtA1 and I add a button on the form called cmdInsert I want to type "Hello World" into the text box, click the button and have it appear in the A1 cell on that spreadsheet. What VBA do I use to accomplish this? Thanks

  Read the article

• Processing xml file VS. processing excel file from .Net

  - by mayap

  Hello All, I would like to ask what should be faster: reading excel file from .Net or reading xml file which contains the same data. The same is for writing. Thank you very much in advance. mayap.

  Read the article

< Previous Page | 79 80 81 82 83 84 85 86 87 88 89 90  | Next Page >