Assigning Macros to OpenOffice Events

The end result - a time stamped documentAdding an macro is a very helpful method of expanding the functionality of a Calc spreadsheet or a Writer doc. Naturally, there are several drawbacks to this:the user must recall to run the macrothe user must learn the way to run the macrothe user must wish to run the macro.A far better alternative for everyone will be to get OpenOffice to do all of the hard work itself – and for that macros could be assigned to’s Built-in Occasions

OpenOffice has a lot of built in occasions that could be used to trip any macro; these occasions are:

activate documentclose applicationclose documentcreate documentdeactivate documentdocument is save asdocument has been saveddocument is closing’Modified’ status was changedopen documentprint documentsave documentsave doc asstart applicationSo if, for instance, the user desires the macro to run each time they open the doc subsequently the cause event should be ‘open doc’.

Having determined which is always to function as the cause event then next thing to do will be to generate a macro for this occasion.

A Time Stamp Macro

The entire objective, clearly, will be to run a macro when a certain event happens, in this instance the macro is one that will record:

the present date and timethe date and time the file was last modifiedthe user name of the individual carrying out the modificationSo, the following job to do will be to assemble the macro which will do exactly that.

‘Ensure that variants are defined

Option Explicit

‘Define the beginning the subroutine

Sub set_details

‘Define the variables to be utilized in the subroutine

Dimmed Cell, Sheet, ModDate

‘Pick the initial sheet in the present spreadsheet

Sheet = thisComponent.Sheets(0)

‘Place the word “Date” in cell A1

Cell = Sheet.getCellRangeByName(“A1”)

‘Place the real date in B1

Cell.String = “Date”

Cell = Sheet.getCellRangeByName(“B1”)

Cell.String = Format (Date, “YYYY M D”)

Cell =Sheet.getCellRangeByName(“C1”)

Cell.String = “Time”

‘Put the time in D1

Cell = Sheet.getCellRangeByName(“D1”)

Cell.String = Time

‘Now add the present user name

Cell = Sheet.getCellRangeByName(“A2”)

Cell.String = “Updated by”

Cell = Sheet.getCellRangeByName(“B2”)

Cell.String = environ (“USER”)

‘Ultimately add the last modified date

‘If the the file is new subsequently use the creation date

if isObject ( thisComponent.DocumentInfo.ModifyDate) then

ModDate = thisComponent.DocumentInfo.ModifyDate


ModDate = thisComponent.DocumentInfo.CreationDate

ending if

Cell = Sheet.getCellRangeByName(“A3”)

Cell.String = “Last updated”

Cell = Sheet.getCellRangeByName(“B3”)

Cell.String = ModDate.Year & “-” & ModDate.Month & “-” & ModDate.Day

‘And ending the subroutine

End Sub

If a user runs this macro manually (after opening a spreadsheet) Afterward the result in the spreadsheet would be something like:


Updated by______|bainm____|_____|

Last Upgrade Date| 2008-7%278-7-27| Time| 16:26

Assigning a Macro to an Event

Writing (and, of course, testing) the macro is really the most complex part of the procedure. The next (and simplest) step would be to assign the macro to an an occasion; to do this the consumer must:

click on Toolsclick on Customizeclick on the Occasions tabselect the needed occasion (e.g. Open Document)click on Macroselect the mandatory macroAnd then, the next time that the user opens the document the macro will run automatically.

Read More

Defining Data Types in Programming


Data types are crucial to any computer programming language. Without them, it becomes very hard to keep information in a computer program. Because the main principle behind computer programming will be to require advice, process it, and produce the info in an alternate type to the consumer, data types clearly play a sizable part in discovering how this is attained.

Different languages have various constraints upon the data types they give. In this informative article we shall recognize across languages where applicable, but you’ll have to cross check with all the instruction manual for the particular language that you’re employing to determine some facets.

Before we start, we must also note that a few languages are strongly typed, which means the data type of an item of info needs to be declared before that variant (or slot) could be utilized.

Languages usually permit the chance to project (convert) between compatible types.


in many languages, numbers are either integers or floating points.

The bigger the range of numbers having to be signified, the bigger the (repaired) data storage condition will probably be. Afterwards, and since memory and also other storage has traditionally been limited, computer programming languages provide distinct sizes of numbers:

Short : Little integer rangesLong : Large integer rangesFloat : Modest floating point rangesDouble : Big floating point ranges

The names may change (Modula 2 uses REAL, INTEGER and LONGREAL, LONGINT for example), but the general principles stay exactly the same.

Support for complex numbers (with a real and imaginary part) isn’t necessarily ensured, and matrix computations will often need to be performed manually (programmatically).

Characters & Strings

A character value is generally one byte of ASCII, but other character sets (EBCDIC, for instance) may alter this.

Where the string type can be acquired, it will normally be an abstract data type (or category) which conceals the internals in the programmer (encapsulation), and have to be controlled utilizing the open functions (methods) for doing so.


A pointer is a reference to some bit of memory, whether that be ‘raw’ memory, or formatted according to some other data type, or a bit of executable code, like a function (procedure, method…).

Pointers may be used to store arrays (like strings of characters), or as a reference to s static single value. Attention must be taken when using pointers, as they can possess some unexpected properties under particular conditions.


The preceding is intended as an opening to the most ordinary data types that the computer programming job will entail. It’s not the conclusion of the storyline, along with the General Programming Index will point to other relevant matters.

Navigation Links

Back to the General Programming Index

Read More

Thomas T’s Articles – Article Dashboard Directory | Submit Articles | Search Find Free Content

Thomas T’s Posts

Secrets To Dog Training Review

All dog lovers need what’s better for his or her dog, correct? Certainly they do. Do they consistently pursue what’s better for his or her dog? Not constantly. Not because they dont need also but because they dont believe they are able to afford also. Which is clear. That is the reason why the Secrets To Dog Training offer is really unique.SEM Company Pattern Review

SEM Company Pattern is a brand new product recently released by the expert of online marketing, Tim and Steve. Their new merchandise elaborates the significant and vital problem of internet search engine marketing for companies online.SEOLinkVine Review – SEO Link Building Service

The race is on to get a internet site to come across its manner in addition to the website positioning. In the end, it’s many edges being there, right? You’ve added visitors and an elevated internet visitors that will translate into potential customers and better sales. Shoemoney System Review

These days, the Shoemoney System had been more and very popular. Since individuals are into something wherein they might get considerably of funds, they decide to opt for the net. This really is because of the truth that free cash might be readily got. Therefore, if you’re truly one of these people, you may be thinking about on the way you may use up the Shoemoney System.Shokz Starcraft 2 Strategy Guide Review

For quite a number of online games a strategy guide can come in helpful. But it actually is even definitely better when you may get life updates, including expansions also. Easy PHP Review

when you have sat down at your personal computer and read info on PHP you might have now been left together with the feeling that you’re not really sure everything you read. Singorama Review

Everyone can sing. Not everybody can sing nicely. That will not halt individuals from attempting to sing. They dont understand how exactly to get the most from their voice. They fight to seem just like a professional but minus the training. It’s likely to sing better with training and practiceSix Figure Annual Review

It doesnt feel really great without any cash. Six Figure Annually is the remedy. It’s a safe and proved means of making a lot of money in a quick time. Skin Lightening Report Review

Dark irregular discolored spots appear on hands, arms, legs, feet and yet the face. Over the counter treatments are frequently the armory used to test and conquer the dreaded age spot, freckles, or around pigmentation. Luckily a individuals armory is just not restricted to pricey over the counter skin lighteners. Snowboard Addiction Review

In Case you’re a person that adores the winter months and also the sports that can come together with it than you’re likely to adore Snowboard Addiction. For someone that will not possess the cash to pay on your own trainer this is actually the program that can coach you on all in regards to the sport in the seclusion of your dwelling. This way when you hit the snow you’ll seem like you’ve been achieving this for quite a long time , not get a individual which does not have any notion of the things they’re doing. Socrates Theme Review

Among The very useful tools for online marketing is websites. It helps it be easier and more inclined to reach individuals truly interested in a service or product. Sites really are a great marketing tool. Nevertheless the sites need to be marketed as well. Socrates WordPress Theme Review

1 of the considerably more well known means to create cash on line is as a blogger. This is often a extremely rapid method of advertise affiliate advertisements, Clickbank, Adsense or some other kind of marketing. They appreciate composing or discussing their views so that they start blogging. Afterward the realization that one can discover options for making resources from websites hits. They commence adding advertisements, banner ads along with other types of promotion and advertisements to their own weblog. Applications Submitter Pro Review

The net gives an excellent chance for riches and success provided that you might have traffic. All of us realize the important thing is getting visitors to your own web site which has guarantee of buying your products. Without this you’re not ever going to allow it to be huge on the web regardless of everything you do. Sonic Producer Review – Beat Making Applications

Making amazing music brings overly a lot joy to folks. In as far as the producer is worried, it is a fire but to the listener, it is pure joy to have the capability to understand a thing that’s actually a work of art. Regrettably, not numerous men can chase their visions of being a music producer because of the very fact of the investment that it will entail. SpyBubble Review – Mobile Spy

Technology is fast-evolving assembly the desires of women and men. Programs, applications and applications are constantly upgraded, altered and devised so you can make dilemmas less problematic for humankind. Steal Pips Review

We all understand how fantastic trading might be specially when you’ll be able to take action in the comfort of your house on the web. Maybe you’ve bought a robot to assist you with all the commerce marketplace or maybe you might have tried an alternate sort of software. Regardless of that which you’ve attempted, you’ve probably already detected your cash still appears to arrive at a standstill as well as in some instances you could even lose money. Stock Assault 2.0 Review

Make thousands of dollars on the stock market using a tremendously successful tool, Stock Assault 2.0. This artificial intelligence based applications will signal what stock to get together with when to purchase it and sell it. With this specific software there is absolutely no demand to learn how you can assess the marketplace or have day trading expertise to achieve success. It does all the job. Stock Assault 2.0 does this so successfully that anyone can take a little investment, build it up, and eventually make a living off the stock marketStop Snoring Exercise Plan Review

The Stop Snoring application will educate you several simple exercises to reinforce the muscles in your breathing passageways and prevent you from snoring while you sleep. These techniques are just physical, and also don’t include any drugs or breathing strips. Quit Sweating And Start Living Review

Should you suffer with excessive perspiration, you realize your life is totally controlled by your runaway sweat glands. People who sweat profusely endure not only in the distress of continuous wetness but additionally in the stigma of being sweaty. You may have tried many strategies to decrease the quantity you sweat. Most endures of overactive sweat glands have tried every deodorant accessible and most have even attempted prescription deodorants to no avail.Stop The Ringing Review

For those who suffer from Tinnitus than you have likely been to the physician again and again to have your ears checked and also to try and discover a method to prevent the ring in your ears. Of course your physician has most probably told you that there’s no remedy for your own trouble and you will have to live on drug for the remainder of your life. Stream Direct Review

Do you consistently spend you free time viewing films? Well, if this is actually true, you need to save some dollars every time you want to view films on the big screen. Actually, it’s quite unpractical. Stream Direct TV Review

Would you love to save yourself from your high cost ranges of the cable television? There’s obviously a good method wherein you can absolutely see the whole television channels which you favor even without paying another monthly invoice. This could be the very best time that you just begin contemplating seeing television right in your personal computer. In case you believe that this matter is somewhat hopeless, you need to presume a whole lot better. Stream Online Movies Review

Now days we appear to work with our computers for more than simply work. But, to be able to view films is yet another perk and bonus that individuals currently possess the capability to have the capacity to do. With all the Stream On-Line Pictures applications you’ll be able enough to select from tens of thousands of films, television shows not to mention sports events for the die hard sports fan. Street Fighting Uncaged Review

Whether you are aware of it or not you will find things you certainly can do as a means to defend your self regardless of where you’re. It doesn’t matter if you’re alone or using a bunch of people because of the fact that you could be about to comprehend the secrets of Street Fighting Uncaged. This may function as the knowledge which you need as an easy way to keep you safe and sound regardless with all the time or the region which you’re in. Ignorant Straightforward System Review

I fairly thing the Ignorant Simple System, the brainchild of KK Maybel, is aptly named from what I’ve observed to date. Stupidly Simple SEO Review

Is net the location in which you work on? Well, you may be wondering how you can make your webpage to be in the number one when it comes to standing in the various search engines. Actually, there are plenty of stuff you can get into to make this occur. Among those is by requiring the aid of Stupidly Simple Search Engine Optimization guide. Subliminal MP3s Review

Over the years individuals have invested a great deal of time plus money to enhance their lives. It may take a great deal of time to make even a bit advancement. Routines of thought and customs are difficult to break. Super Affiliate Handbook Review

The Super Affiliate Handbook is a quite well appointed hand book, written for individuals who want to become successful affiliate marketers. Survey Scout Review

The monetary difficulties got to you personally? Is it more and more challenging to get a good amount of money? For a number of us it’s. Its more difficult and more difficult to receive the cash that you need. Nevertheless, there’s something you perhaps never believed it’ll bring you actual dollars. That’s expressing your view. Survey Scout is just not really the business paying you.Surveys4Checks Review

Surveys are just one of the very important tools for most promotion applications. Surveys4Checks will coach you on how you can make the most of the truth that lots of the biggest corporations on the planet are prepared to pay top dollar for consumer views. This system shows you the way to streamline the survey choosing procedure so that you’re making twice as much cash from taking fewer surveys.&laquo[4][5][6][7][8][9][10][11][12][13]

Join Our Community

Post Dash Writers

Website Advice

Read More


What’s Search Engine Optimization?

SEO is Seo. It’s a method to market a site online.

To produce a site rank in the very top of Google SERP is referred to as on-line promotion of web site.

Why would you want Search Engine Optimization?

Imagine you might have a store in which you sell pizza in Tampa Bay, Florida and you’ve got a home delivery system. Should you search together with the term Pizza shop in Tampa Bay you’ll see there are around seven lacs of results. Visitor wont seek that variety of results to locate you.

Then what is the choice? The clear answer is Search Engine Optimization.

What’s the time period to get your website ranked in the very top of Google?

Search Engine Optimization is just not a rocket science. Your website WOn’t get gains of Search Engine Optimization promptly. It really is a time taken procedure. Demanding and constant procedure for Search Engine Optimization for a significant great amount of time can help you website to perform better in Google search results.

What would be the techniques of Search Engine Optimization?

SEO has just one legitimate technique. It’s White hat Search Engine Optimization.

What would be the negative effects of Search Engine Optimization?

Occasionally a company owner is in haste to get their website rated in Internet Search Engines Like Google. But finally Google penalizes these websites or prohibit them.

What will be the forms of Search Engine Optimization?

There are just two forms of Search Engine Optimization.

On-page SEO means – The approach found in the body of the site. Content plays the most crucial part. It ought to be well composed and unique to the subject of the site. Duplicate content does not have any worth in Search Engine Optimization.

Off-page SEO means The system by which you get backlinks for site from other topic associated and real websites, web directories and websites. Blogging is an efficient strategy along with client blogging.

What Google thinks of the Search Engine Optimization of a web site?

Google desires every website should be unique with unique content and backlinks. Google has created two algorithms for Search Engine Optimization of every site. They’re Panda and Penguin upgrades. Content of a website should follow the Panda upgrade because Google is extremely severe on content. Through penguin upgrade Google checks if website is getting right backlinks from genuine ones or spammy ones.

Where Search Engine Optimization is supplied?

If you cant do Search Engine Optimization yourself, hire a adept Seo Business to advertise your site.

Author’s Bio:

Barry Davis is an Search Engine Optimization and social networking specialist loves to write about Search Engine Optimization. He loves to play with net and is connected with

Read More

Online Sales and Marketing Strategy

A great on-line sales and marketing strategy starts having an armed understanding of the advertising basics, the merchandise itself and clever, innovative preparation.

Sales and Marketing Basics

Before beginning a marketing campaign, its important to be conscious of the 4Ps of marketing: product, price, positioning and promotion. A weak point in one single place can reduce likelihood of succeeding, together with the merchandise acting as the basis for the remainder of the marketing mix.

Thus given which you have a great product plus a cost that clients will willingly pay, here really are a couple of helpful suggestions and strategies on positioning and promotion to help grow sales.

Online Positioning Strategy

Positioning is the place where the merchandise might be bought and how accessible it’s. This consists of the following:

Online Store. Your online store must be enticing and fit your brand image and design. Website. Afterward link that merchandise to the thing and shopping cart so when they’re interested, they’re able to instantly buy without needing to work additional to locate the thing. A business site can be helpful to hold competitions and giveaways for readers, which creates quite high interest. Search Engines. Get yourself found on internet search engines like google. In case you dont understand about internet search engine optimization (SEO), it could be worthwhile to employ a Search Engine Optimization specialist to get your site rated naturally on the very first page of search engines. It is a fantastic long term marketing strategy that’s worth executing. On-Line Promotion Strategy

Promotion differs from positioning. It copes with publicizing, getting and convincing the general public to purchase your merchandise by talking for their requirements and desires.

Google Adwords / Facebook Advertisements. And as another alternative, consider using Facebook advertisements to immediately add fans for your Facbook page. They might not readily convert into sales, but nevertheless, it can be quite a great investment for the future. Newsletter. Make a area on your own homepage that enables people to sign up and subscribe to your newsletter. But don’t bombard them with e-mails or they might get annoyed and unsubscribe. Social media. Take advantage of these systems to participate buffs and get questions in a great and casual tone in place of professional. In case your web site has interesting posts, bookmark them on websites like,,, together with and, in case your products are appropriate. Make sure to incorporate social networking widgets on your own site. Traditional media. In case your target audience adores reading a particular site, paper or magazine, purchase advertising space on their respective websites. Determined by the websites traffic, the expenses may change. Its also worth it to run surveys with Facebook enthusiasts, haphazard focus groups and request views round work.


“International Marketing”; Philip Cateora and John Graham; 2005. The Marketing Mix

Read More

What Is The Rationale Behind The Preference Given To PHP Development?

PHP development has extremely changes over last couple of years. Previously these company program necessitated ton of expense with regard to both time plus money. Even though all these company programs are strong they nonetheless entail big licensing fees, authentic program, and highly developed hardware to get generated together with worked in the right style. Additionally they call for perfect care to be able to work in the high degree. Nevertheless, the customized PHP development has set all of it in a single package to ensure that both time and money may be saved. Now little company houses usually do not need to pay big amounts of cash on individual web application development plus in addition they get results that are only beyond their believing.

PHP Development is really a totally loaded also as dynamic service which any one would prefer to have for the point of the site development. This really propels the visitors to possess close look to their own site and in so doing expand their company. Its development service comprises the services states beneath.

PHP programming

PHP e commerce alternative

PHP program development

PHP Zend development

Cake PHP Devlopment

Custom PHP program development

PHP web application development

PHP is really a massive platform with the objective of site development in addition to program development. Nowadays, it’s rapidly budding programming language source made for web development which could take your organization to the top in the industry. It’s the medium and small size company proprietors who’ve been helped exceptionally owing to recent growth in the world of custom PHP development. A massive number of customized PHP web development alternatives can be found to the customers nowadays and that additionally in less time intensive in addition to cost effective manner.

Author’s Bio:

Writer is an associate editor for PHP Development. Get all inclusive details about PHP Framework Development.

Read More

Grace’s Articles – Article Dashboard Directory | Submit Articles | Search Find Free Content

Grace’s Articles

searching for a web design Sydney company – turn to Sigma Infotech of Sydney

The design of your site shouldn’t only stick out but it should likewise be an expansion of your organization and allow you to in branding. The organization admits that each business is unique and hence has distinguishing technical and business conditions. And consequently, no two options could function as the same. Value of web design and part of the designer

A great site designers should improve his skills and means to identify exactly what the visitors need in a quick speed. Hire the very best site developer business in Sydney Australia

And here is another reason which makes this site programmer business so particular. The organization admits that each business is unique and consequently has distinguishing technical and business conditions.A Amazing website design for business rise

The web site is much more than simply setting a number of pretty pictures and decorating the page in order that it appeals to the visitor. You will find several other relevant problems that have to be addressed.Web existence is currently critical and affordable web design businesses ease the ideal way out

Web Design includes procedures like conceptualization of a unique company wants, planning the internet based alternative, modeling, and ultimately performance of the site designing procedure with all the function of acceptable interpretation of advice. Web designers know of several net technological facets and graphical user interfaces.

To Get a viewer the eCommerce web design and ordinary website design may appear same because the two of them follow the exact same principles of website design which is attractiveness, orderly organisation of components, right colour palette to enhance site spirit. Planning for Dinner suits with first Date

Tailor made suits are very important clothes pieces to get a businessman especially while existence in company meetings as well as other business occasions. Therefore, Dinner suits have grown to be an important thing to get a businessman. Interactional on-line presence to improve gains

The site designers have to consistently enrich their abilities together with the shifting technologies. The web site designers have discreetly made these alterations with all the utilization of the newest internet based technologies. Website design – Identify your intended audience

web designer should wait to analyse the benefits and drawbacks of unique web site design initiative. It doesn’t matter what type of site a site designer pictures but they could ascertain their audience. So its very important to design a site which communicates with all the beginners.Web design myths

Flash banner ads can function their desirable function provided that they may be used efficiently and sparingly. Flash banner ads can be readily downloaded only if you’re connected to high speed connection.Web development: Relevance of Content design in web development

Quality content determines the success of the webpage or web application. Relevance of CSS in web development

Web developers like to work with CSS because it enables them to place their component where ever they desire in the web site. If during any period of web development the programmer believes that special links or columns aren’t going well with all the scenario then it becomes simpler for them to place them readily using CSS.Locating a creative site designer

Before you place-out to locate a affordable web designer, it’s important that you just get the preliminary specification of your site done. Think about the picture and branding you need to show for the company via your website design. Things to Think About when obtaining a Website

Most of the hosting providers offer various rates of hosting. These amounts determine the total amount of disk space, network traffic, email address you get to your hosting.[1][2][3]

Join Our Community

Article Dashboard Authors

Site Information

Read More

Vikram Kumar’s Articles in Web Design – Article Dashboard Directory | Submit Articles | Search Find Free Content

Vikram Kumar’s Articles in Web Design

Reveal All| Exhibit Type| Title| Hottest| OldestGet treatment for many site related issues with Thomasgarciastudio Albuquerque web site Design Business

It’s totally incontrovertible that site design isn’t a small-scale notion. There is an assortment of matters that you must understand in advance. Thomasgarciastudio to offer greatest Albuquerque web page design

Are you not fulfilled by the performance of your company? Would you actually want to get great customers for the organization? Get finest internet options from Thomasgarciastudio Albuquerque web site Design Business:

Should you talk regarding the site design and site hosting, then many things come into your brain. Get good looking and readily reachable site through Thomasgarciastudio Web Design Albuquerque

A company site which has accessible, attractive and creative layout with amazing appealing attributes might allow you to address the consumers from throughout the world. See Thomasgarciastudio for Albuquerque website design and web hosting Albuquerque

For turning your fantasy of getting a large business into reality there are many items which you ought to consider in advance. Make your fantasy site with all the help of New Mexico Web Design

In the entire world of IT, you’ll be able to observe the allure of its own utility everywhere. Thomasgarciastudio Website Hosting New Mexico is a whole solution for site

Nowadays, tons of IT businesses are offered in the marketplace that will allow you to develop your site. Nonetheless, it’s not certain whether it’s likely to solve your objective. New Mexico Web Design : thomasgarciastudio that offers finest web design in New Mexico

It’s true that sites play a critical function in the accomplishment of any firm. The edge that the firm can get from a finest web site is crucial.Web page design in New Mexico: thomasgarciastudio the greatest New Mexico web page design firm

There are many web page design businesses in the marketplace which promise to supply best web page design on your web site.Web site design in New Mexico: Thomasgarciastudio, the very best New Mexico Web site Design Business

Are you not content together with your organization? Do you need a tool through which you may give desirable heights to your own company? Thomasgarciastudio: offers finest website design in New Mexico

There are lots of items which are thought to be quite essential for the successful running of the firm. Rodney Web Design: Offering Webpage Design for Companies along with Website Design Services

Now, businesses are left behind if they would not have web sites. Rodney Web Design: Rendering Services in Website Design and Webpage Design for Businesses

Companies are running after the professional services of web designers simply because they’ve seen the significance of being exposed via the net.[1][2][3]

Join Our Community

Sign Up for an account orlearn more.

Post Dash Authors

Submit Posts

Member Login

Submission Guidelines

Post RSS Feeds

Site Information

About Us

Link to Us

Contact Us

Privacy Policy

Terms of Service

Favicon Generator

Read More