Stack Overflow
Stack Overflow

Questions tagged [office-2016]

145 questions
0
votes
2 answers

Programmaticaly set signature in Outlook 2016 with vbScript

I've written a vbscript that gets the user-info from the Active Directory, generates a signature based on html and sets the signature in outlook as a default. This worked fine in Office 2010. But now some users have office 2016 and the script does…
Grecht
  • 31
  • 1
  • 10
0
votes
2 answers

Edit source data in embeddet Office 2016 chart

I am trying to edit the source data to a pre formatted waterfall chart in PowerPoint. However, the code crashes when trying to access the .ChartData.Workbook property. Code crashes at first line: Set wbChart =…
L. Kleiven
  • 23
  • 5
0
votes
1 answer

Fails to set source data on MS Office 2016 charts

I am trying to set source data for a MS Office 2016 chart in VBA, but recieve error "Object doesn't support this property or method". The same code works fine with older chart types. To be more specific, the chart type I am trying to generate is…
L. Kleiven
  • 23
  • 5
0
votes
0 answers

Close Excel completely after the final workbook is closed

When I close the workbook using MyWorkbook.Close() an empty Excel container is left behind. Something like but with newer version it would be gray. How can I close this one using C# ? I am asking because I have an issue with Excel 2016, in which…
Kenny
  • 1,902
  • 6
  • 32
  • 61
0
votes
2 answers

Differences between office 2013 and 2016 JS api

https://github.com/OfficeDev/Word-Add-in-DocumentAssembly I am trying to implement functionality like the above link targeting office 2013, yet the source does not run correctly because of the lack of a 'Word' object in JS. Can this code be ported…
bischoffingston
  • 637
  • 9
  • 27
0
votes
1 answer

Visual Studio 2013 refuses to work with Office 2016

I'm trying to create projects in Visual Studio Pro 2013 for use in Office 2016. I know it's supposed to be possible, but VSTO seems to insist I need Office 2013. I've followed several MSDN walkthroughs (Add-In, Document-level, custom tab), and…
TheFontSnob
  • 101
  • 5
0
votes
1 answer

Returning a value with Applescripttask (Word for Mac 2016)

I've started updating an add-in for Word for Mac 2016 and, unsurprisingly, it's not going so well. Can anyone assist in what might be wrong with this applescript (or my method of invoking it)? I'm well-versed in VBA, but very much an Applescript…
Christina
  • 1,349
  • 1
  • 12
  • 22
0
votes
2 answers

The "SetOffice2007AddInRegistration" task failed unexpectedly

I have created a new C# project using a Word 2013 and 2016 VSTO Add-in template in Visual Studio 2015. I have not done any changes to the auto-generated project code in order to see how it will be built on my TFS 2015 Build Server. The build…
MBK
  • 525
  • 1
  • 8
  • 23
0
votes
1 answer

MS Word building block not inserted in its own page

I defined a building block (QuickPart) to "Insert in its own page". I insert it in code (C# Word Interop) like this: range = _doc.get_AttachedTemplate() .BuildingBlockEntries[blockName] .Insert(Where: _selection.Range, RichText:…
Test User
  • 37
  • 1
  • 9
0
votes
1 answer

Excel 2016 Add-in how do i change column format

I have an Excel 2016 Add-in and I would like to set the format on a couple of columns to Date (mm-dd-yyyy format) and center a couple of columns. How can I do this in Excel 2016 JavaScript model? Also, I understand that the office model for 2016…
gihuey
  • 1
  • 3
0
votes
2 answers

SQL helper function not called if a field passed is empty

I have a helper function that should concatenate the Notes First Name, Notes Middle Name and Notes Surname fields from an Access table named IBM Notes. The helper itself works fine, however if I attempt to call it on a row that has an empty entry…
David Gard
  • 11,225
  • 36
  • 115
  • 227
0
votes
1 answer

Office 2016 VBA wrong Toolbox icons size in windows 10

Not sure it this is the right place or how to describe my problem. I have a brand new windows 10 and installed Office 2016. Now when I want to develop something in VBA in Excel or Word and I add a UserForm the icons in toolbox which represent the…
Stephan
  • 463
  • 2
  • 7
  • 22
0
votes
0 answers

'The database engine could not lock table' in Access 2016

I have a function that allows users to efectivly TRUNCATE an Access table. It's a fairly basic function; it deletes all rows, and then resets the auto-increment index by changing the data-type of the ID column to INT, and then back to…
David Gard
  • 11,225
  • 36
  • 115
  • 227
0
votes
1 answer

Excel VBA to Create PowerPoint Presentation

Looking for some help on updating a VBA Script that completes the following (basic algorithm): Excel Template with formulas and macros creates a custom report consisting of approximately 30 charts Macro called “CreatePowerPointPresentation” is used…
user5956916
0
votes
3 answers

Excel: calculate averages based on other column's value

I have a datasheet containing two huge columns, both with integer values. The values in one column range from 1-11, the other from 0-22. The values aren't sorted in any way. In a separate sheet (same file) I want to show averages per step. Example:…
Bram Vanroy
  • 27,032
  • 24
  • 137
  • 239
1 2 3
…
9
10