Microsoft Office

66K

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

Hello,

I am using GoDaddy. And I use outlook office 365 to read my email. The limitation I have is that outlook shows only the last 30 days of email received.

How can I change that please?  I would like to see the last 6 months of email received

Can someone send me step by step how to change this?

Thank you
0
Price Your IT Services for Profit
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

Hi Experts

Hope you can help

I’ve already received some expert assistance on this workbook but unfortunately am having trouble with the criteria set up on the Conditional Formatting

The main issue is that the sheet titled Results Costs looks at the Data tab - Columns R to T. A lookup in the conditional formatting on the Results Costs sheet should return the appropriate colour based on the value in column T on the Data Tab against the corresponding location (eg. 01_01 has a value of –£241.60 therefore the location cell on the Results Cost sheet should be red)

However, as you can see in the example, the cell containing 01_01 location on the Results Cost sheet (cell A21) is an orange colour instead of red (value less than -100)

Ive tried to amend the criteria against the conditional formatting however it does not seem to work as well as trying (unsuccessfully) to include an IF AND logic that I could not get to respond

Any help would appreciated with this as Im completely flummoxed

Regards
J
Copy-of-Copy-of-Cycle-count-pick-fa.xlsm
0
Want to create an Excel macro that will take someone to the desired sheet by using the contents copied into the clipboard, but I have two problems:
1. When I run the macro below, I get a "Compile Error:  User-defined type not defined" on the first line.  The help reference didn't help (https://docs.microsoft.com/en-us/office/vba/Language/How-to/user-defined-type-not-defined).
2. When I tried to save the macro, it said that in order to save it with a VB Project, I needed to "choose a macro-enabled file type in the File Type list, but I couldn't find the File Type list under any of the menus and couldn't find it in Excel Help.  Thanks.

Dim DataObj As New MSForms.DataObject
Dim myString
DataObj.GetFromClipboard
myString = DataObj.GetText
   
Sheets(myString).Select
    Range("A1").Select
0
Excel - Strike through not working again????

Cannot understand why this is not working.
StrikeThrough.xlsm
0
Dear Experts:

I would like to run a macro on the active worksheet with the following requirements:

If ALL of the rows 23 to 541 are hidden in the current worksheet, the macro has to say so in a msgbox and the macro is to exit.
If any number of the rows 23 to 541 are not hidden (it may be just one, or two etc. that are not hidden in that range) the macro is to call up a macro called 'Copy_Cells'

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
0
I have, in our office LAN, a  DELL Inspiron 14r laptop with Windows 10 and Office 365 installed. User of this PC wants to eliminate Outlook from the Office Suite. I have successfully installed MaliBird Lite and user is happy. Now user wants Outlook removed or at least deactivated. My search of the Internet has not yet found a solution that applies to the version (?) of Office 365 we have. Seems the only option from control Panel is removal of MS Office, not individual components.

How can I accomplish this removal/deactivation of Outlook?
0
Excel - strike through issue   VBA and or  formula  not working ???

Please see attachment and explain why the formula is not working.
StrikeThroughIssue.xlsm
0
Hi Experts,

Just wanted to get some advice. We're an o365 E3 license holder, who pretty much use all the functionality of o365 online with the exception of Exchange. For reasons I shall not bore you with, we still run an on prem Exchange 2016 environment, along with a local AD syncing via AAD Connect.

My question is as follows. Is there a simple way to intergrate Exchange 2016 on prem with the Office 365 tenant without migrating, so that when people are working via www.office.com, they can access email, sharepoint etc through the single pane of glass view (aka - for the end user, they are non the wiser that they are accessing Exchange on prem, SharePoint Online). I've read conflicting posts as to what is possible.

If you have any thoughts, or can point me to some good posts, I would really appreciate it.

Many thanks,

Rob
0
Dear Experts:


I would like to check if the 'Wss' Worksheet's used range has data, i.e. the worksheet is blank or not ...

The macro however should only check the visible cells, because there are thousands of hidden rows which contain data.  

If all of the visible cells are blank (again, the invisible / hidden cells are not to be considered) the macro is to say so and the macro is to exit

Help is much appreciated. Thank you very much in advance.

Regards, Andreas



Sub Check_For_Blank_Cells_in_Visible_Cells_Only

Dim Wss As Worksheet
Dim i As Integer

Set Wss = ThisWorkbook.Worksheets("Customized_Choice")


End Sub
0
I have an excel Macro that I have been running on Windows 7 for years without a problem. I recently updated to Windows 10.
Every time I run the macro now I get the Error 1004.

Below I put the VbScript that it does not like.
Any ideas how to fix this problem?

Thanks...
RIck

Error 1004
Method SaveAs of Object   Workbook failed

ActiveWorkbook.SaveAs Filename:= _
        "M:\IT\Macros\ESCOffTheShelf\Web-ESCUploadInventory1.xlsx", FileFormat:= _
        xlOpenXMLWorkbook, CreateBackup:=False
0
C++ 11 Fundamentals
LVL 13
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Excel - Lowest and Highest

I have a sheet with tag numbers in column A on tab1 - column P  is the a number
Each tag may exist multiple time with different numbers in column P
Column A (tag number)   Column P (number)
123456                                        8760
123456                                       35040
123456                                         4380
123456                                         8760
123456                                       35040
123456                                         4380
123456                                         8760

On tab2, I have a list of unique tag numbers and I need to pull the lowest and highest number for each tag number
Column A (tag number)    Column B Lowest     Column C Highest
123456                                           4380                                35040
0
I need help with a function that will filter a two dimensional VBA array based on some criteria and store the filtered elements into a new array.
What I need would be clear from the code included.
As you would note I am running a loop to filter a startingArray and storing the matching elements in filteredArray.
The code I have posted works but in this case I was able to ReDim filteredArray(1 To 3, 1 To 3) As Variant because I knew how many elements I would get in the filtered array (in this case 3). In a real scenario I would not be able to do this because I would not know in advance in how many elements in my starting array would match the filtering criteria.
I would appreciate your help in the correct way of doing this.

Private Sub FilterTwoDimensionalArray()

Dim startingArray() As Variant
ReDim startingArray(1 To 6, 1 To 3)

Dim filteredArray() As Variant
ReDim filteredArray(1 To 3, 1 To 3) As Variant
' In the above line I am able to Redim filteredArray to (1 To 3, 1 To 3)
' because I know in advance how many elements filteredArray will need to accomodate
' as I can see the data


startingArray(1, 1) = 1
startingArray(1, 2) = 3
startingArray(1, 3) = "This is an apple."

startingArray(2, 1) = 4
startingArray(2, 2) = 9
startingArray(2, 3) = "He looked happy."

startingArray(3, 1) = 10
startingArray(3, 2) = 12
startingArray(3, 3) = "This is an apple."

startingArray(4, 1) = 13
startingArray(4, 2) = 16
startingArray(4, 3) = "This is a good 

Open in new window

0
Dear Experts:

I got an .xlsm file which only should be saved as .xlsm file by the user.

Is it possible to restrict the user to just save it as .xlsm-file and not as an .xls or .xlsx or other file type? And If yes, how would this VBA code look like?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
0
Dear Experts:

There is a built-in command in MS Excel that says:

File - Share - E-mail - as attachment (Excel 2013-2016) or
File - Save&Send - as e-mail attachment (Excel 2010)

For some specific reason I would like to intercept this built-in functionality in the following way.

Right before the user clicks the Save&Send (or Share) command I would like to run a macro code.

Is this possible?

Help is very much appreciated. Thank you very much in advance.

Regards, Andreas
0
I have a workbook that I have copied and pasted a sheet into workbook 2.

Both workbooks are exactly the same but its finding data from workbook 1 in workbook 2.

How do I change links in workbook 2 so it links to data in workbook 2 without having to copy and paste links for all workbook again
0
Dear Experts:

I got a form with Active X Control boxes.

In the below code only Range("F23") is checked whether it contains the boolean value 'False'.

I would like to expand the IF statement so that Range "F23" to Range "F85" is included, i.e. the IF statement is true
 if all cells in that range ("F23" to "F85") have the boolean value of 'False'.

I do not want to add more than 60 'And' formulas to my vba Code. I am sure there is a quicker and shorter way.

Help is very much appreciated. Thank you very much in advance.

Regards, Andreas

Sub Check_for_value_in_a_range()

If ActiveSheet.OLEObjects("chbx_GenSurg").Object.Value = True And ActiveSheet.Range("F23").Value = False Then
ActiveSheet.OLEObjects("chbx_GenSurg").Object.Value = False

End If

End Sub

Open in new window

0
Hello Experts,
I am trying to documenting my various procedures. Could you please advice me with the following questions:

  1. Best way to loop used range in a specific sheet in order to apply same height
  2. Best way to loop used range of all sheets in workbook.
  3. Best way to loop columns related to usedrange in activesheet in order to apply same width

Thank you very much for your help.
0
Dear Experts:

I got a form with Active X Control boxes.

In the below code only Range("F23") is checked whether it contains the boolean value 'False'.

I would like to expand the IF statement so that Range "F23" to Range "F30" is included, i.e. the IF statement is true
 if any number of Cells (1 to 8) in the range "F23" to "F30" has the boolean value of 'False'.

Help is very much appreciated. Thank you very much in advance.

Regards, Andreas

Sub Check_for_value_in_a_range()

If ActiveSheet.OLEObjects("chbx_GenSurg").Object.Value = True And ActiveSheet.Range("F23").Value = False Then
ActiveSheet.OLEObjects("chbx_GenSurg").Object.Value = False

End If

End Sub

Open in new window

0
Gurus ,

Good day to you . If i have two sheets , do i have an option to see the discrepancies between the sheets ( eg : description , qty , value etc )

Regards,
Sid
Sim1.xlsx
Sim1-v1.1.xlsx
0
LinkedIn & the state of cyber security
LinkedIn & the state of cyber security

Hundreds of thousands of cyber security jobs go unfilled because employers can't find the talent they need.

running access 2016 as part of office 365. Now trying to run an existing access app that requires ms office xx.x object library and its no where to be found in references list.
How do I get an object library?
0
Is it possible to have AAD Connect automatically synchronize to Office 365 whenever a new account is created automatically on-premise without running the AD Sync manually?
0
calculate days and time between two steps; in the attached file i need to concatenate  number and name and calculate difference between each step; if the step is repeating consider the latest or last updated one
0
Hi,

I can't find the Microsoft Office folder under Programs (x86).  Any ideas why this is missing?  I'm able to use the Microsoft applications just fine but in order to install a vendor add-in correctly, they said this folder needs to be present.
0
Hello Experts - I'm thinking of hiring a part time helpdesk person to assist me with some basic IT stuff like installing software, answering helpdesk calls etc.  I'm not sure what hourly compensation would be fair for someone who is relatively inexperienced, maybe just out of school, and doing this maybe 20 hours per week.  This would be in an architectural office near Trenton NJ.  Would appreciate any feedback, thanks!
0
I need a working example to extract an i address from a string using regular expressions.
Thanks
0

Microsoft Office

66K

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.