Microsoft Office

63K

Solutions

41K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Share tech news, updates, or what's on your mind.

Sign up to Post

Office 365 Backup and Restore
The purpose of this article is to describe things one should know before moving to Office 365. There are lots of parameters in place that need to be checked.
1
Cloud Class® Course: Microsoft Office 2010
LVL 12
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Convert Excel Contacts To Outlook Easily
Want to troubleshoot the issue of importing contacts from Excel to Outlook error No Named Ranges?? Resolve this problem and get the error-free solution to resolve the “No Named Ranges” error in a hassle-free way.
0
Are you encountering the error message “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupted” when trying to open the MS Excel workbook, and you are not able to open the workbook? If your answer to this question is a Yes, know all about this error & its solutions.
0
Export CSV to VCF or vCard
Do you know how to convert CSV to multiple VCF formats? Are you searching for a hassle-free solution to import .csv file contacts into .vcf files? Get an optimum solution here to export Excel or CSV files to vCard or VCF formats! Read more to know the solution in detail.
1
It is not that simple from VBA to display a compressed help file as it should be. API calls and a few tricks are needed. This demo and full code will show you how.
0
Backup Office 365 Mailboxes to PST
Microsoft Office 365 is one of the most widely used business productivity suites. Over 23 million users around the world are now utilizing Office 365 and this number increasing every year. Here we have discussed topic how to backup Office 365 Mailboxes to PST easily.
0
The most emerging queries of the user is to upload Outlook OST mailboxes to Office 365 account. So, here we will provide the manual as well as an automated solution for to transfer OST file to MS Office 365 in an absolute manner.
0
You can use the network upload option and the Office 365 Import service to bulk-import PST files to user mailboxes. Network upload means that you upload the PST files a temporary storage area in the Microsoft cloud.
0
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
0
Lotus Notes to Office365 Migartion
Get to Know about Lotus Notes email migration to Office 365 in detail. Explore the article for better Lotus Notes to Office 365 migration techniques to transfer all data items to the O365 domain.
0
Cloud Class® Course: Ruby Fundamentals
LVL 12
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

While repairing a PST file with ScanPST.exe, many users have encountered the error "Attempting to Validate BBT Refcounts". In this article, we are going to describe the reasons and solution to fix the error.
0
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
0
Stellar Outlook Toolkit
This is a comprehensive review of a bundled Toolkit designed for use by IT Professionals and End Users to help Microsoft Outlook fans manipulate Outlook files and repair some common problems. Enjoy...
5
 
LVL 72

Expert Comment

by:Qlemo
Comment Utility
Either the article or the comment by Jerry Frey is wrong.
The article describes that split created one file with items hit by the filter condition, and the original PST left as-is, and that definitely is no split. A split creates at least two files, all with unique content, which can be merged to get the original PST without any duplicates.
0
 
LVL 2

Expert Comment

by:Jerry Frey
Comment Utility
Hi,

In case of Split pst by size it Split one PST file into multiple PST.
In case of By Date, By Mail id, the software creates a new PST file as per the size or as per mail id selected.

Hope this clears your doubt :)
0
Here is why.
0
Multi-Purpose Knife
This article presents several of my favorite code snippets.
2
Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering. This article seeks by illustration to offer a practical demonstration of the theory.
0
Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
2
 

Expert Comment

by:Fanie Prinsloo
Comment Utility
Confirmed.  The process works like a dream and saved us days of work trying to update the links manually within the files
1
 
LVL 42

Author Comment

by:Shaun Vermaak
Comment Utility
Thank you Fanie
0

Though there are a few manual ways to import PST files to Office 365, third-party PST to Office 365 import tools are preferred over them due to various reasons.  Consequently, many tools or services are available for the same. Here, we pick the top 4 ones:


  1. Kernel Import PST to Office 365 Tool
  2. 4Team PST Migration services
  3. BitTitan PST to Office 365 Migration Wiz
  4. NetMail PST to Office 365 migration services


Kernel Import PST to Office 365 Tool


Import PST to Office 365 Tool is reliable in all aspects. It can import PST/OST files to Office 365 mailboxes quickly without losing any data. The entire process completes in just 4 steps. Also, it allows you to map PST mailboxes manually or by a CSV file to the required Office 365 mailbox. Using this tool, you can import emails, calendar, task, journals and other items of each mailbox to office 365. You can also apply filters to PST data before importing it to Office 365 mailbox.



Note: You can import PST to a single mailbox using its Office 365 account. Also, you can import PST to multiple mailboxes using an Office 365 account with Global Administrator credentials.


4Team PST Migration Services


With the use of this 4Team PST Migration services, you can import PST files and OST files to Office 365. You can also import multiple Outlook profiles to the Office 365 account. While using the import services, you do not have to worry about anything else. Another advantage is that their service can be used for migrations involving many other applications like Gmail, Exchange, etc.


BitTitan PST to Office 365 Migration Wiz


BitTitan PST Office 365 MigrationWiz can migrate PST mailboxes and public folders to Office 365. This process has zero downtime and zero impact on end users. This tool also provides complete security to data while you are using this MigrationWiz. However, this tool is complicated to use, and so novice users cannot use it.


NetMail PST to Office 365 migration services


NetMail offers PST to Office 365 import services. They offer to eliminate security risks and provide you well-secured data without any loss or any change in it. So, it helps to deal with all the import-related issues and access PST files in Office 365 quickly. It is a reliable and affordable way to import PST to Office 365. You can use it without worrying about any technical details.


Final Verdict


If you want to avoid manual methods for importing PST files to Office 365, you will have to try third-party tools. Here, we have listed the top 4 tools for importing PST to Office 365 - you can use any of them. But if user-friendliness is your first consideration for selecting the tool, you should choose Kernel Import PST to Office 365 tool. It is very efficient in importing PST files to Office 365.

0
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
0
Free Tool: Path Explorer
LVL 12
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Gmail by Google
Read this tutorial to learn how to fix repeating password error prompts when setting up Gmail IMAP with Microsoft Outlook. The entire process is described with step by step, illustrated instructions. Enjoy...
3
My image

As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to do that.


An example

Let’s say I wanted to determine if a variable (in this case a String) contains certain values, so I might write something like this.

If MyVar = "This" Or MyVar = "is" Or MyVar = "a" Or MyVar = "test" Then
                                            MsgBox "I'm interested in those words"
                                        End If

At one time in my programming career when I would write a line like the first one, I’d say to myself “I wish that I didn’t need to repeat the “MyVar =” and could write the following instead.

If MyVar = "This" Or "is" Or "a" Or "test" Then

Experience, however, taught me that I’d get a syntax error. Fortunately I eventually discovered the Select Case statement and I was able to write this instead which is similar.

Select Case MyVar
                                            Case "This", "is", "a", "test"
                                                MsgBox "I'm interested in those words"
                                        End Select

The rest of this article explains how to use the powerful Select Case statement.


The basic Select Case syntax

Select Case < The Expression >
                                            Case SomeCondition
                                                ‘ Do something
                                            Case Else
                                                ‘ Do the default action
                                        End Select

Notes:

  • For the purposes of this article, “The Expression” is any valid expression that resolves to a string, a numeric value, or a Boolean value. In the case of Excel that includes cell values.  
  • When Visual Basic encounters a Select Case statement, it evaluates the Cases top to bottom, and once it finds that the Case is True it executes the code in that Case and ignores the rest.
  • There can be multiple Case statements
  • The Else case is optional


An expanded version of our Select Case above might look like this.

Select Case MyVar
                                            Case "This", "is"
                                                MsgBox "It’s one of the first two words"
                                            Case "a", "test"
                                                MsgBox "It’s one of the last two words" 
                                            Case Else
                                                MsgBox “Word not found”
                                        End Select


In Case you want to know more

Here are some other Case statements that illustrate the power of Select Case.

Case 1 to 7, 19, > 25

Will be true if the expression resolves to a number between 1 to 7 inclusive, 19, or any number greater than 25

Case Is = "blah"

Same as Case "Blah"

Case "alpha" To "omega"

Visual Basic can spell and any value that is alphabetically between the two (like “great”)  will be true. Be warned however that “Great” is not the same as “great” and the former will not be true. One way to avoid that is to put Option Compare Text at the top of your code module. When you do that all text comparisons will non-case sensitive. Another way is this which compares the upper case versions of the text.

Select Case UCase(Range("B2"))
                                            Case "ALPHA" To "OMEGA"

You can also nest Select Case statements like this example.

Select Case Range("B2")
                                            Case "alpha" To "omega"
                                                Select Case Range("B2")
                                                    Case "coding", "is", "fun"
                                                        MsgBox "I agree"
                                                End Select
                                        End Select

The MsgBox will be displayed if it contains one of those three words.


And what is perhaps my favorite

Remember where I said that “The Expression” could be anything that resolves to a string, a numeric value, or a Boolean value? Well, True (or False) is a Boolean value and so you can do this:

Select Case True
                                            Case Range("B1") = 5
                                                ' Do something
                                            Case Range("C4") = "Done"
                                                ' Do something else
                                            Case Else
                                                ' Do some default action
                                        End Select
                                        
                                        

And the first one of those things that is true will be executed. I find many uses for that.


Finally

For more suggestion about how to write understandable and maintainable Visual Basic code see my article on the subject.


If you find that this article has been helpful, please click the “thumb’s up” button below. Doing so lets me know what is valuable for EE members and provides direction for future articles. It also provides me with positive feedback in the form of a few points. 


If you have any suggestions for improvement or if you encounter any bugs, please send me a message. Thanks!


1
This tutorial summarizes the causes behind"an unknown error prevented access to the PST File”. It also suggests the various solutions to fix the problem.
0
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
1
 

Expert Comment

by:Andreas Wennborg
Comment Utility
Solved my problem. Thanks!
1
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
0
This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.
2

Microsoft Office

63K

Solutions

41K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.