I adore the photos Julie posted of her home today. I have posted a couple of photos above but you must visit Julie's blog, Shelter to see more!! It is stunning!
Showing posts with label Office. Show all posts
Showing posts with label Office. Show all posts
Today I Love...
I adore the photos Julie posted of her home today. I have posted a couple of photos above but you must visit Julie's blog, Shelter to see more!! It is stunning!
How to easily convert .ppsx file to .pptx or .ppt?
Well, a .ppsx file is a Power Point Show file created in Microsoft Office 2007 or later. Today at office I received one such file and double clicking it launches the Powerpoint Viewer and Not on PowerPoint. This maybe needed if you want to edit a few slides or copy some information from the slides.I searched online for quite sometime with no luck. For the earlier .pps files, they can be easily converted to .ppt file by merely renaming the file extension to .ppt from .pps. But this technique doesnot work with the new versions - so a mere renaming of a .ppsx file to .pptx throws up an error when you try to open the file.
Then an idea struck me and it worked beautifully.- Open Microsoft PowerPoint.
- Click on the Ribbon and Open.
- Now select and open the .ppsx file.
Related Articles :
Microsoft Office 2010 Beta 2 Leaked (Build version 14.0.4514.1007 ) with the Keys
Yes, the much anticipated Microsoft Office 2010 suite has already been leaked on many peer-to-peer(torrent) file sharing websites/networks. This is the Beta 2 release featuring a Build version 14.0.4514.1007.The build which has been leaked last week is said to install with the Office 2010 Technical Preview keys and no new keys are needed. So the keys are available here.
Here are some very exclusive screen shots running the Microsoft Office 2010 on my Win 7 RC 1 as you can very well see the UI has been polished and so also the program icons. The public beta is expected to be out by early next week.
Office 2010 runs on Windows XP SP3, Windows Vista and of course the brand new Windows 7.
Here are the exclusive Screenshots of Office 2010 Beta 2 (Build version 14.0.4514.1007)
Simple tips to get the most out of your Online Meetings
Online meetings are inarguably the most price-less tool for saving people's time and money in a very aggressive and competitive business environments that we see today. But did you know that most online meetings tend to have a sour experience in the host as well as the presenter's minds mainly due to poor training or unpreparedness of both - either the presenter or the host.So here are some very simple and most effective methods to achieve the most of Online Meetings:
1. Always make sure that the Online Meeting is short and to the point - crisp. Always make sure that No online meeting ever exceeds more than an hour or in some cases even thirty minutes.
2. Always make sure that you have already prepared a slip containing the list of all probable questions that you will ask those attending the online meeting. Always remember that asking questions helps you retain everyone’s attention.
3. Before you start off - remember to inform the other participants to keep their questions to the end of the online meetings. There should be a very high probability that you will answer most of the questions that the audience thought off during your regular presentation.
4. Mail out the attendees well in advance to install and test the online web meeting software ahead of the schedule. Also, they can check the audio setup and the microphone setup too.
5. It is important in a web meeting that you have a very optimized copy of the PowerPoint slides such that the .ppt / .pptx file is less than 2 MB in size. This greatly helps the attendees not to experience a time lag as you flip through the slides.
Hope these tips helped you. Do share your tips/experiences on online Meetings too.
How to easily open an encrypted / password protected PDF document
To remove all the DRM restrictions or the password of the protected PDF document you will need to just forward the PDF file as an attachment to your Gmail account and then simply open them in HTML mode from within your Gmail Inbox – now isn’t that so very simple to remove the PDF restrictions and password protection.
I have previously written macros to remove password protection from excel files – but never this easy to remove a password protection. But you have a few trade-offs in that the formatting of the PDF file is lost to a great extend but you get all the content that’s inside.
UnPacking the HP Officejet Pro 8500 Wireless All-in-One Printer
I received the unit to do my very own hands on assessment on how this printer performs and also answer the burning question “Is an Office Inkjet better than a Laser?”. I will be sharing with you folks a series of reviews over the coming weeks on each of it’s vast features. But even before that, I would like to clearly state that all my reviews on this product are entirely my OWN and are in NO way influenced by HP or it’s partners.
Having said that, lets begin unpacking the unit. I have created a small video of the entire unpacking exercise. Have a look at it below.
Some of the brief specs about the HP Officejet Pro 8500 are:
- Print capability of A4 duplex colour prints using inkjet features.
- High resolution 4800 x 2400ppi scanner.
- Integrated plain paper Fax.
- Print DPI quality of an amazing 4,800 x 2,400 dpi.
- Supports Wireless operation using WiFi.
- USB 2.0 connectivity.
- Computer-less copy/print operation both in B/W and color.
- Supports direct use of multiple data cards like SD, MMC, etc.
- Supports PictBridge operations.
- Sports a very large 250-sheet paper tray.
During the coming days I will be posting on how I set up the printer and how well it performs in my SOHO (Small Office Home Office) setup. Stay tuned.
Complete List of Free Online Free PDF to Word Convertors
Many a times you may want to convert a document that you have in Adobe pdf format to a much simpler format like Word or RTF or plain text. Previously you had to install some software's on your machine and then run the converter and the software's used to be filled with Trojans and viruses. But, now you have a new breed of Online PDF to Word converters and here is the list of all the services:- www.pdfonline.com/pdf2word/
- www.freepdfconvert.com/convert_pdf_to_source.asp
- www.pdftoword.com
- www.zamzar.com
- www.freepdftoword.org/index.htm
Most of these online services allow you to upload the pdf file and then give your mail ID to which the converted word file will be mailed after the successful conversion.
The last website on the list has a different approach, it has a series of online wizard screens (6 of them) and you choose whether you need the images to be embedded or footer to be included , etc and finally you will need to mail the pdf with the settings to a specified mail Id.
The last website on the list has a different approach, it has a series of online wizard screens (6 of them) and you choose whether you need the images to be embedded or footer to be included , etc and finally you will need to mail the pdf with the settings to a specified mail Id.
Leaked Exclusive Screenshots of Microsoft Office 2010
Office 2010 will be the next major release of Microsoft Office after the current Office 2007 and I just got access to some leaked screenshots of the new office environment!! Here it is for all of you to have a look at it too.There are some very cool features and also as it loads up - it tells us what it is loading, something like you have been having for ages on Photoshop.
There is a new option now to recolour the images you want to right from inside Word!!
There is even a much more cooler option to take screenshots from inside Word!! guess Microsoft will give SnagIt a run for money now.
How to save a document in PDF or XPS format easily in Office 2007 (Word or Excel or PowerPoint)
Did you know that you can easily save and edit your Word or Excel or PowerPoint files to PDF or XPS (the new pdf format used by Microsoft) format. All you need to do is download a small software patch from the Microsoft Website which allows you to easily save any Office 2007 document in PDF format.
Once you install the small patch, you will start getting a new option in the SAVE to save it in PDF or XPS format. This is particularly useful for officials who would like to circulate an important document or a circular among colleagues, but would not like the colleagues to edit or modify the contents.
I was using a few free PDF printer but that just had too many limitations, like the outputted PDF file was non searchable by any search engine (or desktop search) as the contents were encrypted and also, the PDF files generated cannot be edited later using Adobe Acrobat Professional.
How to fix the issue of copy/paste from Print Screen - the image appears in Black and White
I had this unusual problem today in one of my office systems, whenever I do a PRINT SCREEN or ALT+PRINT SCREEN and Copy/Paste into MS Paint or Word - I was getting a Black and White Image. This was very weird, since always a colour image would appear. I tried many ways to fix by pasting into other programs like wordpad, etc. But, using a screen capture program like SnagIt got a colour image of the screen. This left me puzzled.
Finally, I figured out that the system was running very very low on physical memory and also many Windows updates were installed but the machine was never re-started. So the trick was to re-start the machine and lo - it brought colour to the images!! How weird can computer problems be at times.
How to easily Unprotect/Remove Password from a Protected Excel Worksheet
You may already know how easy it is to protect Microsoft Office Excel worksheets and workbooks from unauthorized changes with the help of a password. But, what to do if you can’t remember the password you used for protecting OR you downloaded an excel from the internet and would like to have a look at the formula's or the embeded information - but all that data might be inaccessible due to the password protection.I have a very simple method by which you can easily recover the password and also un-protect the worksheet or workbook. Please note : this method will only remove the protection from the excel file and not the password used to open the excel file itself.
Open the excel file which is password protected and goto Macro's (I am using Office 2007 so the menu's maybe different View >> Macros). Click on "Record Macro >> OK" and then click on "Stop Recording" from the same menu. Now goto "View Macros", you will find a Macro with a default name E.g. Macro1 - Select the macro name and click on Edit. Now a Visual Basic Editor opens up. Re-place the default code and Paste the below code.
Sub Macro1()
'
' Breaks worksheet and workbook structure passwords. Jason S
' probably originator of base code algorithm modified for coverage
' of workbook structure / windows passwords and for multiple passwords
' Jason S http://jsbi.blogspot.com
' Reveals hashed passwords NOT original passwords
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & "Adapted from Bob McCormick base code by" & "Jason S http://jsbi.blogspot.com"
Const HEADER As String = "AllInternalPasswords User Message"
Const VERSION As String = DBLSPACE & "Version 1.0 8 Sep 2008"
Const REPBACK As String = DBLSPACE & "Please report failure to jasonblr@gmail.com "
Const ALLCLEAR As String = DBLSPACE & "The workbook should be cleared"
Const MSGNOPWORDS1 As String = "There were no passwords on " & AUTHORS & VERSION
Const MSGNOPWORDS2 As String = "There was no protection to " & "workbook structure or windows." & DBLSPACE
Const MSGTAKETIME As String = "After pressing OK button this " & "will take some time." & DBLSPACE & "Amount of time " & "depends on how many different passwords, the "
Const MSGPWORDFOUND1 As String = "You had a Worksheet " & "Structure or Windows Password set." & DBLSPACE & "The password found was: " & DBLSPACE & "$$" & DBLSPACE & "Note it down for potential future use in other workbooks by " & "the same person who set this password." & DBLSPACE & "Now to check and clear other passwords." & AUTHORS & VERSION
Const MSGPWORDFOUND2 As String = "You had a Worksheet " & "password set." & DBLSPACE & "The password found was: " & DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & "future use in other workbooks by same person who " & "set this password." & DBLSPACE & "Now to check and clear " & "other passwords." & AUTHORS & VERSION
Const MSGONLYONE As String = "Only structure / windows " & "protected with the password that was just found." & ALLCLEAR & AUTHORS & VERSION & REPBACK
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean
Application.ScreenUpdating = False
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADER
If Not WinTag Then
MsgBox MSGNOPWORDS2, vbInformation, HEADER
Else
On Error Resume Next
Do 'dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
With ActiveWorkbook
.Unprotect Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If .ProtectStructure = False And .ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND1, "$$", PWord1), vbInformation, HEADER
Exit Do 'Bypass all for...nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If ShTag Then
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do 'Dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
.Unprotect Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND2, "$$", PWord1), vbInformation, HEADER
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do 'Bypass all for...nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
End If
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
'
End Sub
Finally, run the Macro(View >> Macros >> View Macros >> Run). You will get the password of the protected workbook and worksheet in Excel. I have tested the above in Microsoft Office Excel XP / 2003 / 2007
Adobe Finally enters the Online Application Market
Though a bit late - but Adobe seems to be in a state of "Better Late than Never" and has rolled out an online website at Acrobat. This website basically allows you to convert pdf and even store them online.The other features are as listed below:
- Buzzword: Well, it's Adobe's version of the online word processor same like Google Docs or Zoho.
- ConnectNow: It's a very cool web conferencing tool that lets you share your desktop with others, chat, talk over a VoIP connection, or share files and mark up whiteboards.
- Share: You can share files with other users using this feature. Adobe Share lets you send files to a list of contacts, and lets the recipients view PDF image, and video files online.
- Create PDF: Seriously, do I need to tell you what this does?
- My Files: Lets you Store and organize up to 5GB of files online.
How to easily Set a Reminder to reply to a message in Outlook?
- [Outlook 2003 users]
Right-click the message you want to set the reminder for, point to Follow Up, and then click Add Reminder. In the Due By list, click the date when you have to complete the reply. In the second list, click a time. In the Flag color list, click the flag color you want, and then click OK. - [Outlook 2007 users]
Drag the message directly to the To-Do bar. Right-click on the flag for email, and select Add Reminder. In the Reminder section, select the date and time you want the reminder to appear and click OK.
(In Outlook 2007, messages that you flag for follow-up not only show-up not only show up in the To-Do bar, but also in your task list and your calendar.)
How to File Mail with Message Rules in Outlook easily?
Using rules to handle mail can save you filing and mailbox cleanup time, as well as automate replies and forwards. - Go to Tools > Rules and Alerts
- Click the New Rules button, and be sure that Start creating a rule from a template is selected in the Rules Wizard dialog.
- Work through the steps of the Rules Wizard to create your own custom rule
- After completing the wizard, you will see your rule listed in the Rules and Alerts dialog box, along with a check box to indicate whether the rule is currently on or off. Click OK to save your rule
You can return to the Rules and Alerts dialog at any time to turn a rule on or off from
Tools > Rules and Alerts.
How to easily Sort Messages Quickly in Outlook?
You can find messages in mailbox folders more quickly by changing how they're sorted in your email folders. For example, you can arrange your email by date, sender, file size etc.
- [Outlook 2003 users]
At the top of your mail folder, select the Arranged By: tab. Click your view option.
How to easily Archive your Calendar in Outlook? Step by Step guide
Here are the simple steps on how you can Archive your Outlook calender to your desktop easily. Please Note: Archiving your calendar puts these entries into a pst file on your local computer, so you cannot access these archived entries from Webmail or from another machine.1. Go to File > Archive
2. Select the second option Archive this folder and all subfolders, select Calendar from the list
3. Choose a date from Archive Items older than, then click on Browse under Archive to select where to archive the entries to.
4. Click OK when you are done
In Calendar view, you can now see Calendar in Archive folders under "My Calendars" so you can now view these archived entries by selecting the check box.
How to access Google Docs and Spreadsheets and Powerpoint Offline
Google Docs now allows you to view and edit your documents offline, without an internet connection. To do all of this, Google Docs uses Google Gears, an open source browser extension that adds offline functionality directly to the browser. This is very cool. Finally a lot of competition for Microsoft.How to disable messages from being Marked as Read after Previewing in Outlook
Today I came across a strange problem working with Outlook at my new office. Whenever I click on a mail to PreView, it would open the mail in the previewing pane and also mark the mail as Read. This was kinda irritating for me, as I usually preview mails to glance on what it means. If needed I would open and read it - I expected Outlook to behave in such a way that it marks a message as Read only when I open it.Turns out this problem that I faced is actually the default behavior of Outlook. So, I just went ahead and figured out how to stop this default behavior.
Here's how you can do it. Head over to Tools > Options and then click on the Other tab. Click the Reading Pane button to bring up the options(shown in screenshot above - click image to enlarge).
Just remove the selection on the checkbox "Mark items as read when viewed in the Reading Pane". You'll notice that you can't also select the "Mark item as read when selection changes" box, which seems a little silly, but it's not important - it also needs to be unchecked.
Remember that you can always mark an item as read by using the keyboard shortcut Ctrl+Q, which is really the fastest way to mark items as read.
How to open .xlsx files easily without using Microsoft Office 2007
Well, you might be aware now that - Microsoft Office 2007 introduced a new file format called the Microsoft Open Office XML Format (.xlsx). But unfortunately this format is not compatible with older versions of Microsoft Excel(like Office Excel 2003 / Excel XP) or with alternative operating systems like Linux or Mac OS X. Nor is it compatible with other word processing applications like OpenOffice, Lotus 123, or NeoOffice.Below are some easy solutions on how you can still open your xlsx files in other systems and also easily convert it to previous versions of Excel.
- Install the latest version of Microsoft Office Compatibility Pack and it'll be able to detect the .xlsx file format and help you convert it to .xls file format.
- Use the Online Solution found here to convert your .xlsx to be used in other formats too.
How to easily Strip attachments automatically in Microsoft Outlook
If you just don't have enough time in the day to sort through all your mails and file each attachment (I'm sure everyone can relate),I suggest you use this macro that strips attachments from your emails, saves them to a folder in your My Documents directory, and inserts a hyperlink pointing to the saved attachment:Note: Before using this macro, please store all important attachments, run it on a message containing an attachment of low importance and check the macro is working properly. Use this macro at your own discretion and risk, and ensure that you do not overwrite files with the same name.
1. In your My Documents folder, create a folder named "OLAttachments"
2. In Outlook, go to Tools > Macro > Macros
3. In the Macro name box, type a name for your macro, e.g. SaveAttachments (no spaces) and click Create.
4. Paste the following code into the code window of the module:
Dim objOL As Outlook.Application
Dim objMsg As Outlook.MailItem 'Object
Dim objAttachments As Outlook.Attachments
Dim objSelection As Outlook.Selection
Dim i As Long
Dim lngCount As Long
Dim strFile As String
Dim strFolderpath As String
Dim strDeletedFiles As String
' Get the path to your My Documents folder
strFolderpath = CreateObject("WScript.Shell").SpecialFolders(16)
On Error Resume Next
' Instantiate an Outlook Application object.
Set objOL = CreateObject("Outlook.Application")
' Get the collection of selected objects.
Set objSelection = objOL.ActiveExplorer.Selection
' Set the Attachment folder.
strFolderpath = strFolderpath & "\OLAttachments\"
'MsgBox strFolderpath
' Check each selected item for attachments.
' If attachments exist, save them to the Temp
' folder and strip them from the item.
For Each objMsg In objSelection
' This code only strips attachments from mail items.
' If objMsg.class=olMail Then
' Get the Attachments collection of the item.
Set objAttachments = objMsg.Attachments
lngCount = objAttachments.Count
'MsgBox objAttachments.Count
If lngCount > 0 Then
' We need to use a count down loop for
' removing items from a collection. Otherwise,
' the loop counter gets confused and only every
' other item is removed.
For i = lngCount To 1 Step -1
' Save attachment before deleting from item.
' Get the file name.
strFile = objAttachments.Item(i).FileName
' Combine with the path to the Temp folder.
strFile = strFolderpath & strFile
' Save the attachment as a file.
objAttachments.Item(i).SaveAsFile strFile
' Delete the attachment.
objAttachments.Item(i).Delete
'write the save as path to a string to add to the message
'check for html and use html tags in link
If objMsg.BodyFormat <> olFormatHTML Then
strDeletedFiles = strDeletedFiles & vbCrLf & "
Else
strDeletedFiles = strDeletedFiles & "
" & "" & strFile & ""
End If
'MsgBox strDeletedFiles
Next i
' End If
' Adds the filename string to the message body and save it
' Check for HTML body
If objMsg.BodyFormat <> olFormatHTML Then
objMsg.Body = objMsg.Body & vbCrLf & _
"The file(s) were saved to " & strDeletedFiles
Else
objMsg.HTMLBody = objMsg.HTMLBody & "
" & _
"The file(s) were saved to " & strDeletedFiles
End If
objMsg.Save
End If
Next
ExitSub:
Set objAttachments = Nothing
Set objMsg = Nothing
Set objSelection = Nothing
Set objOL = Nothing
End Sub
5. From the File menu, click Close and return to Outlook
6. To add a button for this macro, go to View > Toolbars and select the toolbar you want to display
7. On the toolbar, click the Toolbar Options arrow, point to Toolbars and click the toolbar you want to display
8. On the toolbar, click the Toolbar Options arrow, point to Add or Remove buttons and click Customize.
9. In the Commands tab, in the categories list, click Macros
10. In the Commands list,. click the name of the SaveAttachments macro you added and drag it to the displayed toolbar
11. In the Customize dialog box, click Close
12. To use this macro, from the Messages view, select a message and
- Press Alt + F8, select the macro name and click Run OR
- Click the button you created for this macro
Subscribe to:
Posts (Atom)
