Microsoft Office

58K

Solutions

124

Articles & Videos

39K

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

?+1•800•592•0431 |•| CONTACT US – MICROSOFT OUTLOOK SUPPORT |•|??|V| OUTLOOK SUPPORT NUMBER |•|??|V| OULOOK SUPPORT |•|??|V| OUTLOOK CUSTOMRE SUPPORT |•|??|V|  OUTLOOK HELP |•|??|V| OUTLOOK NOT WORKING |•|??|V|


https://support.microsoft.com/en-us/contactus/

Get help with choosing a Microsoft product, or ask about a previous purchase from the online or physical store. Disability Answer Desk.

Microsoft Support - Office Support - Microsoft Office

https://support.office.com/home/contact

Contact Office Support. Please describe your issue ... Microsoft Store. Account profile • Order tracking • Store locations • Returns • Sales & support. Downloads.

|•|??|v| outlook not working, |•|??|v| outlook support number, |•|??|v| outlook customer service phone number, |•|??|v| outlook support phone number, |•|??|v| microsoft outlook phone number, |•|??|v| outlook contacts, |•|??|v| outlook support, |•|??|v| microsoft outlook help, |•|??|v| outlook help, |•|??|v| outlook customer service number, |•|??|v| outlook customer service, |•|??|v| outlook toll free number, |•|??|v| outlook email problems, |•|??|v| microsoft outlook troubleshooting, |•|??|v| outlook customer support number, |•|??|v| outlook mail help, |•|??|v| outlook email support, |•|??|v| outlook contact number, |•|??|v| microsoft outlook help desk, |•|??|v| outlook com help, |•|??|v| how to set up outlook email, |•|??|v| troubleshooting outlook, |•|??|v| contact outlook, |•|??|v| outlook problems, |•|??|v| …
0
Office 365 Training for IT Pros
LVL 2
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

|•|?? Call Us +1•800•592•0431 |v| Microsoft™ Support Number |•|??|•| Contact Microsoft™ |•|??|•| Microsoft™ Office Support |•|??|•| Microsoft™ Outlook Support |•|??|•|


Contact Us – Microsoft Support
https://support.microsoft.com/en-us/contactus/

Get help with choosing a Microsoft product, or ask about a previous purchase from the online or physical store. Disability Answer Desk. Contact Microsoft - Microsoft Support

https://support.microsoft.com/gp/contactus81?Audience=Commercial

Contact Microsoft support services by email, phone or chat. Mail address, telephone numbers and customer care for Windows and other products. Contact Microsoft Store Support.

https://support.microsoft.com/en-us/help/28808/store-contact-support

If you are seeking a customer support phone number in another country, please click the first letter of the country below. Note. If your country is not listed

|•|??|v| microsoft support number, |•|??|v| microsoft phone number, |•|??|v| microsoft number, |•|??|v| microsoft customer support number, |•|??|v| phone number for microsoft, |•|??|v| microsoft's number, |•|??|v| microsoft toll free number, |•|??|v| microsoft office tech support phone number, |•|??|v| microsoft office support phone number, |•|??|v| microsoft tech support number, |•|??|v| microsoft tech support phone number, |•|??|v| microsoft customer service number, microsoft support phone number, |•|??|v| microsoft technical support number, |•|??|v| microsoft technical support …
0
We just moved to Office 365. Some users use Outlook 2016 Volume License. Some of them are getting the attached pop-up saying Connecting to Proxy Server For <domain name> . I researched it and it said to disable a setting in File - Options - Trust Center - Trust Center Settings - Privacy - Let Office Connect .... . That does not seem to fix the issues. Any other ideas how to disable this?
0
For example if I have need call number  784

i need have 10 columns before  and 10 columns after


I THINK AN BUTTON TO CREATE THE SELECTED  NUMBER IN THIS CASE 784
DTATOWORK.xlsx
0
When I'm trying to install language pack There was a error and then MS office was uninstalled.. and then there was a massage to reinstall the office again. Why this happened? And help me to reinstall the office pls
0
EE Pros,

How do I get a Form Control to behave?   When clicked ("TRUE"), I need it to register a 1 and if "FALSE", a 0 in a helper cell.  THEN, using conditional formatting, how do I get a specific cell (IN ATTACHED WORKBOOK) to be solid black if helper cell = "1"?

Attached is a mocked up file with directions.

Thank you in advance!

B.
C--Data-X-Data-Trash-Button-Control.xlsm
0
I have a workbook that has VBA code which produces a number of active worksheets by testing for the presence of an entry in cell E10. However, I want to make that determination by the presence of an entry in any cell E10 through E25.

How do I modify the code to accomplish this task?

Function countCellAddress(cellAddress As String) As Double
Application.Volatile
For Each sht In ThisWorkbook.Sheets
    If sht.Name Like "*-JE-PG-*" Then
        If Len(sht.Range("E10").Value) > 1 Then
            countCellAddress = countCellAddress + 1
        End If
    End If
Next sht

End Function

Workbook is attached.
EE-1612-Journal-Entry-Workbook-Rev1.xlsm
0
Hello,

Can Excel VBA code designate a specific string of text from within a cell in the same way the =MID() function can extract a string of text?

For example, suppose cell B4 contains the following entry:

        The quick brown fox jumped over the lazy dog.1

And suppose that cells D4 & E4 contain the values 11 & 5 respectively. Then the formula =MID(A2,D4,E4) entered in cell G4 would return the string "brown" as shown here:

2017-06-23e_EE.PNG
2017-06-23d_EE.PNG
How could the same three cell values be captured by VBA and assigned to variables to be used further down in the code?

Thanks
0
Can we install office 2010 excel only component on full suite of office 2016? some of our excel application formulas don't work in 2016 hence require 2010 urgently.
0
hi experts,

 i have a user that got a new computer and i need to transfer his office 365 from his old to his new computer. How do I go about that?
0
Office 365 Training for Admins - 7 Day Trial
LVL 2
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

I want a button on excel to create 2 new pages, but they will just be hidden on the back end then will unhide and add information from the main page when i press the button? Is this possible?  I know there is this code if you do a checkbox:

Private Sub CheckBox1_Click()
    Sheets("Sheet1").Visible = CheckBox1.Value
End Sub

But I am having trouble doing the similar thing with a button instead. Can you help?
0
VBA: can someone help me with the code on VBA that takes a screenshot of a specific excel spreadsheet on a specific range of cells and attaches it to an email?
0
I have a folder which contains several thousand .pdf files.
I would like a program which can
1. find a file in a folder based on the file name
2. copy that file
3. paste that file to another folder

All these "source" files will be in .pdf format in a single folder.
I need it to do this in a "batch" format where you can specify several file names in a given folder and copy all those specified files over to a different folder.
I have used Excel to generate a list of the file names that I want to copy/paste.

Thanks in advance for any insight on how to accomplish this!
0
Hi all.

I have an Excel macro template that used to pull data from our old SQL Server 2000 and populate the Excel file. It would complete this task within 3 seconds.

Now, we have switched the data source to be our SQL Server 2008 server and now the same Excel file takes close to 35 seconds to populate the Excel file. The only line that has changed is the connection string line:

OLD SERVER:
strConn1 = "DRIVER=SQL Server;SERVER=myOLDServer;UID=me;APP=Microsoft Office 2007;WSID=myWork;DATABASE=myOLDDB;Trusted_Connection=Yes"

Open in new window


NEW SERVER:
strConn1 = "Provider=SQLOLEDB;Data Source=myServer;Initial Catalog=myDB;Integrated Security=SSPI;"

Open in new window


What do I have to do to make it run at the same speed as when it was pulling data from SQL Server 2000? The file only populates about 5-10 lines.

Below is the code for populating the Excel file, the connection string is for the SQL Server 2008 data source
Private Sub PopulateExcel()

Dim cnPubs1 As ADODB.Connection
Set cnPubs1 = New ADODB.Connection


Dim strConn1 As String

strConn1 = "Provider=SQLOLEDB;Data Source=myServer;Initial Catalog=myDB;Integrated Security=SSPI;"

cnPubs1.Open strConn1

Dim rsPubs1 As ADODB.Recordset
Set rsPubs1 = New ADODB.Recordset

With rsPubs1
.ActiveConnection = cnPubs1

    Dim I1
    Dim rng1 As Range
    Set rng1 = Range("B8")
    Dim strSQL1 As String

strSQL1 = "SELECT  PO2_PurchaseOrderEntryLine.ItemNumber, PO2_PurchaseOrderEntryLine.Vendor_AliasItemNumber,  

Open in new window

0
Hello,

Our help desk has received a lot of calls stating that searching in Outlook 2010 has stopped working properly. Ive tried rebuilding the index but it didnt solve the issue. I was told by others that a recent windows update caused this, does any one have more information?
0
I have this Summary tab and different supplier tabs that are linked from an access table that I need information pulled from to populate the Summary sheet.  Wanted to see if this is possible to accomplish by entering a number instead of manually entering this information.

Basically if you enter the RFQ number in cell B3 then it would pull it's corresponding row information and populate the specific cells in the summary sheet tab.  See example in the attachment.
C--Users-Luis.Freund.EXT-Desktop-Lu.xlsm
0
Hi

I have a formula in a cell ("I282") and I want to run a macro whenever the result changes. I have entered the following code in the worksheet change event:

Application.EnableEvents = False
If Target.Address = Range("I282").Address Then
MsgBox "Here"
    Range("J282").Value = Range("BD302").Value
End If
Application.EnableEvents = True

...but nothing is happening. It isn't even displaying the message box (which I inserted to make sure it was recognising the cell), when the value in the cell changes.

If I change the target cell to a cell without a formula in it, and change the value of this cell it works fine.

Any thoughts?

Regards

Terry
0
How would i upload and retrieve multiple images/files of an individual in a database. for example one can upload five (5)  images/files to MR. A and 3 Images/files to Mr. B and then how would i retrieve the Images/files individually using the Mr. A or Mr. B ID as Key Using Userform in Excel VBA
0
Dear Experts,
I created a pivot table based on two sheets data. Both sheets data is connected with a unique column data by creating relationship. The data displayed based on the relationship created is great.

When I tried to use "Show Report Filter Pages" to create multiple worksheets, I observed that the option is greyed out (even after placing one of the fields under report filters).

I observed that if the pivot is based on a single sheet data, "Show Report Filter Pages" option is available.

Am I doing any mistake? or Is there any other way to use this option when I create pivot table with two different data sheets?

Thanks in advance.
0
Enroll in June's Course of the Month
LVL 8
Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Hi All i have this excel sheet which have these post codes in column G.

You can see there are drop numbers in column B for them, but if you go down to the bottom there are some which are not slotted in there right position.

how can i slot them in to the correct position in above list.

all i want is all post code starting with there initial 4 character slot in to there corresponding slots and once there are in i can assign them the drop sequence.

Please help

Thanks
0
Hi

I can't install Microsoft Office 2010 update kb2553347.
I got this error 0x80070663.

I have not problems with other updates.

PC: Win7 64-bit

Any suggestion?
0
When I try and edit headers and footers in word, as soon as I move the mouse or try to save the change, the cursor bounces back into the doc body without even the footer change remaining. After several attempts, I can successfully make the change. Once I attempt to make another on a different page the same thing happens.

In addition, the header/footer controls don't seem to work consistently.
0
I had this question after viewing Set font smaller and allow box to expand.

Assistance is greatly appreciated.
0
Hi all

 I'm hoping you can offer some advice please!! I have googled as much as I can to get to this point. I have a workbook, and I would like some coding that identifies if a contract is a "Contract - Framework" AND has a status of "Contract Awarded" on the "Procurement Tracker" tab. I would then like the relevant rows that meet this criteria to be copied over to another tab called "Live Contracts" and hidden on the original Procurement Tracker tab.

 This is the formula I have so far that will move the rows that meet the "Contract - Framework" criteria, I would just like to know how to amend it so that the row meets both conditions;

 
Sub ReqToLive()
 Dim xRg As Range
 Dim xCell As Range
 Dim I As Long
 Dim J As Long
 I = Worksheets("Procurement Tracker").UsedRange.Rows.Count
 J = Worksheets("Live Contracts").UsedRange.Rows.Count
 If J = 1 Then
 If Application.WorksheetFunction.CountA(Worksheets("Live Contracts").UsedRange) = 0 Then J = 0
 End If
 Set xRg = Worksheets("Procurement Tracker").Range("F1:F" & I)
 On Error Resume Next
 Application.ScreenUpdating = False
 For Each xCell In xRg
 If CStr(xCell.Value) = "Contract - Framework" Then
 xCell.EntireRow.Copy Destination:=Worksheets("Live Contracts").Range("A" & J + 1)
 xCell.EntireRow.Hidden = True
 J = J + 1
 End If
 Next
 Application.ScreenUpdating = True
 End Sub

Open in new window

Hope that makes sense! Thanks in advance
 Amy
0
I have an excel sheet. One column has company names and another column has company 1 line description, there is multiple description entries (of different types) for same company. So, company ABC is repeated 10 times in column A with 10 corresponding different descriptions in column B, then company PQR is repeated 16 times in column A with 16 corresponding different descriptions in column B (after company ABC's entry).

Out come needed : Find all the unique words for company ABC from all the description lines corresponding to Company ABC and display count of every unique word for Company ABC ( e.g. "good" : 5 times , "the" :10 times , "big" : 7 times etc). And similarly for company PQR and other companies in the sheet.
0

Microsoft Office

58K

Solutions

124

Articles & Videos

39K

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.