[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Microsoft Office

65K

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 Developer Bootcamp in Zurich 12th November, sign up here;
https://www.eventbrite.com/e/global-office-365-developer-bootcamp-tickets-50629886353 
1
Determine the Perfect Price for Your IT Services
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

I am looking for a file browser VBA code for Excel Office 19 I had the standard code and tried to convert it to Excel office 2019 any help would be gratefully received

Declare PtrSafe Function SHGetPathFromIDList Lib "shell32.dll" _
    Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As Long

Declare PtrSafe Function SHBrowseForFolder Lib "shell32.dll" _
    Alias "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) As Long

thanks

John
0
LVL 23

Administrative Comment

by:Andrew Leniart
Hi kuasa99,

Welcome to Experts Exchange. What you done here is make a Post, which is just a way of sharing information with the EE community.

To get expert help on your issue, please use the blue Ask a Question button at the top of your browser while logged in to EE.

I hope that's helpful.

Regards, Andrew
EE Topic Advisor
0

ISO 4217 Currency Codes in VBA


Currency codesShould you need to maintain a table of current currency codes, here is how: ISO 4217 Currency Codes in VBA

My article demonstrates two sources:
ISO itself (the definitive source)
Currency Converter API
0
LVL 60

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
I haven't experienced that myself yet, but there are many things that Microsoft is doing that I find annoying, like I can't postpone Windows updates indefinitely or even for a reasonable time frame.   Worse, I can't schedule them the way I want.   They only allow for a 12 hour window of when the system is considered active.

I have one client right now where the VP often starts his day at 4:00 am, normal hours are 8 to 5 in the office, and some of the estimators work until 6 or 7.  So my down time is basically 8:00 pm till 3:00 am with them.

I understand there are technical reasons for some things they do, and that not everything can be taken into account, but the past couple of years, I feel like I've got handcuffs on when I work with Office and Windows.

The hiding scroll bar on the start menu in Win10 is driving me absolutely nuts at the moment.

Fun, fun, fun....

Jim.
0
LVL 23

Expert Comment

by:Andrew Leniart
Hi Jim,
that I find annoying, like I can't postpone Windows updates indefinitely

A way has recently been found to address this problem in Windows 10.

I hope you find the following Question thread to be as interesting as I did, which shows an easy means of disabling (or turning off) Windows updates permanently until manually re-enabled.

https://www.experts-exchange.com/questions/29118745/Disable-Windows-Update-forever.html

Skip down to the last third of the comments for the solution to that problem. Quite an interesting piece of detective work by EE member McKnife :)

The hiding scroll bar on the start menu in Win10 is driving me absolutely nuts at the moment.

I feel your pain Jim! :)

Andrew
0
#List of  #Office_365 Users
The Office 365 licenses and Office 365 user accounts do not need to have the one-to-one correspondence. It is possible to have users who do not have the Office 365 license, and it is also possible to have the Office 365 licenses, which have not been assigned to a user. (As a matter of fact, a single user account also can even have various Office 365 licenses.)
Know how to Export It to CSV file format.
0
0
0
0
0
0
Become a Microsoft Certified Solutions Expert
LVL 12
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

I have a client getting error 2287 using EmailDatabaseObject macro. They are using office 2016. Does this
have to do with a setting in Outlook. What is the workaround for this issue?
0
LVL 25

Expert Comment

by:Iamthecreator OM
Please post your issue as a 'Question' and not a POST.
0
LVL 23

Expert Comment

by:Andrew Leniart
rhSQL15,

You will have more luck getting Expert help with this issue if you use the big blue "Ask a Question" button at the top of your browser when logged into Experts Exchange.

I hope that's helpful.

Regards, Andrew
EE Topic Advisor
0
0
Amazon is launching a new business where you can franchise a branded Amazon courier service:
https://logistics.amazon.com/

Startup cost is $10k

They estimate annual profit for a fleet size of 20-40 vans at $75k - $300k a year:
https://logistics.amazon.com/marketing/opportunity

Is this the "Uber"ization of the Post Office?
2
LVL 56

Expert Comment

by:Scott Fell, EE MVE
I saw that the other day too.  I think the vans turn out to be daily rentals from Enterprise. Managing 20 to 40 vans probably means managing 30 to 60 people, 12 hour shifts, 7 days a week.  If you are at the low end of $75K, that is a lot of work for that amount.
2
LVL 20

Author Comment

by:Lucas Bishop
Yeah, package/mail delivery is a real grind. My parents are retired postmasters, so I'm interested to hear their take.

I could see how this would be an interesting fit for someone with experience in managing a delivery/logistics model, to be able to work for themselves. At the same time, you would have no negotiating power with Amazon as far as payment per package/van. Seems like an extremely high risk scenario.

Seems like the only way you could step into this safely, is if you could look at the historic package volume for the geographic region you'd like to service.
0
SysTools Released SysTools Office 365 Export Version 4 With Archive Mailbox Migration

OFFICE-365-EXPORT.pngThe SysTools Office 365 Export migrates the Office 365 account data to PST, EML, MSG file format. It has also been updated with the feature to Migrate the Archive mailboxes from Office 365 to PST, EML, MSG file format with multiple filters for mails contacts, calendars.
For more information visit:
https://www.systoolsgroup.com/office-365/export/

                           

1
For those of you wondering what might be up and coming in Office, one way to stay on top of that is the office 365 road map page:  https://products.office.com/en-us/business/office-365-roadmap?filters=#abc

and checking the "In Development" section.  For those interested in Microsoft Access, you will find a new feature listed there:

"Access: New charts for modern data visualization
Introducing new charts to help you visualize data managed in Access in an appealing and modern way. Add any of the new eleven chart types, including a combo chart, to a form/report to visualize your data and make informed decisions."

Sounds like we are going to get a major new feature!   Of course, if your part of the Office Insider program, you'll be one of first to be able to check it out!
0
Exchange Admins,
Exchange Administrator of a O365 tenant that is using either DirSync or AADSync are no longer supported and may not work correctly. These tools are no longer supported as of April 2017, and after December 31, 2017 O365 team are not able to guarantee your connections from Windows Azure Active Directory Synchronization (DirSync) or Azure AD Sync work properly.  This may affect your ability to synchronize your local directory infrastructure with Office 365, and will result in users being unable to log in to their Office 365 services.

Recommended action
Azure Active Directory (AAD) Connect is the best way to connect your on-premises directory with Azure AD and Office 365.  Upgrade your sync functionality to the latest version of Azure AD Connect, which is the currently supported tool for syncing data to O365 cloud features.

Hope it helps.

Thanks
MAS
1
0
If I want to pursue a career as a Data Analyst and I have limited data analysis skills in addition to SQL, Python, HTML, CSS and Microsoft Office Suite experience, are there any certifications I could take to bolster my credentials as a Data Analyst?
1
How Mobility Is Modernizing Oil Field Services

Mobility solutions is what personnel working at oil fields need. But are they doing their bits to revolutionize the oil fields? We need technological advancements not just on the field but also the backend office which till now was abstained from newer ways of service deliveries that goes beyond the perspective to legitimize the modern uphold.

Get more info: https://goo.gl/BkFtBt 
0
Big Business Goals? Which KPIs Will Help You
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Microsoft has added a page to their Office Templates which provides templates for five types of Access databases (Asset Tracking, Contacts, Students, Event Management, and Task Management).  I have not had a chance to review these databases, but this is the first move we have seen in quite some time to add anything "Access" to Office marketing, and is good news.

Please download these templates and encourage others to do so.  If we generate enough traffic, maybe we will be able to get additional templates on the website.

0
I am sharing an Office 365 Calendar using a Security Group. When the calendar was initially shared, it sent invitation emails to the group members. How do I manage invitations when I add someone to the group? It doesn't appear to do it automatically.
0
LVL 37

Expert Comment

by:Rob Henson
djstewart - you have created a post here. You will get better results if you raise a question. Use the big blue button at the top of the screen or this link:
https://www.experts-exchange.com/askQuestion.jsp
0

Author Comment

by:djstewartnc
Thanks Rob. First time in since they changed the format .... still fumbling my way around.

Will do.

David
0
gSuite help is still terrible.

I have several comments about how using paid support for Office 365 is far superior to the experience using gSuite including my comment on this article from 2015.

Yesterday's call to gSuite support reconfirms.  Problem is a user wants to have access to Android apps on his new Google Pixelbook. Going to settings on the Pixelbook to enable the feature is grayed out.  A call to Pixelbook support confirmed the issue is the user is a member of a business gSuite account and there is a feature that has to be turned on.  I was directed to call into gSuite. Calling gSuite support is about as helpful as talking to my 2 year old niece. The gSuite tech acted as if he had no knowledge of a Pixelbook. I had to explain several times it was a product of his own company. Even going down the Chromebook route didn't help. He could simply point to turning on a feature that was already set. Otherwise, I would have to call the Pixelbook Support.

I have called into office 365 support for many issues. Sometimes the issue went beyond the scope of what the tech should have helped for their own silo, but they still were able to spend 30 to 60 minutes on the phone to solve the issue with great patience and product knowledge.

After the sale support many times goes unnoticed or untested.  When evaluating a service or software, I will call in…
2
LVL 56

Author Comment

by:Scott Fell, EE MVE
Thanks for the nudge Andrew.  Perhaps I will do just that.
0
LVL 23

Expert Comment

by:Andrew Leniart
Please do Scott. I'll be more than happy to edit and get it published for you.

I think a lot of people may benefit from your experiences, and it may just be the push Google needs to provide some decent support.
0
I came across the issue discussed in this article https://www.experts-exchange.com/questions/29026898/outlook-email-not-working.html and what I did,  from control panal/uninstall progrem I selected office. clicked on change [not uninstall] and choose repair, this solved the issue
0

Microsoft Patch Tuesday December 2017 updates


Microsoft Patch Tuesday December 2017 is here, with a list of 34 critical security updates & 2 key fixes, for 7 products. Since the vacation isn't two far, make sure all the patches are updated in your network and have a happy vacation. Adobe also has released its security update

Key fixes:

  1. CVE-2017-11940
  2. CVE-2017-11937

Adobe:

APSB17-42

Potential impact for 34 security updates:

  • Remote code execution
  • Elevation of privilege
  • Information disclosure
  • Spoofing
  • Security feature bypass

Products:

  • Microsoft Exchange Server
  • ChakraCore
  • Microsoft Windows
  • Microsoft Edge
  • Internet Explorer
  • Microsoft Malware Protection Engine
  • Microsoft Office Services and Web Apps
  • Microsoft Office

You can read a complete report on https://goo.gl/mwbq1Q
1

Microsoft Office

65K

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.