We help IT Professionals succeed at work.

Microsoft Office

70K

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.

how to capitalize the first letter of a word in an excel cell.

the formula proper() is not good. it uncapitlizes abbreviations. so i need something that just literally only takes first character and turns it into a capital letter
0
i need to do a vlookup on 2 columns

the data needs to come from sheet 2 into sheet1/

i attached the file. i did the first row to show you what i need.
vlookup-test.xlsx
0
Hi

What Excel VBA code would I use to check if a column exists. For instance "ÄB" would return true
and "78A" would return false
Thanks
0
I need to extract all instances of numbers in a given string. I have posted a few sample strings in the attached excel file with the expected results for the first string next to a command button.

Can someone provide VBA code which will extract the numbers as listed and also provide the location of each number within the string.
NumericExtractor.xlsm
0
I recently migrated data and programs to another laptop, using an application called ZInstall.  Both the original and target notebooks are running Windows 7 Professional SP-1.  The target laptop already had Office 360 installed, which I don't want to use.  

My Office 2007 had an issue with launching configuration when a Word document was opened.  This was corrected with a registry modification:
reg add HKCU\Software\Microsoft\Office\12.0\excel\Options /v NoReReg /t REG_DWORD /d 1

However, the same issue occurs with Excel, and it was not resolved with a similar registry edit.  Running Office Repair did not resolve it, either.  It is not possible to uninstall or reinstall Office 2007, and I think this is a known issue when SP-1 is installed on Windows 7.

If you know of a solution, please advise.  However, to save everyone time, please understand that I don't want to change operating systems or software.  I just want to get Excel 2007 to work, if it is possible.
0
Hello,

I just posted a question but the solution I got does work work 100% so I am re-posting this.

********************************************************************************************************************************

I have the attached spreadsheet which I want to find the OS of each computer in column A using column D and column E.  

For example, computer 1 in column A appears in column D, I want the OS in column E being copied to column B.  

Please advise a formula I can use in column B.  

Please note that I have about 3000 rows in the spreadsheet.  

Many thanks.
OS-searchup.xlsx
0
Hello,

I have the attached spreadsheet which I want to find the OS of each computer in column A using column D and column E.  

For example, computer 1 in column A appears in column D, I want the OS in column E being copied to column B.  

Please advise a formula I can use in column B.  

Many thanks.
OS-searchup.xlsx
0
We just completed a migration for a client from POP3 to Office365.
I cannot 100% say that some accounts were not imap, but everything I touched was POP3.

It was a manual process that required both email servers to be live with transport rules between them.
There was no easy way around this, but only Office 365 exchange is running now.

During the process we would fire up an O365 license for the user
Import their PST into the email account through Outlook
Let it migrate to the cloud
and everything worked fine save for 1 other user that had this issue.
Deleting and recreating their profile solved the problem for that user.

*********
Current issue
*********
One user had a sizable PST of around 11GB, but nothing we had not seen in several other users
It imported to Outlook without error

In Outlook 2016, there is an issue where SOME subfolders not showing any emails.  Even when a brand new email from today is moved to that folder.  Invisible.
All of the emails show up in OWA.


We have deleted and recreated the email profile
Set cache to ALL (changed from 1 year)
Set cache to none
View->view settings = Off.  Do not see any filters set there.
Do not see any rules set up

I have noticed that some of the subfolder properties show
Type: folder containing IMAP items
Where others show Type: folder containing Mail and Post items
However they do not correspond to the problem folders.  It appears to be random which will not sync and which have the IMAP or…
0
Hello experts,

I am struggling with connectors and shapes and I would like to have some thoughts.

I have the following attached document.

I am trying to connect orange with gray box through the gray connector line. Normally the green point should be displayed however I tried with ctrl and shift keys and moving the mouse accordingly and it doesn't work. This process is not straightforward and I would like to know if there is a way to set up a VBA procedure to cover this need. The idea will be select the two shapes and automatically add a line connector. Connector format doesn't matter for the moment.
20200403_152537-screenshot.png
If you have questions, please contact me.
Thank you for your help.
ConnectorsShapes.docx
0
Hi

What Excel VBA code would use to find the 4th instance of the word "CLOSING" using the FIND function and return the row address?
The instance changes so I need to sometimes find the 5th or 6th instance.

Thanks
0
Hi

What Excel VBA code would use to find a partial match of a word "AC223" using the FIND function and return the row number and column number of the cell found?
0
Folks,
Hoping all are virus free and remains so.
This question is regard PivotTables.
Below you see the results of a Pivot query:
Changing label names
Is there a way using VBA that one can have labels automatically changed. For example, if I elect to show by rows, County, PivotTable returns Row Labels. If I am interest in the total sales, PitvotTable returns SumofSales. In the above example I manually changed the name in the Formula bar.

My objective would be to have a message box appear that would allow me to change a label if I choose.
0
I am trying to print a web page that is a banking statement.  The last two columns are truncated...that is they do not show in the printed document.
The printer is listed as the default printer and also Microsoft Office is installed.
What should I be trying to do in order to solve this problem?
Thanks,
Capreol
0
I am running Windows 10 and Office 365 on my two office laptops (both are pretty new Lenovo laptops).  All of a sudden, Outlook won't open on one of my computers.  If it's already open, it stops getting new emails - and if it's not already open it won't open at all.  I need to reboot the computer, and then everything works fine.  Any idea what's causing this, and how I can fix it?  There aren't any error messages to give me a hint.

Thanks,

Phil
0
Wanted to assess "NO-IMPACT" or "IMPACT" based on mutiple date criterias.

Column D is what I'm trying to accomplish based on the dates on columns A,B, and C.  I've also added on column D and explanation as to why.

See attached file...
C--Users-lfreund-Documents-EE---CAL.xlsx
0
I wanted to calculate the quarter by a given month.  If there is a date in column B then the quarter should reflect that date and if it's blank then it should reflect what is in column A.

In addition, hope it is possible, if the date in column B is blank and the date in column A is in the past it should now reflect the next quarter.

See attachment to see what the results are in column C.
C--Users-lfreund-Documents-EE---QTR.xlsx
0
Stand alone installation of Office 2013.
Opening Word to a new blank document has a table like grid that appears to be set as an embedded background. Can't select, modify, or delete it.
I assume the Normal.dotm file was overwritten, but when I open it in Word, it IS normal, no grids, no formatting. A new blank document.
Still, open Word, and select New Blank Document, and the grid pattern is there. It seems like the default path has been changed, yet I don't know where, or how, to point Word back towards the Normal.dotm file that appears to be corruption free.
Any ideas?
Thanks.
0
Excel 2019. How do I put in the first column a list of three digit numbers like:

256
745
989
284
103
256

Note the first and last are the same.

I want to after putting in 100 numbers or so, be able to make Excel a) delete any duplicates and b) list the numbers in column A from lowest number to highest number.
0
We have Windows XP Home Edition version 2002 with product key.
We also have Office XP Professional 2002 but no key. Is the key required or will the installation of the OS request the Office disc.
0
Hello,

This is my first time to ask; Now we are work from home because of coronavirus we were working from home sines three weeks ago,

My issues with the exchange:

- when adding an account from the work network and go home is working fine.

- No one can add the account to outlook from home because of different use networks even use VPN.
this message appears ( An encrypted connection to your mail server is not available)

- Users who work on outlook form home, outlook not stable some time disconnect and sometimes need to close outlook and open again.

our exchange server is 2019 and office 2016 all on-prime
please need help to make everything stable.

Thanks in advance,
0
I have a SSRS report and the cells in one column (MarketPrice) can be a number or text "NA". Is there a way in SSRS to have numbers in raw excel show as numbers even though another cell value in that column is text (NA)? Right now the raw excel dump shows the "Number Stored as Text" green triangle for numbers.Column with Number and Text values.
Thanks in advance.

Rob M.
0
Excel - is there a way to resize my data validation drop down?
0
Hello experts,

Following the question: https://www.experts-exchange.com/questions/29176602/Powerpoint-VBA-resize-all-objects.html
which allows me to resize selected shapes

I would like to transpose the procedure to Excel VBA.

The aim is to resize selected shapes based on the same flag mechanism in Excel.

I attached dummy file.

If you have questions, please contact me.
ResizeSelectedShapes_20200331_22243.xlsx
0
Is there an easy way to change the values of duplicate numbers in a range of values in Excel (Office 365)?

I have an application that contains results for 5 different teams, which are then displayed on a line graph over multiple periods. The problem with this is that if several teams have the same results in one or more periods, only the last team (series 5 on the graph) is visible, as it covers the other lines. I have read suggestions about using different line thicknesses, etc., but I would rather solve this by detecting the duplicates in a range of 5 numbers and adding, or subtracting an incremental value to the values that are duplicated. Also, because of how the graphs are used, and to save someone suggesting it, bar graphs are not an option.

Given that the values can range from 0 to 400, being able to add or subtract, say 1 or 2, but only to the duplicated numbers, would be ideal. Of course, it would also need to ensure that any addition or subtraction did not then give the same value as a number that wasn't changed.

Just to illustrate, if the team results are 300, 298, 300, 305, 300 repeated over say 3 periods, it it easy to see the line that corresponds to teams 2 and 4, but only the line for team 5 will be visible for the other 3 results, as it will be on top of teams 1 and 3. The danger is that if we subtracted 2, from the result for team 5, this would then have the same value as team 2 and the line would overlay the team 2 result.

I would prefer to …
0
I have an Access Database that wants to send information in an Excel spreadsheet.

An extract of the code is as follows, but the code falls over at .Workbooks.Add with the following error.

Run-time error '-2147417851 (80010105)'

We only get this error in a terminal server environment.  When on a Windows desktop it works fine.

Can anyone tell me what could be going wrong? or advise me how to make the code more robust.

Cheers


'Call OpenEDRTemplate(strFilename, True, strOrderNo)
Set myXL = New Excel.Application

With myXL
    myXL.Visible = True
    .Workbooks.Add "\\sc-addfs-01\dfs\Orders\Templates\Error Damage Master Template.xltx"


    .ActiveWorkbook.SaveAs (strFilename)
   
    Set myWkb = .ActiveWorkbook
    Set myWks = myWkb.ActiveSheet
   
    With myWks
        .Range("dealer_name").Value = strDealer
        .Range("sc_acno").Value = strACNo
        .Range("sc_order_no").Value = strOrderNo
        .Range("customer_name").Value = strCustomer
        .Range("dealer_order_no").Value = strDealerOrderNo
   
        'write room names
        bytItem = 1
        .Range("b19").Select
    End With
   
jump1:
    stSelect = "SELECT dbo_tbl131OrderLine.f131intLineNumber, dbo_tbl131OrderLine.f131strRoom, dbo_tbl103Orders.f103strSCOrder "
    stFrom = "FROM (dbo_tbl103Orders INNER JOIN dbo_tbl130OrderLineBase ON dbo_tbl103Orders.f103intOrderId = dbo_tbl130OrderLineBase.f130intOrderId) INNER JOIN dbo_tbl131OrderLine ON …
0

Microsoft Office

70K

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.