Microsoft Office

59K

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

I found this solution, but am not sure how to apply it:

http://www.excelforum.com/excel-general/380217-asterisks-in-excel.html

I know I should format the cell as customized format, but how do I enter the correct pattern?
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 can't seem to find this in my search. I simply have a table or range in my excel spreadsheet and I'm looking for a VBA code to insert the data into SQL Server.  I don't want to use any integrated services or an OPENROWSET in SSMS since this will be a spreadsheet in a shared folder.
0
I have a lot of data to select. At the moment I select the first cell of data, left click my mouse, and scroll down the page until I have all the data that I wish to collect.

I have 60,000 rows to scroll through on multiple sheets.

Is there a quicker way of selecting data ?

 I know I can select an entire column but that doesnt work for me

Thanks
0
Looking some clarification.

Want to incorporate another domain name currently using GMail business suite.
The are registered on GoDaddy.

Our own domain is O365 cloud based.

To change mail flow -is it a case of removing the GMail MX records īn the registered domain?
Then adding the existing MX record to the new domain ?
Xxx.com.mail.protection.outlook.com

Or are there further steps?
0
Hi,

I uploaded an XLSX file to Google docs but can't open it.

  • When I click directly on the file,, the browser hangs.
  • When I try to open with Google Sheets, I'm told the file is too large...but it is definitely no.t

What could cause the above issues?
Thanks,
Steve
0
I am trying to modify some formulas that I have used in the past and understand the difference between the two.

I have a spreadsheet with the TABs  'Orders' and 'KOB1'

I want to use the two formulas (so I can compare and understand) to pull information from 'Orders' to 'KOB1' using column A on both sheets.

I want to match columns 'A' on both sheets and then pull column 'C' from 'Orders' to fill columns 'B' - using the index formula and 'C' - using the Vlookup formula on KOB1.
See attachment
test.xlsx
0
Win10/Office 2016:

Hi.

I received a Win10 update overnight, followed by an Office update when I logged onto Outlook this morning.

Now, I notice that my Pinned files in Word look weird. e.g. Current file(s) missing and at least two files that haven't been there in ages have returned to this list.

Has anyone else seen this behavior? Is there a way to fix?

Thanks,
Steve
0
I am looking up values in column A Sheet1 and bringing back the needed data from Sheet B. The issue is that column A Sheet 1 has multiple identical values: For example:
 A1= 600853220
 A2= 600853220
 A3= 600853220
 A4= 600853242
 A5= 600853242
 A6= 600853242
 A7= 600854637
 A8= 600854637
what formula needs to be used to return only one value and reference 0 for remaining identical numbers?
Thanks!
0
Hi to all, Microsoft Outlook is blocking all email received like attachments (msg or eml format);
I tried to create Level1Remove Registry Key but it don't solve the issue;
Microsoft Outlook 2016 (Office 365 local installation version) doesn't block them.
is there anyone that has a solution?
Thanks to all
Bye
0
I  have a large spreadsheet that lists suppliers and for each supplier there are multiple rows as an entry has been created for each cost centre in which there are costs associated with that supplier.

OJBECTIVE

I am trying to summarise supplier turnover on a single line using a formula e.g. select the entire range in which the list appears and create a summary turnover statement - see example attached with required output

I would be very grateful for a speedy answer.

Thanks,
David
ExpertsSpreadsheet.xlsx
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.

I have one VBS which convert my csv to excel.
Now my CSV there are some characters like "!".
I want to color Yellow on those cell which are having that character after converting to excel.

Sample.CSV :

Name,Location,Phone,Comment1,Comment2
"ABC","Pune",123,"Expert Value","! Easy"
"XYZ","Kol",567,"! Expert value",Easy"

i.e. after converting to Excel, I need E1 and D2 Cell should be as Yellow

MyScript.vbs : which needs two argument to execute
cscript C:\Test\MyScript.vbs \\C:\Test\Sample.CSV \\C:\Test\Sample.xlsx

'======================================
' Convert CSV to XLS
'
' arg1: source - CSV path\file
' arg2: target - Excel path\file
'======================================

srccsvfile = Wscript.Arguments(0)  
tgtxlsfile = Wscript.Arguments(1)  

'Create Spreadsheet
'Look for an existing Excel instance.
On Error Resume Next ' Turn on the error handling flag
Set objExcel = GetObject(,"Excel.Application")
'If not found, create a new instance.
If Err.Number = 429 Then  '> 0
  Set objExcel = CreateObject("Excel.Application")
End If

objExcel.Visible = false
objExcel.displayalerts=false

'Import CSV into Spreadsheet
Set objWorkbook = objExcel.Workbooks.open(srccsvfile)
Set objWorksheet1 = objWorkbook.Worksheets(1)

'Adjust width of columns
Set objRange = objWorksheet1.UsedRange
objRange.EntireColumn.Autofit()
'This code could be used to AutoFit a select number of  columns
'For intColumns = 1 To 17
'    …
0
I am not sure how to explain this, so please bear with me.  I don't know what this would be called, but...

I work for a school district and have a spreadsheet with discipline data that I must sort.  Unfortunately, when the data was exported to Excel, some of the data was merged within several rows of cells.  I removed the merge from the data, and it left blank cells.  I need to sort the data, but I must populate the blank cells first.  

So, let's say row 2 has discipline data for student A.  The data is several columns wide.  Student A has 8 rows of data, some of which is duplicate data (of which I need to remove dups).  Below all of that, student B has 10 rows of data.  The problem is, after the merge was removed, row 2 contains student A name and ID, along with one discipline record.  Rows 3-9 contain blanks where the student A name and ID should be, along with one discipline record per row.  Row 10 contains student B name and ID, along with one discipline record.  How do I populate rows 3-9 with the student A name and ID?  I have been doing copy and paste to fill these blanks in, but ... I have 35 thousand rows to work with.  Ugghh.

I am attaching a sample of what the spreadsheet looks like (just a small portion).

I would be thankful for any help.  Like I said, I don't even know what to call this so I can search for help.

Thank you,

Patty
Excel-Sample.xlsx
0
This worked for over 5 years but today i got the above error message.  Please advise.  Thanks

Here is the connection string:  

DBQ=J:\ISOURCE DATA REPOSITORY;DefaultDir=J:\ISOURCE DATA REPOSITORY;Driver={Microsoft Text Driver (*.txt; *.csv)};DriverId=27;FIL=text;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes

This is the SQL:

SELECT otc_sales_history_product_detail_spine.TERRITORY_NUMBER, otc_sales_history_product_detail_spine.TERRITORY_DESC, otc_sales_history_product_detail_spine.BRANCH_ID, otc_sales_history_product_detail_spine.BRANCH_DESC, otc_sales_history_product_detail_spine.CUSTOMER_NUMBER, otc_sales_history_product_detail_spine.CUSTOMER_NAME, otc_sales_history_product_detail_spine.CITY, otc_sales_history_product_detail_spine.STATE, otc_sales_history_product_detail_spine.MARKETING_DIVISION_CODE, otc_sales_history_product_detail_spine.MARKETING_DIVISION, otc_sales_history_product_detail_spine.PRODUCT_TYPE_CODE, otc_sales_history_product_detail_spine.PRODUCT_TYPE, otc_sales_history_product_detail_spine.PRODUCT_APPLICATION_CODE, otc_sales_history_product_detail_spine.PRODUCT_APPLICATION, otc_sales_history_product_detail_spine.PRODUCT_LINE_CODE, otc_sales_history_product_detail_spine.PRODUCT_LINE, otc_sales_history_product_detail_spine.PRODUCT_GROUP_CODE, otc_sales_history_product_detail_spine.PRODUCT_GROUP, otc_sales_history_product_detail_spine.ITEM_GROUP_CODE, …
0
is any way if im in the mid of the sheet (have a lot of records)
to move  fast to the last row of data with an button !!
AND TO  THE TOP AS NEEDED !

ALSO HAVE TO SAY THE TOP FOR MY DATA BEGING IN ROW 46
(NOT ROW 1)
DATADATE.xlsx
0
The code below opens Google Chrome

When I run it with Google Chrome already open, it adds an extra tab and it works as expected.

If Chrome is not yet open when I run it, it opens Chrome (as expected) however then the SetForegroundWindow line doesn't work, it doesn't bring google to the front.

(Google Chrome needs to be installed on your computer for it to work and the program uses windows location, ie you'd need to edit the folder "chromePath" for Mac and Linux)

'findwindow
Public Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" (ByVal hWnd1 As Long, ByVal hWnd2 As Long, ByVal lpsz1 As String, ByVal lpsz2 As String) As Long
Const CB_FINDSTRINGEXACT = &H158
Const CB_SETCURSEL = &H14E
Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hWnd As Long, ByVal wMsg As Long, ByVal wParam As Integer, ByVal lParam As Any) As Long
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Const CB_GETCURSEL As Long = &H147
Private Const CB_GETLBTEXT As Long = &H148
Private Const CB_INSERTSTRING As Long = &H14A

'setforeground window
Public Declare Function SetForegroundWindow Lib "user32" (ByVal hWnd As Long) As Long

'getactivewindow
Public Declare Function GetActiveWindow Lib "user32" () As Long






Function IsFile(ByVal fName As String) As Boolean
'Returns TRUE if the provided name points to an existing file.
'Returns FALSE if not 

Open in new window

0
Looking some advise on how to change/move a domain's MX record(s)
This would facilitate for all mail coming into another Office 365 domain.

So basically re-point the MX record into another existing domain in Office 365.

This in turn would mean all mail would be directed to our Exchange Cloud Server
0
Hi

I want a formula to display one of 3 values depending on the value in a cell. The values in the first  2 cells can be "Module 1", "Module 2", etc. The third cell checks if the first two cells contain the same value and returns TRUE if they are the same and FALSE if they are not.

The formula I am using is: =IF(A1="Module 1",A2,IF(B1="Module 1",B2,IF(C1=TRUE,C2,0)))

This works fine if either cell A1 or B1 is "Module 1" but it is not returning C2 if both cells contain "Module 1".

I have tried using 'AND' statements but this doesn't work either.

Am I missing something really basic in this formula?

I have attached a simplified version of the sheet for demonstration.

Regards

Terry
If-Tester.xlsx
0
The attached file contains an INDEX formula in column E, that finds the inserts the name from column A, and where the number in Column B is the same as the number in Column F.

The problem is that this formula appears to not work in a lot of the rows starting at row E360.

Any help is solving this problem will be much appreciated.

Thanks,

Greg
Correspondence-problem-example.xlsx
0
Need help with code.   I used Conditional formatting to illistrate the color coding for duplicates. I would like vba to indicate duplicate in any column then is it possible to indicate which columns by header are duplicated.   Example A4221- DMEBASE, DEMBASKX.

Format for the example is a quick glance of which codes and the column by headername where it is found.  

Conditional formatting can be removed if VBA is handling it all.

Thank you..
DME---CPT-match-Report.xlsm
0
NEW Veeam Agent for Microsoft Windows
LVL 1
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

LIKE SHOW HERE !
 YYYYYYYYYYYYYYYYBBBBBBBBBBBBBBB.png
0
I have a number/text in a spreadsheet that I am using to reference a row for vlookup.  I want to reference a number in another row without having to do another vlookup.  Can I use a formula to add one to the row reference that is 2017-29 to make it 2017-30.  I can do it manually with the pull handle, but cannot find a formula that will work.
0
to count the columns

also need repair the clean button in INDATA sheet
and clean button in TEMPDATA sheet
n4hT.xlsm
0
I need to see what permissions are set, and where they are applied, for all people / groups in office 365.
I'm new to sharepoint, and am taking over administration from an outside consultant.  Is there an easy way to generate a report on all permissions set, for all sites, subsites etc?

Bartender_1
0
Need buttons

P4ALLW,, PAIRALLW, RGALLW
n4hPA--1---2-.xlsm
0
need buttons  

P4WK2,  PAIRWK2,  RGWK2
0

Microsoft Office

59K

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.