Go Premium for a chance to win a PS4. Enter to Win

x

Microsoft Office

61K

Solutions

40K

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

Print Preview
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
0
Concerto Cloud for Software Providers & ISVs
LVL 5
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
0
Microsoft's Excel has many features that most people will never need nor take advantage of. Conditional formatting is one feature that you may find a necessity once you start using it.
1
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
0
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
0
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
0
 

Expert Comment

by:Geoff Marsh
Comment Utility
I personally recommend http://www.recoverydeletedfiles.com/word-file-recovery-tool.html which can quickly recover & repair virus attacks, unexpected system shutdown or in case of accidentally deleted Word files. Tool restores word files .doc, .docx, .dot, .dotx and .rtf formats.
0
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
0
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
1
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
0
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
0
Efficient way to get backups off site to Azure
LVL 1
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

New style of hardware planning for Microsoft Exchange server.
1
 
LVL 12

Expert Comment

by:Andrew Leniart
Comment Utility
Hi Abraham, I had to leave for a few days unexpectedly so apologies for the delay in editing.  I should be back in the next few days, however if you would like to have it edited sooner, please use the Request Attention option to contact a moderator who may be able to assist. Other than that, I'll get back on it first thing once I've retuned.

Regards,
Andrew
0
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
5
 
LVL 12

Expert Comment

by:Andrew Leniart
Comment Utility
Thanks for sharing your story. Ransomware is a topic I follow closely and have a lot of interest in. Sorry to hear you were hit by these criminal scum bags and while it irks me to know they profited from your misfortune not once, but twice, I understand the dilemma you were faced with. Backups are something we all tend to fall lax with at times and this story highlights the reasons we all need to stay vigilant. Good luck for the future.
0
 
LVL 1

Expert Comment

by:Josh Petraglia
Comment Utility
Education is Power!

Also, (offline) Backups are your best friend. Just saying.
0
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
1
 
LVL 4

Author Comment

by:Bob Flisser
Comment Utility
Thanks, Andrew!
0
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
0
 
LVL 49

Expert Comment

by:Martin Liss
Comment Utility
Thanks, that helps and I suggest you mention that the lists are related and also include the description of what you mean by "true database form". And rather than
Each option also then has an identifying code allocation. The codes are calculated in columns H to M...
I'd suggest something like
Each option also has an identifier which is generated via the formulas [that's more familiar to American audiences than formulae] found in columns H to M...
You should also change the reference to "code allocation" in you next to last paragraph.

I find
However, if these three lists are used for DV they would not be dynamic and change based on the selection from the previous category.
a little confusing. Do you mean
However, if these three were used for DV as is, they would not be dynamic because [explain why]

I'm going to publish this no matter what but consider my suggestions and let me know when you're done.
0
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
0


Outlook for dependable use in a very small business

 

This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This is more of a descriptive article than a “how-to” article so there are few screen shots. 

 

As background, I use Outlook because (a) it works and (b) it is a very common email application for computers. I use POP3 and not IMAP because (a) I want my email on my computer and (b) I have outlived many IMAP vendors. I want email on my terms, not someone else’s. I have looked at IMAP but decided against it. Thus far, I have not had reason to regret my decision. 

 

I keep Outlook on two computers so that all received email is on both computers going back to 1996. I keep Sent email on my laptop as I travel around with it. I can always transfer Sent mail to the other computer if I need it. I understand IMAP might solve these issues but I have decided against it for the reasons above.

 

What do I mean by dependability and critical requirements?

 

The same email address “forever”: This is a critical requirement for me. I have had the same email address since 1996. I have no interest in changing it. Since I change ISP companies and they come and go, using an ISP’s email system is not something I can do. If Microsoft had come along in 1996 with Outlook.com, I might have an outlook.com email address but Microsoft was late to the game and I had already decided on a portable email address back then.

 

My end email vendor is a tiny little company in Toronto and I know the players personally. I can call them on the phone when there is an issue. If email is available, they will respond to me very quickly. Most people cannot do this, but I like the capability it offers me. Once in a while they take their customers to dinner and a beer at a local pub. I meet other email customers at the same time. 

 

No spam: Another critical requirement is I do not want spam. And now more than ever, spam is a source of ransomware. I do not want it in my inbox at all. Most users think that they can block ransomware with tools on the computer. Maybe (only Maybe). Blocking spam is the very best way to stop ransomware. 

 

So now there is some complexity. 

 

For email address portability, I use Mail.com. I started using it when it was Four11.com, and when it claimed to be “free forever”. Ha! I continued when it became Iname.com and it was still free. I continue now as Mail.com and pay to use the forwarding service ($30 per year). I forward my email to my current email vendor. My email vendor used to change more often then I changed socks some years back (at least so it seemed to me). Then I found my current email vendor about 20 years ago. They came (more or less) out of Internex.com – one of Toronto’s first consumer Internet vendors. I had the best email address in the world: io.org. It couldn’t last and it didn’t.

 

Let us return to the issue of spam. Mail.com has one of the best email filtering systems there is. It was not always this way, but for the last 10 years they have been top notch. I might see a spam email every other month or even less. I see about 10 emails a month in my spam folder. The rest gets dumped into the bit bucket by spam filtering or grey listing. I am not aware of losing any email that I have not seen, including in the spam folder. 

 

The Mail.com filtering is so effective that regular email from joe@abc.next comes into my inbox, but if Joe’s computer has been compromised or his email address spoofed, the email from joe@abc.next that says “You need to read this www.link.next” goes to spam. Of course, clicking on the link (if it got into your inbox) hoses your computer.

 

My Toronto vendor uses both grey listing and Spam Assassin. Spam Assassin is a good tool and I get essentially no spam from this system. Grey listing is a box or application that looks at incoming email and looks back at the IP address that sent it. If that IP address is not identifiable, the email is not accepted. I have had grey listing running for over 15 years and I am not aware of any lost emails. 

 

Allow me to underscore the point on spam. Eliminating spam is the most important weapon in eliminating ransomware. 

 

Email organization: I get a lot of email and so I keep my Inbox tiny (never more than 50 emails) and I put email into folders as soon I get it or shortly thereafter. I have just over 120 folders. The names are all meaningful so I see no need to use subfolders and there are no subfolders to my Inbox. Email organization is a personal thing and I organize my email to fit myself. Your mileage may vary (YMMV if you come out of the days of DOS).

 

Email archiving: Rule 1 – Archive your email. It works and it is silly not to use the Archive function. Take a look in here (Experts Exchange) – Email is slow, sluggish, broken (take your pick). How big is your email file? I ask. 40 GB. Duh!

 

Open Outlook, File, Options, Advanced, Auto Archive Settings. See below:

 

 

I auto archive every 30 days, archive everything older than 10 months, and never delete old items. At somewhat irregular intervals, I archive into a new file. I have 6 archive PST files plus my current email PST file, all of which are below 2 GB. 

 

One trick / defect of Outlook is that the folder archive option is normally not on by default. I think that is because most people keep email in their Inbox. I do not. So, two things:

 

1. Go to the Properties of each folder and make sure the Archive Option is ON


2. Go back to the main Archive options and select Archive Now. 

                            

Contacts: I keep my Contacts in the Contact folder by individual. It is a big mistake to assume Auto Complete will never go wrong. It will go wrong, precisely at the wrong time for you. Use Contacts. I do not archive contacts. 

 

Calendar: I live from my calendar. I make appointments for everything I do, keep a brief description of what must done in the appointment line, and keep notes and expenses in the note area of the calendar item. I do archive calendar items. 

 

I have done this for years, before Blackberries and iPhones. When I got my first smart phone (a Blackberry) I began to sync Contacts and Calendars (all items in the current PST file but not archives) and now have this readily available on my smart phone. 

 

Sync to Smart Phone: My current phone is an iPhone SE (6s) and I use iTunes to sync the items. It means my iPhone tells me where I am supposed to be and what I am supposed to do. This is outstanding organization when I am busy and nothing can be left to chance. Syncing to iTunes also backs it up, so if my phone is damaged (happened once) a new phone can be set up in minutes. 

 

 

 

Outlook Main Screen Organization:  I keep a traditional organization screen – folder tree on the left, Inbox top middle, Preview bottom middle and calendar on the right. I know where things are, what my current email is and where I am supposed to be. 

 

 

Keeping email on two computers using POP3:  There are several ways to do this. I use POP Peeper (esumsoft.com) as an email daemon to see if there is email, action Experts Exchange email without downloading it and deleting trivial email I do not need to keep. I set Outlook on both computers to never delete email. When I have it on both computers, I delete with POP Peeper. 

 

I never send email from my desktop computer, only from my Laptop. So, my laptop has all email – received and sent email. My desktop has all the received email. Accordingly, I need only back up my main PST on my laptop about monthly or when I am going away for a week or so.

 

Doing all the above takes a bit of incremental time, but practice (more than 15 years of it) makes it easy and provides me with a powerful organizational tool that is fast and efficient (because I archive) and tells me what I need to be doing (Calendar). I can easily get a Contact on the phone because I sync via iTunes (Contacts). 

 

I trust the above will help you use Outlook more effectively.

 


5
 
LVL 51

Expert Comment

by:Jackie Man
Comment Utility
Interesting.

Your writing and presentation s are much better than mine.

I use POP for archiving whereas IMAP for instance response so that you can see all sent emails at all mobile devices and removing all SPAM before I got the same email vis POP after a day or a week of work.
0
 
LVL 99

Author Comment

by:John Hurst
Comment Utility
Thank you for you kind and gracious comments. You brighten my day!
0
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
2
 
LVL 28

Expert Comment

by:Shums
Comment Utility
Great Expert with great mind
0
 
LVL 49

Author Comment

by:Martin Liss
Comment Utility
Thanks.
0
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
2
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- Citrix, vmWare, etc.)
0
Configuration Guide and Best Practices
LVL 1
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Warning
This article describes a serious pitfall that can happen when deleting shapes using VBA.
3
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
3
 

Expert Comment

by:Ravi Gupta
Comment Utility
Thanks Geeta for publishing this helpful article about PST to Office 365 migration. I hope it will help many users who want to import Outlook PST files into Office 365 account.
1
 
LVL 2

Author Comment

by:Geeta Malik
Comment Utility
Thanks Ravi for your valuable comment. :)
0
Update Pic
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me is flawed and borders on irresponsible behavior!
10
 
LVL 3

Expert Comment

by:13L@CK_H3@RT
Comment Utility
Sometimes we will get "The update is not applicable to your computer" when updating the patches as well; so Wait a bit :)
0
 
LVL 12

Author Comment

by:Andrew Leniart
Comment Utility
Hi SpiderlinK, thank you for your comment.  I've found that failure to often be a result of being behind in issued Service Packs. A patch will often fail on a Service Pack 1 or 2 installation if a SP3 has been released.

Best..
0
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
2
 
LVL 15

Author Comment

by:Greg Besso
Comment Utility
So IMO this is a great example of a project where you can "divide and conquer". You have a few different parts...

First, you have your method of deploying Office 365 ProPlus. This article shows my method of getting that done. Just download the scripts, tweak them to meet your needs/environment, and then it's all set.

Second, you have the "how will I install this remotely on many computers" step. For me, I rolled my own SCCM type of solution which is a set of scripts that I also have up on my blog that I called "PSMANAGE" scripts. It's an evolving project of mine, but check it out if you like.

Another tool I used to push out software remotely was this PS Tools PsExec.exe. You could remotely push a command to any workstation that was online, such as telling it to run your silentInstall.bat file. Check that out also:

https://technet.microsoft.com/en-us/sysinternals/pstools.aspx
1
 
LVL 8

Expert Comment

by:Senior IT System Engineer
Comment Utility
Thanks, Greg, you are amazing :-)
let us know once you've shared the new script of yours.
0
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
0
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will discuss how to use VBA to automate Excel.
2

Microsoft Office

61K

Solutions

40K

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.