Search Results

Search found 6995 results on 280 pages for 'word vba'.

Page 166/280 | < Previous Page | 162 163 164 165 166 167 168 169 170 171 172 173  | Next Page >

• Excel plugin: Finding a Chart's Source Data Number Format String

  - by Jack

  I'm currently working on a plugin for excel (using VB.net--not VBA) that will attempt (among other things) to recognize the format of the source data of a chart and configure the chart's series' number format strings appropriately. That is, yearly data should always be two numbers, monthly data should always be a 3-letter month followed by a 2-digit year, etc. The goal is to have a uniform representation across all charts for monthly data, annual data, daily data, etc. My question is this: how do I find the number format string for the cells (or any cell that is part of that series, as I will be assuming all cells that make up a particular series have the same format) that represent the source data for the chart? Note: I can assume that the chart will always point to a range of cells (not, for example, an array of data).

  Read the article

• MS Access - Keeping track (transacation) of all activity while form is open...

  - by Ron Mac

  Hi and thanks for reading. I am not a database/vba guy and my experience is strictly in the JAVA world. However, I need to have an ACCESS form open. While it is open and new data is entered into it (via the underlying query OR any other data changes in other tables based on sql updates attached to buttons on this form), is there a way that I can initiate a transaction so that at the bottom of the form I could have a button that says "Exit and committ changes" or "Cancel and Rollback changes". I guess I thought of a situation where I could do something like: On Form OPEN, START TRANSACTION On "CLICK OK", COMMIT TRANSACTION or ON "CLICK CANCEL" ROLLBACK. I'm aware how to do the Workspace.BeginTransaction but I'm not sure if that will apply if I do it on FORM OPEN and then on FORM CLOSE do the COMMIT/ROLLBACK locgin? Any insight would be great.

  Read the article

• Where would you start if you were trying to solve this PDF classification problem?

  - by burtonic

  We are crawling and downloading lots of companies' PDFs and trying to pick out the ones that are Annual Reports. Such reports can be downloaded from most companies' investor-relations pages. The PDFs are scanned and the database is populated with, among other things, the: Title Contents (full text) Page count Word count Orientation First line Using this data we are checking for the obvious phrases such as: Annual report Financial statement Quarterly report Interim report Then recording the frequency of these phrases and others. So far we have around 350,000 PDFs to scan and a training set of 4,000 documents that have been manually classified as either a report or not. We are experimenting with a number of different approaches including Bayesian classifiers and weighting the different factors available. We are building the classifier in Ruby. My question is: if you were thinking about this problem, where would you start?

  Read the article

• How often do you use google, to answer programming relatated questions? [closed]

  - by Mercfh

  I hope this isn't too subjective, but it is programming related and Im curious. Alot of times I feel.......dumb for lack of a better word when I have to look something up. Alot of times I forget all the specificity of a language and have to look up something like "Doing XXX in C++" for instance, or something along the lines of that. How often do you guys as Programmers both Professionally and On your own have to use google to look up something. Or do most people just kind of remember these things. I guess what Im really asking is, do you often have to use google or other web-search sites to remember how to do what is seemingly "simple" things with languages but you've just forgotten? Please tell me im not the ONLY one.

  Read the article

• Microsoft met en garde contre l'exploitation de failles de sécurité dans Office et recommande d'effectuer au plus tôt la mise à jour de sécurité

  Microsoft met en garde contre l'exploitation de failles de sécurité dans Office Et recommande d'effectuer au plus tôt la mise à jour de sécurité Microsoft alerte sur une nouvelle vulnérabilité jugée critique dans le traitement de texte Microsoft Office Word. La faille permet l'exécution de code distant si un utilisateur ouvre ou pré-visualise un e-mail contenant des données RTF. L'exploitation de cette faille permet à un pirate d'obtenir les mêmes droits d'utilisateur que l'utilisateur local. La vulnérabilité avait déjà été corrigée dans un bulletin de sécurité (Pacht Tuesday) émis par Microsoft en novembre dernier. Mais une nouvelle exploitation de celle-ci sur internet v...

  Read the article

• Growing MS Access File Size problem

  - by user55886

  I have a large MS Access application with a lot of computations in VBA code. When I run it it eventually crashes due to excessive file size. There are a lot of intermediate tables and queries created and subsequently deleted, but Access does not reclaim the space. I have diligently closed all intermediate record sets and set all temporary objects to nothing, but nothing helps. The only way I can get my code to run is to run part of it, stop and repair/compress the file then restart the code. Isn't there a better way? Thanks

  Read the article

• Ask The Readers: How Do You Find Your Next Game?

  - by Jason Fitzpatrick

  Once upon a time the only place for new video game information was down at the arcade. These days there’s a news source and niche for everyone and every kind of game; where and how do you find your next video game conquest? Word of mouth? App recommendations? Critical reviews? This week we’re interested in lining ourselves up for a little summer fun: tell us all about your tips, tricks, and techniques for finding the real gems in the pile of games that comes out every year. Sound off in the comments and then check back in on Friday for the What You Said roundup. HTG Explains: What Is Two-Factor Authentication and Should I Be Using It? HTG Explains: What Is Windows RT and What Does It Mean To Me? HTG Explains: How Windows 8′s Secure Boot Feature Works & What It Means for Linux

  Read the article

• INstlling ubuntu

  - by Erich

  Am trying to install ubuntu 12.04 on a pentium 4 with a hard disk that's been totally wiped clean. Have made an iso image, burned it on a cd and it has been verified. Checked to see if separate files have been burned on cd and they have. When I boot to the disk I get the word unbuntu with some progress dots, 5 min later it goes to a red screen with the mouse arrow on screen. It has stayed in this condition for over half an hour now. Help? erich

  Read the article

• Ctrl-Alt-T doesn't open terminal

  - by user204591

  I'm using Ubuntu 13.10 and I've been using for a while now as ran it from a daily build about a month ago. It's fully updated with updates, upgrades an dist-upgrades and it was working up until very recently. Not sure exactly when I last issued a Ctrl+Alt+T as I quite often just leave it running however it will have been certainly in the last week. Basically when I hit that key combo I do not get a terminal. I know that each of the keys function as I can Atl+Tab through open applications and I can Ctrl+C to copy and past Ctrl+V to paste and I've typed plenty here that has a "T" in it. I have checked Keyboard Layout in Settings and the correct combo is assigned to the terminal. You'll have to take my word for that as I'm not allowed to post my screenshot!!!!!

  Read the article

• Mass Delete Using Gridview with Checkboxes

  This sample shows how to use a Gridview to delete multiple records all at once, having marked them with a Checkbox, and clicking one button, external to the Gridview, to delete them all As usual, here, we're using the Northwind Database. If you want to try this on your own Northwind database, adhere to this word of caution - "BACK IT UP FIRST". You will be making multiple deletes, so in order to get it back to the original state, you must make a backup and then restore afterwards. Remember too, that you will need to substitute your own Web.Config connectionstring entry for "YourNorthwindString" in the sample code

  Read the article

• Microsoft Office sur iOS et Android : en 2013 ? Oui, non... peut-être

  Microsoft Office pour iPhone et Android Oui, non... peut-être Soyons prudent. Rien n'est encore très clair avec le « Buzz IT » du jour : Microsoft Office débarquerait sur iOS (iPhone, iPad, iPod) et Android dès 2013. L'information vient du site américain The Verge qui tiendrait lui-même le « scoop » de sources internes à Microsoft. D'après ses sources, rien de bien révolutionnaires cependant. Microsoft Office serait disponible sous la forme d'une application gratuite (histoire de ne pas financer des concurrents ?) qui ne permettra que la lecture des fichiers Word, PowerPoint, et Excel. Toujours d'après le site, l'édition des documents ne sera possible qu'avec un compte Offi...

  Read the article

• MS SQL Server Dates Excel

  - by KillerSnail

  I have data this is linked from SQL Server into an excel document. The column format on the SQL Server is datetime2. When I get the data via an ODBC connection it comes across as a string? I tried using CAST(column AS DATE ) but that didn't work. I tried reformatting via CONVERT(VARCHAR(10), column, 103) as well but that didn't work. I tried retrieving the data via Microsoft query as well but that didn't work. At the moment I am using VBA code like: While (ActiveCell.Value <> "") ActiveCell.Value = DATEVALUE(ActiveCell.Value) ActiveCell.Offset(1,0).Activate Wend and looping through each column that needs this treatment but 100000 rows in multiple columns takes forever to loop through. Are there any alternatives?

  Read the article

• Les Office Web Applications officiellement annoncées par Microsoft, la version gratuite en ligne d'O

  Mise à jour du 17/05/10 Les Office Web Applications officiellement annoncées par Microsoft La version gratuite en ligne d'Office 2010 concurrencera les Google Docs Le 15 juin prochain, la version gratuite en ligne de Word, Excel, PowerPoint et OneNote sera disponible pour tous. L'annonce vient d'être faite officiellement par Chris Capossela, cadre chez Microsoft, lors d'un gala à New-York la semaine dernière. Cette date correspond également au lancement de la suite complète en version desktop de Microsoft Office 2010. Pour accéder aux Office Web Apps, il faudra disposer d'un compte Windows Live et accepter la publicité....

  Read the article

• Overview of XSLT

  - by kaleidoscope

  XSLT (Extensible Stylesheet Language Transformations) is a declarative- XMLbased language used for the transformation of XML documents into other XML documents. Using XSLT , the original document does not changed; rather, a new document is created based on the content of an existing one. XSLT is developed by the World Wide Web Consortium (W3C).   Using XSLT we can transform source xml file into another xml file, word file or Excel file.    XSLT Functions : -   There are the following built - in XSLT functions :   Name Description current() Returns the current node document() Used to access the nodes in an external XML document element-available() Tests whether the element specified is supported by the XSLT processor format-number() Converts a number into a string function-available() Tests whether the function specified is supported by the XSLT processor generate-id() Returns a string value that uniquely identifies a specified node key() Returns a node-set using the index specified by an <xsl:key> element system-property() Returns the value of the system properties unparsed-entity-uri() Returns the URI of an unparsed entity   For more information –   http://www.w3schools.com/xsl/default.asp   Technorati Tags: Ritesh, Overview of XSLT

  Read the article

• Are there Any Concerns with Importing Document Files From a Competing Product?

  - by Thunderforge

  I have a new product that serves the same purpose as my competitor's long-standing product. One thing I have considered doing is allowing my program to import document files created by their product in order to provide an easy way for users to migrate towards mine. Naturally, this would be done without the competitor's permission, as it goes against their interests. I've seen this done before with office suite software (e.g. Open Office and Apple Pages can import MS Word documents), but I'm wondering if there are any concerns, legal or ethical, with me doing this. I fully expect any answers will most likely fall under the "I am not a lawyer" clause, but it would be helpful to have a starting point for anything I would need to be aware of, or if I shouldn't need to worry.

  Read the article

• How is this "interface"-like structure/pattern called?

  - by Sebastian Negraszus

  Let's assume we have an XmlDoc class that contains basic functionality for dealing with an XML data structure and saving/loading data to/from a file. Now we have several subclasses, A, B and C. They all inherit from XmlDoc and add component-specific methods for setting and getting lots of data. They are like "interfaces" but also add an implementation for the signatures. Finally, we have an ABCDoc class that joins all the "interfaces" via virtual multiple inheritence and adds some ABCDoc-specific stuff, such as using XMLDoc-methods to set an appropriate doc type. We may also have an ADoc class for only saving A data. How is this pattern called? "Interface" is not really the right word since interfaces usually do not contain an implementation. Bonus points for C++ code conventions.

  Read the article

• Code Camp 2013 Harrisburg PA

  - by raysmithequip

  Originally posted on: http://geekswithblogs.net/raysmithequip/archive/2013/10/15/154349.aspxThe Centrral Pensylvania Dot Net Users Group will be hosting a code camp nov 2 2013.  The Schedule is already on our groups' webpage, http://centralpenn.web121.discountasp.net/home/CodeCamp2013/tabid/109/Default.aspxYou will find the schedule on the pull down tab.  Registration is free, you will have to use Meetup to register.  http://www.meetup.com/Central-Penn-Dot-Net-User-Group/events/141788672/Sign in to Meetup and register to attend Code Camp!! Learning will be plentiful, the giveaways will be COOL!! So you gotta be there!!!In a couple of days I will post the schedule here in an effort to spread the word. ray smith n3twu

  Read the article

• Is Visual Studio Tools for Applications part of Office 2007?

  - by BlackMael

  The VSTO bit I understand. Visual Studio has the project templates to get you started with creating nice .NET based add-ins. But where is VSTA? I installed the SDK but it seems to be gears towards adding extensibility to your own applications. I had thought that VSTA was like the new VBA for Office 2007. Infopath 2007 seems to be VSTA enabled but I cannot seem to find where Excel 2007 is also VSTA enabled. Am I missing something?

  Read the article

• Is there a way to return a response every x seconds or so to a single http request?

  - by luis

  I'm wondering if it's possible to send a response every second or so to a single http request. Like for example the client makes an http request, then the server sends a space character every second. This could be never ending or with a limit, for example a minute. I think the word 'response' is misleading in this context, since I don't necessarily mean an http response. The whole http response could be composed of the space characters, which would mean a single http response to a single http request, except that it is a minute long. I tried chunked encoding but I don't think it works, or at least my implementation's wrong.

  Read the article

• category title and affect on SEO and ranking

  - by Mark

  We are working on a jobs and skills website (similiar to Skill Pages) and are deciding on categories. Rather than having load of categories like, for example, Builder, Electrician, Carpenter etc, we would like to have one word more general categories. So for example we have House, Computer, Education, Art etc. So a builder would be in category Home and a few others. Will this style negatively effect our SEO and ranking? And if so, should we abandon and go back to traditional categories and sub-categories?

  Read the article

• Dynamic Strategy Pattern [migrated]

  - by Karl Barker

  So I'm writing a web service architecture which includes FunctionProvider classes which do the actual processing of requests, and a main Endpoint class which receives and delegates requests to the proper FunctionProvider. I don't know exactly the FunctionProviders available at runtime, so I need to be able to 'register' (if that's the right word) them with my main Endpoint class, and query them to see if they match an incoming request. public class MyFunc implements FunctionProvider{ static { MyEndpoint.register(MyFunc); } public Boolean matchesRequest(Request req){...} public void processRequest(Request req){...} } public class MyEndpoint{ private static ArrayList<FunctionProvider> functions = new ArrayList<FunctionProvider>(); public void register(Class clz){ functions.add(clz); } public void doPost(Request request){ //find the FunctionProvider in functions //matching the request } } I've really not done much reflective Java like this (and the above is likely wrong, but hopefully demonstrates my intentions). What's the nicest way to implement this without getting hacky?

  Read the article

• Improving FAQ SEO with multiple pages?

  - by asdfasdf

  I have a client who has over 200 Question/Answer style content blocks. Neither the questions or answers are very long and most of them have almost the same question but with a word or two differentiating themselves from the rest of the questions. Would SEO be helped or hurt if I would to put each QA on its own page with the title of the page the question being asked etc... Or, would that be considered "farming"? If not, what would be the best way (in SEO world) do present all these QAs? Thanks for any advice..

  Read the article

• Possible to map mouse coordinates to isometric tiles with this coordinate system?

  - by plukich

  I'm trying to implement mouse interaction in a 2d isometric game, but I'm not sure if it's possible given the coordinate system used for tile maps in the game. I've read some helpful articles like this one: How to convert mouse coordinates to isometric indexes? However, this game's coordinate system is "jagged" for lack of a better word, and looks like this: Is it even possible to map mouse coordinates to this successfully, since the y-axis can't be drawn on this tile-map as a straight line? I've thought about doing odd-y-value translations and even-y-value translations with two different matricies, but that only makes sense going from tile-screen.

  Read the article

• Azure, a Beautiful Color, and So Much More...

  - by KKline

  Windows and SQL Azure Resources Cloud computing is more than just the latest buzz word in the IT trade papers. It is a remarkable paradigm shift with as much potential to "turn over the apple cart" of IT computing as client-server had for the world of mainframe and minicomputers. If you're not spending time to learn about cloud computing, in general, and SQL Azure, in particular, then you're missing the boat in a big way. (Ha! Two big metaphors in one afternoon. My high-school English teacher would...(read more)

  Read the article

• Small Business Websites and the Internet High Street

  Most professionals, running their small businesses from high street premises, rightly expend huge amounts of time and effort on finding the right site to trade from; a wealth of consideration is given to every detail of the work place, from the colour of the carpets to the style of chair; professional designers are enlisted and marketing specialist consulted and a great deal of thought is given by all as to just how attractive the place will be to potential customers. With the beautiful new signs in place, all that's left to do is await passing trade, of course other marketing will be done and business also comes from word of mouth, but it is this visual presence on the high street that is all important to such firms.

  Read the article

< Previous Page | 162 163 164 165 166 167 168 169 170 171 172 173  | Next Page >