Archive | Content Editor

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,

How do you create a macro to only refresh certain sheets in an Excel workbook?

Posted on 03 August 2011 by Tony

I have some external references to a Sharepoint list. There are certain sheets that have these connections that must be refreshed on the press of a button.

How can I only refresh certain sheets?! Please help
Can I refresh the sheets one at a time in the command…?

Something like ActiveWorkbook.Refresh.Sheets(“SheetA”) ???

I’m creating a button to refresh specific worksheets and their connections. So it could be multiple lines of code to refresh one worksheet. Please help!

Chosen Answer:

Given that the only available commands are either

activeworkbook.refreshall

or

workbooks(index).refreshall

it seems you can’t directly.

Reading around it looks like you can’t refresh when sheets are protected.

It may be a lot of hassle, but I suppose you could have each sheet linked to a separate workbook and you only refresh those you want to refresh.
by: flyingtiggeruk
on: 5th August 11

Comments (1)

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,

What next after MCSE/MCITP ?

Posted on 06 June 2011 by Spade

Hi…i completed MCITP Enterprise Administrator and CCNA….now im lil bit confused whether to go for a job and get experience first or go for MCITP Exchange Server 2010 or any other related course like sharepoint server etc..i would like to know if exchange server is a good choice for a fresher and if there is any other course that would be more preferable…what next in my networking career???
academic qualifications : I have a bachelors degree in Electronics and communications engineering
thanks mikey…can you provide more details regarding virtualization and thin clients..regarding cert and exams

Chosen Answer:

Get a job. You’ll probably find your existing certs only get you a foot in the door and you won’t actually be using those until you get some experience and seniority – you certainly won’t be trusted on critical infrastructure. In the end industry certs can only you so far. You need academic qualifications and experience to fill in the rest.
by: Andrew S
on: 16th June 11

Comments (2)

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,

I’d like to create a video on my computer?

Posted on 21 April 2011 by Tony

I have several people who work for me out of different locations. Because it’s hard to all get together at the same time on a frequent basis for training purposes, I’d like to create a video on my computer that maybe walks them through the steps of how to do various things. (computer and/or software related). So basically if they open the video they will see my computer screen and (for example) me showing them how to perform a specific function in a software, etc….

Any advice on the best way/software needed to do this? I was thinking that it would be a video i could put on our company sharepoint that they could access at their convenience. It would need to have my voice in the audio explaining whatever it is that is appearing on the video.

I hope that made sense… any recommendations or suggestions are appreciated!!!

Chosen Answer:

by:
on: 1st January 70

Comments (1)

Tags: , , , , ,

The difference between Microsoft Exchange and Microsoft Sharepoint?

Posted on 13 April 2011 by Tony

Chosen Answer:

by:
on: 1st January 70

Comments (1)

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,

Help needed with website mailto: link?

Posted on 08 April 2011 by

I’m using a mailto: link on my website so users can contact me.

However i’ve had 2 people say this week that they’ve emailed me and it hasn’t reached me. I know that one of them is a hotmail user and sent the email through the web browser by copying the shortcut.

Having googled I’ve noticed that hotmail does not like mailto tags very much and i’ve seen many sites showing how individuals how they can make changes to their own settings to remedy this.

What i’m wondering though is, is there a way that I can either have a piece of code that removes the mailto for users who right click to get the shortcut?

Before anyone mentions creating a form so people can just type their message in there, i’m using sharepoint to make my website (not my choice it was forced upon me) and it won’t let you just put regular forms in like you would on a normal site you have to use loads of complicated widgets and i’m not that talented (i’m only just learning how to use it and I don’t want to break it as it’s not my site to break, it’s my employers)

Fingers crossed someone knows an answer to this as it’s frazzling my brain!
Thanks Ron,

That’s exactly the coding I have already. I just wondered if there was a way of somehow removing the mailto: from the link that those who right click for shortcut get and keeping it for those that have a default email program set up.

Chosen Answer:

If they right click to get the shortcut link, that includes the “mailto:” portion and will not work. If the link is correct, then their local email program will open with your email address already in the “To:” field. If they have no local default email program, they need one, but it may open the web mail program they have to log into.

Email Me

Ron
by: Mr. Tacki
on: 14th April 11

Comments (1)

Tags: , , , , , , , , , , , , , ,

Which course will help me to get job in USA or Canada ? Pleas reply me. -sharepoint, silverlight, ms .net, php?

Posted on 31 March 2011 by

Hello friends, I m going o USA ar Canada after 3-4 months. So I have time of 2-3 months and I would like to learn some computer related course. So plz let me know which course will help me to get job in USA or Canada ? Pleas reply me. -sharepoint, silverlight, ms .net, php

Chosen Answer:

by:
on: 1st January 70

Comments (2)

Tags: , , , , , , , , , , , ,

Sharepoint- Has this ever happened to you?

Posted on 23 March 2011 by Tony

1. You need access to an area/document within sharepoint.
2. The one and only administrator is home with a sick kid.

Why does this always happen?

Chosen Answer:

Murphy’s Law
by: G
on: 29th March 11

Comments (1)

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,

Having trouble even getting an interview for a graduate IT job?

Posted on 21 March 2011 by Tony

Ok i lost my job about 3 months ago now under a stupid 90 day rule and the business said they couldn’t afford me. I went to my employment agency afterwards and redid my CV etc. I handed out a few cold CVs to businesses and some of those businesses were really impressed with my CV but had no positions available. Plus a lot of other people have seen my CV and say its great and I even have an IT guy I know act as a mentor and he really likes it.

The big problem is when I apply for an IT graduate job that has advertised I can’t even get an interview. They just say there are candidates better qualified and have more experience. I know they are full of BS when they say that. I have an IT uni degree and 6 months IT work experience applying for jobs that require no experience. My CV is below. Anyone have any ideas why I keep getting turned down at the first step.

CAREER OBJECTIVE
To gain employment with a company or institution that offers me a consistently positive atmosphere to learn new technologies and implement them to add value to the business.
EMPLOYMENT HISTORY

Employer:Vistic Limited
Date:October 2010 – December 2010 (3 month contract)
Title:Software Developer
Description:Vistic Limited is a small IT consultancy business. Vistic uses a diverse range of technologies to meet its customers requirements. My role while I was there was as a .net Developer. Technologies used while there include SQL Server 2008, Visual Studio 2008 and 2010, Sharepoint 2007 and 2010. Operating Systems used include Windows 7, Windows XP via Virtual PC and Windows Server 2008 R2 via Virtual PC.

Projects worked on included making an ASP .NET web application that would be used internally in a business to access data stored in SQL Server 2008.

Sharepoint projects worked on included developing an Approval system for Hardware Requests. Another project involved in developing and maintaining a collection of sites for contractors to enter their daily work records where it awaits approval. Support was provided to the contractors.

Employer:Treefish Ltd.
Date:July 2010 – September 2010
Description:Unpaid IT work experience. Had exposure to Mac OS X and Linux. Mainly providing support for Mac OS X and a small amount of Windows XP.
Employer: McDonalds Courtenay Central, Wellington 
Date: May 2008 – January 2010
Duties:Customer service, cash handling, EFTPOS, food preparation, food safety, inventory control.
EDUCATION
Victoria University of Wellington (2007 – 2010)
 Bachelor of Commerce and Administration 
 (Majors in Information Systems and E- commerce)

 Areas of Information Technology studied:
Information Systems Management
Database Management and Programming
Web Design and Development
Systems Analysis
Telecommunications
Project Management

New Plymouth Boys High School (2002 – 2006)
NCEA Level 1 (Economics, Maths, English, Spanish, Graphics)
NCEA Level 2 (Accounting, Economics, Maths, English, Legal Studies)
NCEA Level 3 (Accounting, Economics, Calculus, Statistics, English)

COMPUTER SKILLS
Operating systems used include:
Windows XP, Vista, 7 and Server 2008 R2.
Mac OS X (Snow Leopard)
Linux (CentOS)

Technologies used:
Sharepoint 2007, 2010 and Sharepoint Designer
Visual Studio 2005, 2008 and 2010
Microsoft Office 2003, 2007 and 2010
SQL Server 2005 and 2008

Programming languages used include:
C#
JavaScript
Perl

Other skills include:
HTML
CSS
SQL
REFERENCES
Available on request.

Chosen Answer:

Employers don’t like to read. Noone likes to read. Not even on applications.
Take all the wording out and “bullet” the points you want to make. Reduce the words.
Change it up so that it’s not all flush on the left.
How is your voice and appearance when you are applying for these positions?
You need to be confident, you have great qualifications!
How are you presenting yourself?
Walk up, hold your hand out, smile, say “hello, my name is _______”
Get a name of the manager or hiring person before you go in to cold call to apply and use his/her name when introducing yourself. Then follow up later in person again.

Get to know the employees when you go in to hand in your resume or application. Leave an impression and remember them. They can be great allies.

Go in person. If they say they aren’t hiring, ask if you can leave the resume with them anyway.So what if they aren’t hiring. Follow up with them until they are. By then you will know that the guy plays golf and his oldest daughter is starting college this year, etc.

Resume help….
change your objective to what you can do for them, not what they can do for you. Your objective is to work for an employer who will consistently do something for you? no,no,no! You want to work for a company who can utilize your talents so that you can contribute to their profit margin or whatever. They don’t want to offer you a positive work environment. You aren’t paying them. They are paying you. What can you do for them? You can say you want to work for an employer where you can contribute to their positive atmosphere, etc but you can’t EXPECT them to do something for you. Why would I hire you if you want something from me? Your objective is to gain employment with a company, etc where you can use your skill or aptitude or whatever. You get the idea.

Don’t write “Employment History” and then “employment”. It’s redundant, just like the date, etc

EMPLOYMENT HISTORY:
Vistic Limited (Caps or bold) October 2010- December 2010
Software Developer
Responsible for .net development
Used various programs such as
SQL Software 2008
Visual Studios 2008 & 2010
Etc.
(It’s ok to keep the sentence that says “Projects worked on…..)
Get rid of what the company does ( is a small cons. business….Vistic uses a diverse range, etc) They don’t care about Vistic, they care about you.

You need help with your resume. It’s your resume and maybe presentation that is hurting. Sorry can’t help more with resume but don’t know what that stuff means.
Good luck and get help with resume. TOO LONG. TOO WORDY.
by: Special K
on: 2nd April 11

Comments (5)

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,

How can I share the editing a a spreadsheet for free?

Posted on 20 March 2011 by Tony

I have a spreadsheet with checklists and a weekly schedule that I and a group of friends want to share as a way to collaborate on a team project. We want to use the checklists to assign and schedule task responsibilities and record things we see and do independently, but we would all like read/write access to it. I know about collaboration tools like MS Sharepoint, but none of us have a web server, and none of us own a domain name and no one wants to spend money if we can avoid it. How can we post an excel spreadsheet somewhere and make it available to each team member for exclusive edit FOR FREE?

Chosen Answer:

Google Spreadsheets. If you have a Google Mail/Gmail Account, go to your email and click on ‘Documents’ on the upper navigation bar. You can make a spreadsheet from there or upload your own and share to your friends.
by: Lily
on: 27th March 11

Comments (1)

Tags: , , , , , , , , , ,

What version of SharePoint do you recommend for E-Commerce Website?

Posted on 12 March 2011 by Tony

Can I save thousands by building it myself?

Chosen Answer:

by:
on: 1st January 70

Comments (1)