Microsoft Office

67K

Solutions

42K

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

I found this code from expert exchange for my project which required similar function . The code below which basically compares two sheets , and unique records from sheet ( Interface ) to Sheet ( Steps ). It takes more than 20 minutes to execute them . I want to execute this code in a min duration .
Option Explicit

Function UpdateOLD() As Long
'     This Sub will do the Following Update
'     Run through all records in OLD
'        if found in Interface  ---> Do nothing
'        if not found in Interface ----> Delete it from Steps.
Application.ScreenUpdating = False
Dim Rng As Range
Dim WSO As Worksheet
Dim WSN As Worksheet
Dim MaxRowO As Long, MaxRowN As Long, I As Long, J As Long, lDel As Long
Dim sJob As String, sOps As String, sFirstAddress As String
Dim cCell As Range
Dim bNotFound As Boolean


'---> Disable Events
With Application
    .EnableEvents = False
    .DisplayAlerts = False
    .ScreenUpdating = False
End With

'---> Set Variables
Set WSO = Sheets("Steps")
Set WSN = Sheets("Interface")
MaxRowO = WSO.Range("A" & WSO.Rows.Count).End(xlUp).Row
MaxRowN = WSN.Range("C" & WSN.Rows.Count).End(xlUp).Row
WSO.Range("N2:N" & MaxRowO).ClearContents

'---> Loop thruough all rows in sheet New
For I = 2 To MaxRowO
    bNotFound = False
    sJob = WSO.Cells(I, "B")
    sOps = WSO.Cells(I, "C")
    Set cCell = WSN.Range("D6:D" & MaxRowN).Find(what:=sJob, LookIn:=xlValues, lookat:=xlWhole, MatchCase:=False)
    If Not cCell Is Nothing Then
        bNotFound = True
      

Open in new window

0
HTML5 and CSS3 Fundamentals
LVL 13
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Hello,

I have just reformatted my laptop, and re installed MS Office 2013 (Licensed).

Most of the times that I click on Reply or New email, I get the attached runtime error.

What do I do?

Thanks,Outlook Error
0
Have a computer outside of the netowork that uses Sonicwall Global VPN client to connect to network.  There is an excel file they edit that is on a file server in the office they are connecting to.  The internet service is 15MB down and 1.5MB UP.  When saving changes on the excel file (not locally but on the remote sever) would the terrible upload speed affect the time it takes to save after many changes are made?
0
I am trying to deploy Office 365 click to run, but cannot seem to get it correctly?

I have used the office deployment tool and run the setup.exe /configure configuration.xml command, but I still do not seem to have a click to run version installed

I've attached the registry key that should contain HKEY_LOCAL_MACHINE\Software\Microsoft\Office\15.0\Common\InstallRoot\Virtual\VirtualOutlook

But the Virtual Outlook key is missing?

What am I doing wrong?

Here is the content of my xml file

<Configuration>

  <Add OfficeClientEdition="32" Channel="Monthly">
    <Product ID="O365ProPlusRetail">
      <Language ID="en-us" />
    </Product>
  </Add>

</Configuration>
Capture.PNG
0
I am currently working on a project where I need to compare two sheets ( Sheet1 and Sheet2 ) . Records from Sheet2 to  need be compared to sheet1 . Records which do have a match in sheet2 should be copied to new sheet ( Sheet3) . Each Sheet has  around 15 columns ( Each Sheets starts from A2 ) , so I wanted to use VBScript Dictionaries mainly to increase the execution time ,  I want to avoid copy and paste functions . If that was achievable , it could great but I am open to using other options in excl vba to achieve the results .If experts could help in achieving results . It would be greatly helpful.
0
Hi

I have a workbook of which has data in sheets 1 & 2 and im trying to compare the two to look for missing data.

Data will be in columns A-D in both sheets . What im trying to do is look in sheet 1 and try and match up with what in sheet 2.
Where its a match in sheets 1&2 I want to put in column E in sheet 1 as OK and if there is no match I want it put as MISSING in column E.

Issues I have are that although the data may all be there in sheets 1 & 2 they will not be in the same row on both sheets.  I.E data may be in row 14 in sheet 1 and the same in row 99 on sheet 2 so I need it to look all the way down sheet 2 to verify.
Other issues are that in in column C on both sheets there may be times when the date is different. I.E in sheet 1 may be shown as 24/04/2019 and in sheet 2 may be 24 Apr 19. Is there anyway that I can overcome this.


Can this this be done via macro or some other way as I have over 1000 entries on both sheets.

Thanks in advance
0
office 2013 keeps crashing.  I have done the repair in programs and features.  Are there any other things I can do to fix the issue or are there any free or paid software I could run on the installation to get it to work?
0
I have office proplus 365  installed through shared computer activation

when there is update from 365 side, users get lot of  outlook addin prompts  ( attached)

why so many prompts come  and secondly can we control updates from active directory
Capture.PNG
0
My OS is win 7 64 bit and have Office 365 and use Outlook.  Somehow outlook is showing emails from 2017 and earlier.   How do I fix it to display only > 2018.  thank u
0
Hello,

One of my clients wants to downgrade office 365 E3 licence to Office 365 Business(premium and essentials) and F1

What is the procedure?

Does Office need to be reinstalled on every workstation?

https://www.reddit.com/r/Office365/comments/56ww4l/i_little_gotcha_moment_i_had_with_a_small_client/

Any other things to consider?

Is there any Microsoft „how to“?

Thank you
0
Angular Fundamentals
LVL 13
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Hi,
I have an .xml file and I want to open it with excel, if I open it with excel it doesn't do anything, if I go to more programs and select excel either. On the other hand, if I open the excel and look for the document it opens. I repaired Office and desactivated DDE.
Any solution?
Thank you.
0
I use Office365, local installation on my laptop.
I have Onedrive hyperlinks in an Excel-sheet.
Before, when I clicked on the hyperlink, the file was openend by my locally installed Excel version.
Now suddenly this doesn't work anymore, when I click the hyperlink it is openend by Excel online...???

Has MS changed something or am I missing a certain option??

thanks in advance,
Peter
0
Hi

All the office 2016 documents from outlook, excel, word opening as Read-only and am not able to save or edit.
Can someone pls help to resolve this?
0
I need to disable the Office 365 security warning message while running MS Access.

I already created a trusted location and this works well for all of my linked tables.

One line of code, however causes the security message to pop up even if the location is trusted.

The code is:

DoCmd.TransferDatabase acExport, "Microsoft Access", "//" & stFileServerComputerName & "/Export/EmployeeRoster.mdb", , "tblEmployeeBasicExportFile", "EmployeeRosterBasic"

with stFileServerComputerName = to MyComputer

//Mycomputer/Export/ is a trusted location.

The message A potential security violation has been indentified: //Mycomputer/Export/EmployeeRoster.mdb  (yes, the allow subdirectories box is checked)

Can anyone help?  Thanks
0
We have an Exchange 2010 Hybrid Configuration.  When we Create a new user on-premise, we then have to migrate that user to the Exchange on-line.  I would like to skip that step and just create users in Exchange On-Online.

Reading though all of the Documentation it has a Variety of ways to Tie On-Premise AD to Azure AD.   We have 8 Office Locations each with their own AD Server. We would like to keep the Local AD, though we would like to have Azure AD too and not have to Create users on-Premise then migrate them.

What are the options for this?  We have under 130 users total. Most all of the remote sales office Sites use HQ's Internet Connection to get out. HQ also has the on-premise Exchange and the AD-Cloud Connect server.

I'm also looking forward to having Exchange-Online Groups so the EO Users can modify the group membership.

If I could get the nickel Tour of the Process that would give me a better place to look for more info.

Thanks!
0
Word file shows Page 3, 3, 5, 6 & 7. No matter what I do, I cannot seem to correct the page numbering sequence. No offense to the people at Microsoft, but when all else seems to fail, there should be some function that just lets you override the page number and implicitly put the page number you reference.  Of course, that would be too simple.
File is attached.
Johnson--John-Q---Jane-S---181231--.docm
0
Calendar from Android phone using built-in Calendar app stops syncing to Office 365 mailbox and vice versa. Email syncs fine.

When I remove the account and re-add it, it works for a while but then fails to sync again.
0
Greetings Experts,

I have a workbook called Book1 and I am trying to transfer data from other workbooks into this workbook.

This is what I am trying to do
Step 1: The user will select the file they want the data to be extracted from
Step 2: The VBA will copy the name of the file and paste it into Book 1's Cell C5
Step 3: The VBA will look at the selected workbook's "Step 3-Final Forecasts" tab and copy cell F61 to cell F72. After that, it will paste the values(transposed) into Book 1's cell C5.

I am also trying to make the code able to handle multiple excel files and will just paste the values into the next available row in Book1. This is what I have for now:
Sub DataExtraction()
Dim Book1 As Workbook
Dim Book1TabName As Worksheet, ExtractFileTabName As Worksheet

Application.ScreenUpdating = False
Application.DisplayAlerts = False

Set swb = ThisWorkbook
Set ExtractFileTabName = swb.Worksheets("Step 1 - Trending")
Set wsList = swb.Worksheets("SKU List")

With Application.FileDialog(msoFileDialogFolderPicker)
    .Title = "Select Folders to Extract Data!"
    .ButtonName = "Confirm"
        MsgBox "You didn't select any Folder to save the Forecast Files", vbCritical
        Exit Sub
    End If
End With


Application.DisplayAlerts = True
Application.ScreenUpdating = True
MsgBox "Task completed!", vbInformation
End Sub

Open in new window


File where data will be centralized:
Book1.xlsm

Files where data will be extracted:
V11H670052---EB-536Wi.xlsx
V11H726052---EB-1460Ui.xlsx
V11H746052---EB-680.xlsx

Any help is much appreciated! :)
0
Yes
0
OWASP: Threats Fundamentals
LVL 13
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

We have recently upgraded from Office 2016 to Office 365.  Since the upgrade Powerview in Excel has stopped working.  Settings are enabled, Powerview Com -AddIn is also enabled as in Office 2016,  Silverlight is downloaded.
Powerview.JPG
0
Using vba, how would I filter a bunch of columns by the same color?  If a row has a yellow cell fill, show it. (I have 10+ columns)  I was thinking about using the code below on each column, with some sort of And statement?   Just do not want to have to do this on every column to get the all the rows that have the yellow cell fill.  Any ideas?

Also, this range is dynamic so I was going to select the range first using:
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select

Open in new window


    ActiveSheet.Range("$A$3:$AR$649").AutoFilter Field:=2, Criteria1:=RGB(255, _
        255, 0), Operator:=xlFilterCellColor

Open in new window

0
We have a user that consistently gets locked out. Sometimes multiple times a day. We are using MS Office 365 with Active Directory (Hybrid). We are using the MFA in Office 365 and we have a Radius Server as well. We thought it might be Skype for Business but I changed the App-Password, logged out an back in, and that is working fine. We have cleared the users credential manager several times. Any leads you can give us would be greatly appreciated.

Thanks,
Joe
0
I've been looking for an iOS app that will allow a user to view multiple/shared calendars on our hosted exchange server.  I've been unsuccessful in finding a solution.
I know that Microsoft Office 365 Exchange Online allows users to view multiple calendars (shared calendars) on the Outlook app, but we are using AppRiver to host our exchange mailboxes and need another solution.

Thanks
0
Hello,
everytime, I want to put my e-mail in Mirosoft Outlook. I get this message.

Unbenannt.PNG
The e-mail and password are correct. I have changed my security settings but this didn't solve my problem.
0
What can prevent the PowerPoint executable from closing via task manager?
0

Microsoft Office

67K

Solutions

42K

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.