Microsoft Office

59K

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

hi,

how to password protect excel/word/powerpoint file?

thanks.
0
Veeam gives away 10 full conference passes
LVL 1
Veeam gives away 10 full conference passes

Veeam is a VMworld 2017 US & Europe Platinum Sponsor. Enter the raffle to get the full conference pass. Pass includes the admission to all general and breakout sessions, VMware Hands-On Labs, Solutions Exchange, exclusive giveaways and the great VMworld Customer Appreciation Part

Hi Guys,

i wanted to create a rule in outlook which places any mail received from a distribution list into a specific folder.

the DL is setup on office 365. and when a user sends mail to the DL i want that to then go into a specific folder.

you cant do a rule which states 'Sent to ........' because this only lets you pick users not a DL.

Help
0
I am attaching a file that has two Start entries (C4 and C31). This is just a sample set so this would be repeated for thousands of rows. I want to know how to do two things: how do I count the number of entries between each Start e.g. it should be 26 - but to do that for all the rows in the data set. Secondly how do I show the time elapsed (in hours) between each occurrence of start. (cell T7) - again for each occurrence  of this start...basically the idea is that a pump starts...does its thing. Stops and then starts again...
EE--calculating-rows-between-entrie.xlsx
0
Hi There,

I have an excel utility that creates a txt file containing metadata to be loaded into another system.  This has started to fail after the users upgrade to O365 / Excel 2016.

It creates the text file by creating an object referencing itself as a recordset:

Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\Users\Jbloggs\Documents\user\ACTIVE\2017 07 - A&B\03 - Build\ExportFile.xlsm;
Extended Properties="Excel 12.0 Xml;
HDR=No;
IMEX=1";

However when this code is opened I receive the following error:

Code Running
Error...

Error Message

I have tried this on another machine with Excel 2016 and this code works without issue.

Any guidance would be greatly appreciated.

Many Thanks,
Mark
0
Need to have an query for 4 num exact to be show in  NUM sheet ans NUM_VER sheet (first to get done)

then show the 13 set brging location 1

In this file is very importante show

column F location 1 in yellow background (to be audit)

column L

column M

column N
num4all.xlsm
0
The attached example file contains three identifier columns with the main identifier being a code in column C.
There are duplicate codes at random down column C - Rows 3 & 4,  114 & 115, 185 & 186, and 196 & 197, are examples shown in red.

The objective is to have the contents of the lower duplicate row added to the contents of the cell above and then the lower row to be deleted.
The columns affected are from D to KQ.

The actual files have about 60,000 rows.
Example-file-with-duplicate-ID-code.xlsx
0
I have two tabs in the attached file. I am trying to create a "Result sheet" based off my  "Data sheet". I need a standard subtotal for every "Sales Person" in these fields:

1) "Amount Collected"
2) "Amount Put Back"
3) "Amount tendered"
4) "Returns"
5) "Amount"
6) "Amount removed".

But the "Final Amount" field is a different calculation. It needs to be the last "Final Amount" that was greater than 0 for that "Sales Person", BUT if there were any "Amount Put Back" AFTER the date of the last "Final Amount", these need to be added to the "Final Amount". But note that is said AFTER. If these "Amount Put Back" were BEFORE the last "Final Amount" that was greater than 0, they do not need to be added. Individual explanations for each "Final Amount" is in the spreadsheet.
Testing-file-07232017.xlsm
0
Hi
I can't move folders or sub folders  in my left hand screen  panel from one folder to another although I can move emails from one folder to another. e.g if i create a sub folder erroneously in one folder I can't move it to the right folder.  I used to be able to do it in previous versions of outlook. I am not sure what the fault is as one should be able to do it by either clicking and moving or using the move box but nothing works. When I move it. it stays there for about a second then jumps back to its previous location however many times I try it

Hope you can help. It is very puzzling.

Regards

Logan
0
if someone has CTC 4.7 L per annum(Delhi, India),
what should be salary breakup per month?
0
Hi,
I got a question, how to add an additional language pack in terminal server. default is English. but, there is just one user who needs Chinese language. How do I add extra language pack in office, so when that particular user logs to terminal server, he can switch to Chinese from English?

Thank you
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hello Experts,

Attached are two files, the MS Access db where I am trying to create multiple records based on the comments fields in the one record. The MS Excel spreadsheet contains a sample of what I am trying to accomplish.

I am able to move the records to a new table, but I am lost on the step where I want to duplicate the record based on how many comments are in the note field.

The attached Excel spreadsheet is a sample of what I am trying to accomplish based on MS Access ID=621.

Can you please help me out?

Thank you,

Steph_M
Sample.accdb
SampleNewRecord.xlsx
0
Dear All,
I am new and hope you might help. I use Windos 10 Home and MS Office / Word 2013.

This is the story.
1) I create a Word document on a USB stick
2) I saved the file onto the USB stick.
3) I edited many times the document at different times and in different days but always working on the USB stick.
4) the file was never saved on the hard drive (always edited on the USB stick)

Question:
1) Is there any viable possibility (eg. forensic investigation) that some trace or info of the document (the one that has always been on the USB stick) have been stored in the PC?
2) Should this have happened, where could said traces have been stored (swap files? tmp files? any other location')
3) Could these traces be retrieved somehow (eg. filename or even the contents of the doc file)?

Regards

WS
0
I have an Excel 2013 spreadsheet with over 3,000 entries.  The spreadsheet has customer numbers and Company Names (see attached sample) - my original spreadsheet has many more columns but I tried to simplify for explanation purposes. On the sample I have attached there are five customer numbers (3, 4, 5, 6, 7) and only two company names.  I am trying to find a quick way to determine what customer numbers are listed with both companies.  So in my example, customer #4, #5 and #7 are the customers that are associated with both companies.  That is what I am trying to extract.  I don't need to know the customer numbers that are only associated with one company. I need to pull only the customer numbers that are listed for both companies.  Any help is appreciated.  Thank you.
0
Experts,
We use Office 365 and have Office 2017 installed on most devices.
Until recent, all text messages I received were copied to my inbox. From the inbox I could reply to the text without using my phone.
A few months ago we moved from 2016 to 2017 and this stopped working. I still receive the text in my inbox, but If I try to reply I get a error “This account is not available. Setup your account and try again” .

All the instructions I find online relate to receiving notifications and matches my setup. I can find noting on the ability to reply.
Can anyone help?

Cam
0
We have an Exchange '16 server.  There are some mailboxes with @defaultdomain.com primary addresses.  My account has full permission to all of those mailboxes, and my Outlook (whether '10 or '16) will open, manage, and send from all of them.  There is one mailbox with @differentdomain.com as its primary address.  

The workstation at my office runs Office 2010, and is on the same domain as the Exchange server and is connected to it locally, the @differentdomain.com mailbox opens fine.

My laptop is not on the domain and also runs Office 2010, and it will not open the @differentdomain.com mailbox.  It doesn't matter if it is connected locally via ethernet, locally via wireless, or remotely.  It gives: "Cannot expand the folder. The set of folders cannot be opened. The attempt to log on to microsoft exchange has failed."

My workstation at home behaves the same as my laptop; it's running Office 2016.

I tried adding an @defaultdomain.com address to the uncooperative mailbox and that did not help.

If I create a separate profile in Outlook and have it connect to just the uncooperative mailbox, it opens fine.  But I would like to have the uncooperative mailbox open within my default profile.

When I try to open the mailbox by adding it inside of the mail settings, I get an error that says something like "you have tried to open more items than your Exchange administrator will allow", and then none of my Outlooks on any of my devices (not just the one that I tried to …
0
Someone has created this Macro for me to import data from a number of workbooks into the one in which the macro is running.  All workbooks are in the same folder.  Trouble is, although this runs fine on a Windows PC (Excel 2016), it doesn't run on a Mac (also 2016).  It comes up with an "Run-time error '53' File not found".

Incidentally, the last line calls another Macro I recorded that just Word Wraps a column in the workbook.  The last line of that calls another macro that adds in some text to say that the macro has run successfully.  I don't think the error is about the calls but if you can suggest how to add the lines into the first Macro, below, that would be great.  

Any ideas what is preventing this run on a Mac?
Thanks

Sub ConsolidateResults()
Dim wbDst As Workbook
Dim wbSrc As Workbook
Dim rngDst As Range
Dim rngCopy As Range
Dim strFileName As String
Dim strPath As String

    Application.ScreenUpdating = False

    strPath = ThisWorkbook.Path & Application.PathSeparator
    Set wbDst = ThisWorkbook
    Set rngDst = wbDst.Sheets("Input Data").Range("F5")

    strFileName = Dir(strPath & "*.xlsx")

    Do

        Set wbSrc = Workbooks.Open(strPath & Application.PathSeparator & strFileName)
       

        Set rngCopy = wbSrc.Worksheets("Copy").Range("F1:F40")
 
   
        rngCopy.Copy
        rngDst.PasteSpecial xlPasteValues

        wbSrc.Close SaveChanges:=False

        Set wbSrc = Nothing

        Set rngDst = …
0
We use Office 365 and have our Active Directory synced with our O365 accounts.  Our users still have to login to our sharepoint site when they open it in a web browser using their O365 credentials.  Is there anyway to avoid this since they already logged into their computer with the same credentials?
0
We are in the process of moving users out of Windows 7 / Office 2010 latpops and into laptops running Windows 10 / Office 365.
We are exporting / importing favorites and cookies, etc... but one issue we run into is we cannot seem to find a way to save, and move, users saved website passwords for Internet Explorer/Google Chrome  AND recent file lists from Excel and Word so that they appear on the new laptops when a user opens Excel 2016 or Word 2016 ....or goes to a website that had their credentials saved (and they do not know what they are!!)  

I never realized how dependent users are on recent file lists until I began this project....or saved website passwords!!

Any help/suggestions/advice is, as always, greatly appreciated!
0
Howdy All,

Have an issue with Outlook crashing. From what i can tell it seems to be only occurring with emails that have embedded HTML images.

The issue occurs whether Outlook is running normally or in safe mode. The crashing occurs as soon as Outlook tries to load the images - so if you disable the reading pane you can use outlook, until you double click and try to open an email.

So far i've

 - Repaired Outlok
 - Removed and reinstalled office
 - Disabled all add on's in Outlook
 - Removed and recreated Outlook Profile
 - Removed and recreated Outlook PST File
 - Setup new gmail account, new PST file in a new Profile

It was also suggested that it may be related to an IE issue. IE opens without an issue, can browse and load web pages without any errors or freezing.

System Details:

Win 7 Pro
Office 2013 Home & Business
0
[Live Webinar] The Cloud Skills Gap
LVL 4
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

We have recently migrated from Exchange 2007 to Office/Exchange365. Since migration we have received a number of email rejections on one specific email indicating "your email program added invalid characters (bare line feed characters) into a message you sent".

The email itself comes from an HTML template and generated in Microsoft Dynamics AX. This is directed email to customers and is consistently accepted by some downstream providers (eg gmail, Hotmail) but not others (eg Yahoo, Comcast).

The HTML code that comprises the body text has been scrutinized and does not contain any bare LF's, nor has it changed since long before the migration.

Support from Microsoft, Yahoo and Comcast has been of little use (for the most part unwilling to engage other than throw out generalities to get you off the phone).

Key facts;
- email was working prior to (Exchange 2007 to Office365) migration
- other (text) email to affected customers is delivered without issue (ie limited to one HTML email)
- originating email has been checked for bare LF's


As this email was working previously I have the following questions;
- have you seen and resolved similar issues?
- As this was working previously I am wondering if Exchange 2007 stripped out bare LF's in order to fix (my understanding is that Office 365 was but stopped doing so).

Please do not suggest online articles found by Google searches unless you feel there is something very specific we can look at. We have searched …
0
We're migrating to Office 365 and have migrated about 75% of mailboxes.
We're not noticing that some users are still connected to the local 2010Sp2 exchange and
some are connected to the Office365 exchange.  We obviously want all connected to the cloud.
How can we change this?

Office365 Good  OffBad
0
How do i write a nested if statement for the following?

If greater than  14 but less than 16 return £10000
BUT If greater than  16 but less than 18 return £20000
AND if greater than 18 return £30000

I tried =IF(AND(C9>=14,C9<16),10000,0)
Which returns £10000 however when i try nest it, everything just returns #VALUE?


Thank you
0
Hello Experts,

I am trying to write  vba code to auto indent cells based on cell content.
Capture.PNGAsm Part: indent by 2
Operation: Indent by 3
Something like that
0
Hi,

I have an issue where my users are complaining that they are being prompted for a password when using outlook anywhere or their mobiles.  Now from what I can see, they are being prompted for a password when outlook is updating the address book, when they are out of the office (this only happens when they are out of the office).  When I check the connection status it says mail (established), mail (connecting) and directory (connecting).  Under the established mail, I have a req/fail of 140/5 and Avg Resp 118, Avg Proc 15.  

Exchange 2010, outlook client varies from 2010 - 2016.

Any help would be really great.

Cheers everyone
0
See example. How can I hide the duplicate rows so only the first one displays and the others can be displayed by clicking a + mark that would appear at the very left of the displayed row?

Duplicates Example
0

Microsoft Office

59K

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.