Articles & Videos
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.
Dear sir , i have a code, where it contains data , i need last updated time in a cell , so i have a formula, where it extracts date and time like this 23-FEB-2017 15:30:29 in one cell , but i need …
1. What is the best way to re-number column No (A) from 1 to visible rows please
2. e.g if I apply filter on Group1 with Yes rows. As it is now. in the sample file attached.
3. How to make…
could you help with attached sample excel and how to achieve this please?
1. How to get Final Column (G) the Consolidated result using formula please?
2. If any one of the group…
Curious if someone has a macro that will capture and notate ALL changes made to a workbook and then email out out those changes made to an email address or distribution list? For …
Does anyone know how to run PROPER (Propercase) on an entire Worksheet in Excel (Does ALL columns)?
I found the below code and it works, but it adds extra space to the column height. How can I remove the extra space?
I am working on Microsoft word document with bunch of screenshots like log file dark screenshots with data. I like highlight a one of screenshot data with different color or or arrow or some …
I am attempting unsuccessfully to format data in Excel as a table from Access. I was hoping someone could tell me what I'm doing wrong:
I have data in a spreadsheet that is exported from a guest Wi-Fi system. Users are required to enter a name and email address, or use a social media account to use the free Wi-Fi. That …
I'm struggling to hide a range of columns in another worksheet. The closest I've got is this code but that only hides them on the sheet I'm on:
Private Sub Test2()
Dim sws As Worksheet, dws As …
I have an Excel 2007 workbook with macros in it. When I open the workbook I get the following prompt.
What I can't understand is the second message asking about links to another workbook …
I cannot unhide columns, D, E, F, to the attached file. Why?
I have a csv file that only has data in column A. I have an excel workbook that I copy column A from the CSV to this excel workbook that I use to populate a mailing list. Problem is right now I am …
Hi guys what am i doing wrong? I get an error when trying to open the saved file again
this is the error i get:
this is the code:
I have a powerpoint with shapes that are linked to an excel file. Lets assume that the link is pointing at a range in a sheet:
When I insert a row on that Excel …
Trying to achieve this: Whenever helpdesk sends out an email to any user, the email displays at font: 16, colour: red and bolded.
To do this for 1000+ users in the org I imagine this could be done …
I have a document in Word 2013 (a book) which I already paginated. The page numbers appear at the bottom left and bottom right (alternate) of the pages. I now want to simplify this and place ALL …
I work on microsoft word daily. what are cool short cuts and tips on using ms word.
i have like 50 page document i go forward and backward and modify it.
any shortcut to move to top page …
I have a basic spread sheet. I have attached a sample.
I would like to sum column c if column b has the word "Swings" in it AND the date in column a is between 1-1-2017 and 1-31-2017
I cant …
Is there a process of creating an installer of Microsoft Office for Mac 2016 that you can install that will bypass signing into your Microsoft account and a way to insert an activation code into the …
I have a user that uses the same file repeatedly and only changes the text. She set custom margins according to the width of a border on the paper she prints on to. There are times she will open the …
I have a small business client running Exchange 2007. They're about six months from going to Office 365. They purchased a new desktop PC which came with Office 2016. Outlook 2016 is not …
Hello, I am trying to configure email with a user on a new laptop.
The laptop had Office 365 on it
Then Office 2010 was added with outlook 2010
Then I had copied a profile over and and remove …
I need some quick help again,
bmName is a variable that loops through Bookmarks, and I need to check that when bookmark "side1" or when bookmark "side2" is bmName then it should do …
I recently installed Microsoft Office 2013 on a new computer and was disappointed to discover that Microsoft Office Picture Manager is not included in Office 2013. This article explains how to corre…
Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dic…
Walvis Bay, Erongo, Namibia
7,664 points this week
Joe Winograd, EE MVE
Greater Chicago Area, United States
7,469 points this week
Chesterfield, United Kingdom
4,668 points this week
Subodh Tiwari (Neeraj)
Kanpur University, Uttar Pradesh, India
4,600 points this week
3,168 points this week