Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Microsoft Office

62K

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

What kind of case is this?

I was at a clients office cleaning out his desktops and found a desktop that pulls the power supply out like a server. It’s made by dell, but can you get cases like this that aren’t marked Dell?

I would love to be able to replace power supplies like this in my builds.15E9959F-A9E3-4BD8-B076-4DD75D271E1.jpeg
0
[Webinar On Demand] Database Backup and Recovery
LVL 11
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

i have vba code for sending emails---and so i already have one book with the form and code that prompts me to enter how many seconds i want to delay between sending emails.

i have a separate vba code for sending emails that is missing this form and prompt. please see book called has timer and port the code to add a timer to the book called missing timer.

thanks!
has-timer.xlsm
0
I am trying to make a report to capture "total days spent in a month" by team members on a project. I tried using formulas ( Sum if , Count if, also Tried PIVOT )  but I am not getting the desired result. I was hoping if experts can guide me an excel formula or if a VBA code will produce the report.

I am attaching the Excel sheet and more detailed requirement is mentioned on summary page of the excel sheet , any insight would be appreciated
Experts-assistance.xlsx
0
Hello,

I have content as mentioned below in a cell in EXCEL sheet. I wanted to split the content based on keywords "NAME", "EMPLOYER" and "DESIGNATION" into three different columns.

NAME: LOUIS GOERGE EMPLOYER: WALMART DESGINATION: MARKETING MANAGER.

Please let me know if this can be done using VB script or macro and help me with logic.

Thanks.
0
Hi,
I have customized office installation file and saved it under updates folder, we are upgrading office from 2010 to office 2016.
When i run the windows installer file from the updates folder, i get the error which i have attached.
I have run .net framework package, it didnt made any difference.

Any ideas whats required?

Thanks.
upgrade.JPG
0
I am trying to calculate the total number of times an item is used when it is on the same invoice with 2 criteria.  First, the order numbers (column A) have to match and 2) the item number R1606 also needs to be on the same order.  I have attached an example using item numbers R1606 and 24410.  Any help would be appreciated.
SUMIFS_EE.xlsx
0
So I've viewed many similar cases, but still cant seem to make it work.
I have a simple on/off choice from a drop down menu. Cell "Q19".
When either on or off is selected I want to either show or hide columns.
The following script works fine when assigned to a control button, however I want this to be automatic once the selection has been made from the drop down.
Any ideas?


'To Hide and Show Columns for Custom Rubber Properties
Sub Hide()
        'Hide when Q19="OFF"
        If Worksheets("Quick Start").Range("Q19") = "OFF" Then
            Worksheets("Quick Start").Range("S:AF").EntireColumn.Hidden = True
        End If
        'Unhide when Q19="ON"
        If Worksheets("Quick Start").Range("Q19") = "ON" Then
            Worksheets("Quick Start").Range("S:AF").EntireColumn.Hidden = False
        End If

End Sub
0
I have Excel 2010.  The following vbscript file is executed by a scheduled task.  It opens a file to update it, save and close.  The file has the "read-only recommended" option on and my script must answer this prompt with "no" which is not the default.
Option Explicit
Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
With objXL
	.DisplayAlerts = False	
	.WorkBooks.Open FileName:="S:\Schedule\EngDates.xlsm", ReadOnlyRecommended:=False, IgnoreReadOnlyRecommended:=True
	.DisplayAlerts = TRUE
	.Visible = TRUE ' Optional
	.Run "EngDates.xlsm!UpdateDash"
	.ActiveWorkbook.Close(True)
	.Quit
End With
Set objXL = Nothing

Open in new window

I have tried several different syntax formats, with and without parentheses, and nothing has worked yet.
When I run this script, I get an error as seen in the attached file.  Does anyone see the problem with my syntax?  
Thanks!
The error that occurs when I run my script
0
I have a query that loops through a list of db schemas and outputs the results to individual pdfs. I would like to append the results to a single excel spreadsheet instead of individual files. How do I do this?

Function UsageReport()
Dim ssql As String, lookup As String
Dim qd As DAO.QueryDef, db As DAO.Database
Dim Cus As String



Open "D:\Access\UsageList.txt" For Input As #1
Do While Not EOF(1)
Input #1, Cus

Set db = CurrentDb()
Set qd = db.QueryDefs("UsageReport")

ssql = "Set nocount ON; select * from air_client_" & Cus & ".dbo.usagereport "
qd.SQL = ssql

On Error GoTo UsageReport_Err

    
    DoCmd.OutputTo acOutputReport, "UsageReport", "PDFFormat(*.pdf)", "D:\Reports\UsageReports\UsageReport_" & Cus & ".pdf", False, "", , acExportQualityPrint


UsageReport_Exit:
    Exit Function

UsageReport_Err:
    MsgBox Error$
    Resume UsageReport_Exit
Loop
Close 1
End Function

Open in new window

0
Somehow, a poweruser has messed up their site collection.  

The farm is connected to our Office Online installation and works with other site collections.  For this poweruser, when we click on a document library New button, the only option that displays is Excel and "magically" an previously created excel document pops up in excel (without clicking the excel popup link).  

Is anyone familiar with this behavior or how to fix it?

Attempts: I created a new document library, but get the same effect.  This effect happens on subsites as well.  I create a new site collection in the same farm and it works as expected.

---

Edit: I exported the site and imported it into a clean site.  The import log shows:
[1/19/2018 1:17:12 PM] [-List] [wfpub] [wfpub] [9851366e-5c8c-415d-8250-b413ddaa6742]   [-2147024809] [System.ArgumentException] [urlOfFile
Parameter name: Specified value is not supported for the urlOfFile parameter.]

I suspect that the poweruser was using a "Forms" library as if it were a Document Library.  The poweruser had not developed his site too much so we ended up destroying his site and creating it anew.  

He's satisfied for now, but I'm still curious what could have caused a user to get themselves into so much trouble.
0
[Webinar] Database Backup and Recovery
LVL 11
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Hello:

We have an XML file that we would like to open in Excel.  We have tried two methods.  Both have failed.

First, we tried opening Excel, browsing out to the file, and simply opening the file.  But, upon trying to do so and using one of the suggested methods, we get an error saying "cannot load the specified XML".

Also, we have tried opening the XML file by opening Excel, choosing "Data", "Get Data", "From File", and "From XML", we get the error message "XML processing failed...Data at the root level is invalid".

How can we, then, open an XML file in Excel?

Thank you!

John
0
We have a shared events calendar at work that several people have Editor access to. It's in Outlook 2016. If a colleague creates an event and a user updates it and clicks to send the update to her other colleagues she gets error - "This meeting is not in the calendar folder for this account.  Responses to this meeting will not be tallied. Do you want to send anyway?"  Then clicking yes gives she gets an error "The operation failed".

I have unchecked cached exchange mode. Have created a new outlook mail profile. Neither resolves the issue. The user is able to create and send a new event booked in the calendar.
0
I would like to migrate exchange server 2007 to office 356 .

What information  is needed from exchange server?
How to proceed to the migration?
 
I am looking for any step by step tutorial for these procedure
0
My friend and I both have MS Word 2013.
When he Emails the attached Word file to me (and visa versa), it comes out fine .... however ...
When he Emails it to other people, the columns with the Year and corresponding text don't line up.
(I don't know version of word the other people have, but it could part of the explanation)

The real mystery is that when he emails the document to HIMSELF, the same corruption occurs.

Please speculate as to what may be happening.

EDIT: My attached file seems to have the same corruption!
Chronological-2018.docx
0
Hello All,

I have workbook A, B, C, D etc in a folder...
each workbook has four sheets... sheet 1, sheet2 etc.

I want to combine the data from sheet1 of all workbooks into sheet1 of master workbook (which already exists) and similarly sheet2 etc.

The workbooks are from different users... they all have same headings.

Your help will be much appreciated.
0
i want to migrate around 40 mailboxes to Office 365 from a Exchange server 2007 to Office 365 what is the best way to do this. without using 3rd party software.
0
Dear Experts,

My client want to deploy two sets of font for his colleagues who are using Office365 / Office 2016.

I read that the settings needs to be done individually for each users MS Office program.

Is there a way to use GPO to deploy the font and enforce that these will be the default fonts for its MS Office application?
0
What is the fastest and most stable VBA code that will import a range of data from another workbook without opening it.

Example:
Copy Ranges B2:B2000 from a closed workbook located at: C:\Files\Samples\Test.xlsx and past it to Cell C200 in Sheet1 of the current workbook.
0
Hi

With excel vba we are trying to read an excel worksheet (“sheet1”) row by row and access the specific cell contents (row/column) and write it to another worksheet (“sheet2”).  Please advice.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE
LVL 5
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Is there a way to add columns to the Outlook Address Book default view?  We would like to add a column for the mobile phone field.
0
When you select the option to wipe data from mobile devices within the exchange admin portal of Office 365, what exactly happens there and what are the limitations?

If I immediately disable or change passwords on the account, will it still wipe data or do they need to have access to log into their phone's email account before it wipes the data?

I would think it's going to make a connection to the exchange server regardless of whether or not the account is disabled or the password is incorrect, and would hope it wipes the data anyway.

Mainly I want to know if I'm wasting time doing the wipe if the end user is terminated and their account is disabled or the password is changed.

Thanks!
0
Trying to find the true creator of an Excel file on the network.  This is a file going back to 2013 and the 'author' that shows up under the properties is not the true/original creator of the file.  

How can we verify the person that actually created this file?
0
I have a client at home, when she is on the VPN Office does not see an internet connection. Any ideas on how to fix this? I have seen a hot fix for this but did not see a file to download.
0
I have a spreadsheet that gets opened automatically every day to pull data from other sources. I have a list of dates for every work day for the year in column A. In column B in the first row I have a formula to start. None of the other rows in column B have this formula yet. What I need to do is when the file is opened every morning automatically I need the formula to be copied down to the row that has the current date in column A and then paste the values in the row where the copy originated from. For example if A1 is 1/17/18 and the formula is in B1 I need to take that formula and copy it to B2 since A2 is 1/18/18. And then paste the value that is already in B1 so the formula is no more in B1 and is now in B2. How can this be done in VBA?
0
I have a data source for a excel sheet that I added via the admin account to the control panel => data source when Im logged into the computer with an admin account it opens just fine, but when I log in under a standard user it does not. Is there away to a permission so any user on the computer can access the data source.
0

Microsoft Office

62K

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.