Go Premium for a chance to win a PS4. Enter to Win

x

Microsoft Office

61K

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,
Is it possible to increase the font size on the formula bar without affecting the cells font size  ?
If so how ?
Thanks
Ian
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: 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!

how can I change the format of the attached sheet 1 to sheet 2

Regards,

Dallag
Change_Sheet1_Sheet2.xlsx
0
If you look at the Orography tab in the attached file there is a graph. The blue line represents a hill or ridge. The dots represent the position of a scaffold on the hill. On the left is the upwind side and there is an orange line. If the scaffold is above this line then it is affected by the terrain and a set of equations need to be checked. I want to shade above the line. On the right is the downwind side. I want to shade below the grey line down to blue. I can introduce dummy nodes to place a node on the blue line directly under the grey line node. I can do the same the other side at 0,900. I cannot find how to shade these areas?
graph.xlsx
0
Dear Experts,

Please guide me on Following Formula in Countif. i have Range Range A1:A5 = "F" and B1:B5 = "M and Criteria is at C1 = "FM" i am Using Formula Countif(A1:A5&B1:B5,C1) ans must be 5 but not working with Single enter or Array Formula Ctrl+Shif+Enter Please guide how to figure it out.

Regards,
0
Column A contains the New ID number.
Column B contains the Old ID number.

In many cases, there are several New ID numbers for one repeated Old ID number.
And several repeated Old ID number for one New ID number.

There are a several long lists of Old ID from different files that need to be matched to New ID.

The concept is that a list of Old ID could be pasted into Column F, and  column E could repeat the same Old ID as often as it appears in Column B with the matching New ID from Column A, shown in column D - manual example shown in file.

Hope this makes sense.
Example-Old-ID-match-New-ID.xlsx
0
I ran Produkey64 and Belarc and got license keys for Office 2010 on my W7...
I installed W10 on top of W7 and W10 activated...BUT most everything was not working correctly...
W10 was messed up BUT it did activate...

Then I put in a NEW hd and did a fresh install of W10 and it activated...started re-installing all my applications...

Then I installed Office 2010 and using the key from my W7 PC it will NOT activate...
It will not activate on the internet nor by phone...I think phone activation on 2010 is not available...
I also have the key that is in the retail box and tried it...no joy...

Suggestions please...

If I go to change product key and enter my old key...I get "Sorry this isn't a Microsoft office 2010 ...you  may be entering a key from another version of office...

So...I uninstalled Office 2010 and tried another CD with a different key...and that will not activate either...
0
so when I installed office 2016 it had my registered to activate the keys right. well when the users use office the programs shows as me being singed in. Is there a way to change it to the company name I did the work for? also they are saying that they are all linked together – so any design/color scheme changes made by one of us changes the color scheme on all our computers.

??
0
Hello,

This is a follow-up question to a previous thread located here:

Auto-fill a cell's color based on numeric RGB values and vice versa in Excel

In that thread, the solution (by Ejgil Hedegaard) includes an attached Excel file in which the fill color of a particular cell, automatically changes in response to entering various values in three other cells labeled R (red), G (green), & B (blue).

This functionality is tremendously useful for me (and I suspect will be for others) because it enables you to instantly view the new color resulting from changes in any of the RGB parameters (ie without the necessity of the four clicks typically required to obtain that information):

        Home > Fill Color > More Colors > Custom

(The file also includes a chart for quickly converting from RGB decimal to RGB hex and vice versa.)

Additionally, the solution to the thread contains the formula for calculating Excel's color code:

        ExcelColor = R + G *256 + B *256^2

For example:

        Red = 204
        Green = 102
        Blue = 255

is calculated as follows:

        ExcelColor = 204 + (102*256) + (255*256^2)
        ExcelColor = 16737996

It also displays the following for reversing the process (ie :

        R = C Mod 256
        G = C \ 256 Mod 256
        B = C \ 256^2 Mod 256

Are these three formulas math or code and what is the purpose of the backslash?
0
i have 2 question;

1. if i want to use SSO for internal user on my company network against Office 365 resource do i need to use WAP obviously ? because otherwise how ADFS will know that users coming from internal or external ?

2. Can i publish two different URL through one WAP ? one for ADFS other for AD RMS but both use 443...how to achive this ?
thank you.
0
I have a list of PST files in Excel (with their full path)

a VBA running within excel would  open each PST file (load it) into Outlook and then count the items in each folder and close it.
It would then write in a cell the information for the PST and proceed with the others, until exhaust the list.

At least for now,  I need just a hint on how access the current outlook session (I now how to start a new one from Excel, but it would much more efficient to use an already open instance of Outlook)
0
Get free NFR key for Veeam Availability Suite 9.5
LVL 1
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Hello,

At our office we use one shared office email address and are receiving e-mails to 10 locations via Outlook 2007. The last few months email are not showing up on on every desktop (for many years they did). I have reconfirmed they all have "leave a copy of messages on server" checked.

We are not against upgrading versions but it's a large expenditure and we would only do that if we were sure that solves the problem.

Separating the emails (one per station) is not a viable option since everyone check the general email box.

Any ideas?
0
Error received from VB when I submit my codeSnippet of the linked Excel tables I need to update in AccessError received from VB when I submit my codeGood day to all! I am literally at wit's end with attempting to create a VBA code that works to update linked Excel linked tables in Access. Let me provide some background. Attached is a screenshot of just SOME of the linked Excel tables in Access that I need to create a new field for. There are a total of 40 Groups and at 11 SELECT tables per group, you do the math that is A LOT of tables to update manually (440= 11 x 40), that is not only cumbersome, but it is painful! There has to be a more automated way!

Naturally, I would have submitted an ALTER command with ADD Column, and be done with it! But as you may know, in Access 2002, MS took away the benefit to modify linked Excel tables. So that door closed on me.

I have turned to VBA. Not that great at it, SQL is more my thing, but apparently there is literature out there to perform such task, the one I am trying to do via VBA. And as I am getting more exposed to VBA, I am getting the gist of it. I believe I created a VBA code that will do the job (see below), but when I perform the VBA, I get  Run-time error '2147217900 (8004e14):
Syntax error in ALTER TABLE statement.
Now what am I doing wrong? Can someone please help? Further, once this problem is involved, can someone please show me how to do mass ALTER TABLE statements within VBA, please? That way I can get through this painstaking task? :-( In SQL, I would have been able to do the mass statements …
0
Currently we have a client who is essentially using Office 365 purely for the Office licences rather than for email. They just put in an on-premise Exchange 2016 server over the summer but one of the users would like to be able to use Skype for Business online but have it synchronize with her local Exchange profile for contacts.

Their Office 365 is currently still setup with a *****@*****.onmicrosoft.com account as they don't route email or anything else through it. It doesn't really make sense to me to hybridize the deployment as it is literally only one user who would ever use the Skype service, and they have no intentions in the foreseeable future to have any sort of mail delivery performed to Office 365.

What I'm wondering is if there is another way to have continuous synchronization of her contacts between the Office 365 account and her local account? And if the only option is to hybridize the deployment, can this be done to only allow for Skype for Business not email?
0
I am the Office 365 administrator.

What steps need to be followed to record all Office 365 Skype for Business instant message chat conversations?
0
Need OOO to work for my user accounts when they are disabled. How can I do this?

Running Exchange 2013 On Premise
0
I have some old files in MS Word. To open them, I'm required to provide a password. How do I do this to files created in Win 10?  Also, how do I created a password to gain access into the computer (i.e. after it boots up, but before going into windows?)
0
I have installed Office 2016 on a new Dell laptop and Outlook is giving me a problem
Basically the Inbox is not updating, all other folders and contacts are updating even the Deleted folder updates, the Inbox shows the number of unread messages and that is how i know they are getting through, if i do a search of the Inbox I can see the emails that it finds based on the search.

The account is a Domain account from an Exchange Server 2010, Office 2016 Pro

The email account is 5 years old

The emails are being received on the old laptop, tablet and phone

I have checked View - filters, Started it in safe, deleted the OST file and reinstalled Office

The error showing in sync is:

Task 'Email removed for privacy' reported error (0x00040820) : 'Errors in background synchronization. In most cases, further information is available in a synchronization log in the Sync Issues folder.'

The synchronization Log shows:

15:27:40 Synchronizer Version 16.0.8625
15:27:40 Synchronizing Mailbox 'Email removed for privacy'
15:27:40 Synchronizing server changes in folder 'Inbox'
15:27:40 Downloading from server 'dc-Server name removed for privacy'
15:27:40 SyncMonitor triggered for Inbox (0x80004005)
15:27:40 Error synchronizing folder
15:27:40                  [80004005-501-FFFFFC06-560]
15:27:40                  The client operation failed.
15:27:40                  Microsoft Exchange Information Store
15:27:40                  For more information on this failure,…
0
I need to extract data from a table on a web page but i don't know what to call it. I inherited a workbook which does this for another site and identifies the table as "1". Please take a look at this page and let me know if possible what to call the Activity Log table (about halfway down the page). Ideally I want to retrieve the data under PAST FLIGHTS.

"http://flightaware.com/live/flight/A6ETA"

.WebSelectionType = xlSpecifiedTables
.WebTables = "1"

Open in new window


Thanks!

John
0
I have a local server with a shared directory that users use when they are in the office.  I would like to somehow sync that directory to Sharepoint online or one drive for business.  My users all have Office 365 accounts.  i would like them to have access to the files on the local server when they are out of the office.  what is the best way to accomplish this?
0
NFR key for Veeam Backup for Microsoft Office 365
LVL 1
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Over the past year, I have purchased MS Visio 4 different times using Volume Licensing Services.

When I look in the Volume Licensing Services website, it shows that each of the keys has 50 activations available.

A couple of the purchases were for multiple users.

How do I track if I still have licenses available?, since my understanding is:

1) The same user can install MS Visio on both their laptop and desktop and only require one seat.
2) The totals are activations and not users. So If I purchase a new computer for a user, and install the same key on their new computer, it now shows as a 2nd activation even though only 1 license is required.

For example, one purchase was for 2 user licenses. I can see that the activation count is 2, but is that a laptop and desktop for the same user or 2 separate user installs.
1
I'm developing an Excel file for data entry by users.  The file has 12 tabs.  The data entry area in each tab is no larger than one page.  So, if I was to print the entire file, it would be 12 pages long.

I'm trying to figure out a way to force the users to select the month the data pertains to and have the month appear in the center header of each sheet.  Multiple months across the tabs cannot be used.  The month must be the same on each sheet.

I'm not trying to insert the current month but rather a selected month.   For example, the users may need to generate a report for say, July, 2017.   I want the users to be able to open the file and be forced somewhere along the line (possibly before being able to print or save) to select the month the data pertains to.

Basically there are 2 or 3 users involved; each sharing the file (in sequence, not concurrently) and each responsible for a few of the tabs in the file.   If the first user selects a month, then if all tabs are populated with that selected month, that would be fine.  Or, maybe each user goes through the process of selecting the month but the program looks at the month selected by earlier users and prevents an alternate month from being selected.

Any ideas?  Thanks.
0
In the past 3 weeks, user's have received attachments from their email accounts and/or company drives which have not allowed them to open the attachments in Word, Excel and PowerPoint.  The current work around is to open the application, file, options, trust center, trust center settings, protective view and remove the check marks from all 3 boxes.  This was not an issue before but just started.  Any input on what might have caused this change or why it's occurring now?
1
Need a macro to review a range of cells and delete any with dates older than 12 months.   (And shift cells left on the row when one is deleted.)   Thanks!
0
Hello,
I want to pull some data from excel sheet and paste in powerpoint. I am using below code but I am getting automation error library not registered.
Dim powerpointapp As PowerPoint.Application
Dim mypresentation As PowerPoint.Presentation
Dim myslide As PowerPoint.Slide
Dim myshape As PowerPoint.Shape
Dim mytextbox As PowerPoint.Shape
Dim xlApp As Object
Dim xlWrkBook As Object
Dim lCurrSlide As Long
Dim rng As Range
Dim rng1 As Range
Dim shptext As String
Dim rng2 As Range
Set mypresentation = ActivePresentation
Set myslide = mypresentation.Slides(1)
'To copy the pivot chart from excel

    Set xlApp = CreateObject("Excel.Application")
 
            ' Open the Excel workbook
   
            Set xlWrkBook = xlApp.Workbooks.Open("\c:\Automatic dashboard utility\demo\demosheet.xlsm")
Set rng2 = xlWrkBook.worksheetd(1).Range(Range("Q9"), Range("Q9").End(xlLeft))
rng2.Copy
Set mytextbox = myslide.Shapes.AddTextbox(msoTextOrientationHorizontal, Left:=429.12, Top:=261.36, Width:=272.88, Height:=19.44)
With mytextbox.TextFrame.TextRange
.Paste
.Font.Size = 9
.Font.Name = "arial"
End With
 xlWrkBook.Close (False)
    xlApp.Quit

   
            Set xlApp = Nothing
    Set xlWrkBook = Nothing
   
Please help me out. Thanks in advance
0
I need to exclude Night hours (19:00:00 to 09:00:00) for all week days like (Sat & Sun should be included)
0

Microsoft Office

61K

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.