excel 2016 macro issue

I have a pivot dashboard that is projecting Due/Overdue status for 3 tasks, measured in the following values: Overdue >15 Months Overdue 14-15 Months Overdue 12-14 Months Due in 1-30 days Due in 31-90 days Record Up to Date The Pilot tables are linked to 3 slicers (named - MDT, BRP, BCE)...

Hi I have a number of macros I have written on Excel 2013. I am now transferring them across to other users' machines as I am leaving. They all run Excel 2016. For some reason, the macros fail on 2016. The start of one macro is as follows: Sub Daily_Open_Trades_Pivot() ' '...

I created a spreadsheet that pulls data from various tabs and summarizes it on the main page. Excel then exports the data to a word template. What I would like to do is have the data converted to PDF and attached to an email. Can anyone help me tweak the VBA code I currently have to accomplish...

Hi all, On Sheet2, I have a drop down that changes the work week to display that week's bookings. On Sheet4, I have an "Override Tab" where the users can input their weekly forecast and any corrections to the bookings. What I'm trying to do is get a VBA autofilter on Sheet4 that activates rows...

I have upgraded to Excel 2016 from excel 97/2003. I have several workbooks with macros in the old format. When I attempt to save them to the .xlsm file format, I receive a message stating that: "This workbook contains one or more of the following features that are not supported by the...

Using the following macro in Excel 2010 work perfect; however, when it runs under Excel 2016 it creates a ghost Excel page: Application.Visible = False 'More macros Application.Wait Now + TimeValue("00:00:05") Application.Visible = True Is there a way to avoid the ghost page from...

I transferred my user-forms and modules to an updated workbook that I was working on and now I get the following error message when I click on my command buttons: Run-time error '9': Subscript out of range When I debug it points to the module for the corresponding command button. One of my...

Hello, Recently my employer moved from Office 2010 to Office 365 (Office 2016). Now my macro's that contain sending emails no longer work and when ran the error and provide a Run Time error '287': Application-defined or object-defined error. Hit debug and the .send command is highlighted in...

I am new to visual basic and need some help with some coding. I have a excel template that has an plan end date and actual end date (2 separate columns) if my actual end date is greater then my plan end date, I need a message box to explain they need to write a comment. If there is no comment...

Hi all, First post here, I read the rules, lemme know if I missed something. I have a macro that I wrote for a buddy a few years ago to automate pulling user submitted football picks into a master file. It worked seamlessly for the past two years. As of this morning, the macro no longer loops...

Hi all, I have a worksheet VBA macro to install an index hyperlink into the workbook spreadsheets that is activated upon going to the index worksheet itself. (clicking tab) or clicking the hyperlink to the index sheet in cell A1. There is no problem in the Excel 2010 or 2013 environment. My...

Hi, I've designed several macros that seem to work fine in 2010, but gives errors and don't work properly in Excel 2016. One macro is simply meant to print a screen, but the formats are all lost in 2016 for example. The other macro filters data perfectly in 2010, but in 2016, it crashes...

I currently have a command button on my userform for the user to "SUBMIT" the data that they entered. This command button pushes the data entered to other worksheets where the data is pertinent. I want to create a "REVIEW" button for the person that is approving the data to use. When clicked, I...

Hello. I have been trying to google around for a solution for my problem but without any luck. Reacently we had an upgrade on our office package at my work. We went from Office 2010 to Office 2016. What seems to happen is that some of my macro functions wont work anymore, for example I have...

Hello, Below is part of a macro that I have been working on to automate a task for myself and others in my position. The issue with this current macro is that when I use the macro it only goes to a certain cell in the column. The reason why it does this is when I recorded the Macro that...

Hello, I have a macro that broke down an Excel workbook into multiple saved files based on a sheet range, beginning with a defined sheet name and ending the sheet before another defined sheet name. I recently updated to Excel 2016 and the loop I have to select the sheets in the range is not...

Hi, I'm something of a script kiddy and my attempts to find a macro that fits my needs have failed. The files look like this: <tbody> Time T2R T2L T3R T3L A1R A1L A2R A2L A3R A3L A4R A4L A5R A5L A6R A6L A7R A7L A8R A8L TrackName 0 0.090924 0.123839 0.151038 0.150756 0.178118 0.178547...

Hello, I am completely new to VBA (and to this forum), so my apologies if this is extremely basic. I need to get filepaths from a column in an Excel sheet and turn them into an Array to be used in a Macro to GrantAccessToMultipleFiles. I am creating a database in a workbook that checks for...

I have got Macros in my Excel File, which typically do the following: ----------------------------------------------- Sub xxxx() .... Dim v As Variant .... ' prepare Application.ScreenUpdating = False v = Application.Calculation '(store the current status of re-calculation)...