Stack Overflow
Stack Overflow

Questions tagged [office-2016]

145 questions
0
votes
1 answer

MS Excel - Unable to import data as text/csv file

I am trying to import data from yahoo finance. However, when I go to Data >> From text/CSV and enter the link, the following screen pops up: The link I enter is just a copied link from yahoo finance (i.e. yahoo finacne >> google >> historical…
Achyut
  • 19
  • 1
  • 4
0
votes
1 answer

How can vba be used to change the vertical and horizontal positions of objects, such as word art, in powerpoint?

I have a lot of slides, each with a single word art. I wish to align the word art to the absolute centre of the slide. the code I have tried is: Option Explicit Sub format() Dim sl As Slide Dim ob As Object For Each sl In…
John McCormick
  • 3
  • 2
0
votes
0 answers

Issue with Removing References in Microsoft Access

I'm having an issue where when I remove a reference from Access on close it does not stick. I have the function assigned to a hidden window that is always open and it works when I manually close the window, but when I close the database the change…
todaroa
  • 329
  • 1
  • 4
  • 15
0
votes
1 answer

Setting chart title only works while debugging in Excel 2016

The problem can be summarized like this: This problem only occurs if I run the code, not when I step through the chrt.HasTitle-line. In that case, it correctly creates a title and I can edit it however I want. I'll first give the relevant source…
Didii
  • 1,194
  • 12
  • 36
0
votes
1 answer

How to add custom style to a word document?

How to add a custom style to a word document using the word javascript API. I tried adding the styles by insertOoxml. It is not working. I want some of my custom styles to be available for use in the word javascript API so that I can change style of…
Mohamed Shakeel
  • 361
  • 1
  • 15
0
votes
0 answers

Excel (.xlsx) write not working using java

I am unable to update Excel file(.xlsx) using my java code. can u please let me know where I am making mistake. It throws a NullPointerException. Using POI Apache jars.Using Office 2016 for Excel public class test_extra1 { public static void…
Dev Malhotra
  • 31
  • 5
0
votes
3 answers

MailMerge not working on Office 2016

I have one program which uses mailmerge in Word and it works perfectly in office 2007 and tested in 2010. But in office 2016 it throws an error Code is below ASSIGN lv_cDocument = fiFile. /* chosen from program select */ ASSIGN…
KuKeC
  • 4,392
  • 5
  • 31
  • 60
0
votes
1 answer

Macro runs fine on Windows but does not on Mac

I have a Word document which is used for form filling purpose. The users are filling what is asked and some macros runs depending on what they chose or where they click. This works fine. Or at least, on my Windows operating system. I myself, as well…
Marks
  • 165
  • 4
  • 19
0
votes
1 answer

LTR Direction - office 2016

I want my office 2016 (English installation) will be always be in Left to Right Direction,All My office software(Word,excel, Outlook ans so.. opens in Right-To-Left Direction. I tried to change from File->options->Advanced->Show Document content->…
Yosef Alon
  • 78
  • 12
0
votes
1 answer

MS Excel - auto-populate column with filenames from a specific folder

I am a non-programmer, and I need an automatic way to populate a column in Excel 2016 with filenames from a specific folder. I have never built macros before either. Is there a relatively painless way to do this? Many thanks.
Ed K
  • 1
  • 2
0
votes
1 answer

How to check Office AddIn Host is running an Outlook application using office.js?

Using the Office.js Api how do you determine the current App being used "Office.context.requirements.isSetSupported" only seems to work for Excel & Word, and I would like to check for Outlook.
Craig
  • 29
  • 4
0
votes
1 answer

VBA Excle run a Powerpoint marco that takes in the excel filename

I have this macro in an automatically created data file (part of the creation is inserting and running the macro). I want to open a template file and then need to run a PPT macro that takes in the excel data file name. The one that called the…
mooseman
  • 1,997
  • 2
  • 17
  • 29
0
votes
2 answers

Exchange 2016 - Unable to Send As on Mail Public Folder

Exchange 2016 using Outlook 2016 client Created a new Public Folder titled Mail-enabled the public folder: Enable-MailPublicFolder -Identity "\PublicFolder" Added Send As permissions. Add-ADPermission PublicFolder -User domain\jsmith…
anthonyblue
  • 1
  • 1
  • 2
0
votes
1 answer

Excel VSTO project not loading after upgrading from Office 2013 to Office 2016

I get the below error on loading the project with VS 2013 (with Office 2016 installed) Cannot create the project because the application associated with this project type is not installed on this computer. You must install the Microsoft Office…
Gopal SA
  • 949
  • 2
  • 17
  • 36
0
votes
1 answer

Excel Macro Save.As Date

I have a Macro that takes my Master workbook & saves a bunch of different copies with different labels. Example of section for one workbook: Range("E1:G1").Select ActiveCell.FormulaR1C1 = "099 Commercial" ChDir "T:\Accounting\Aspen…
SWinchester
  • 1
  • 1
1 2 3
…
9 10