The strategic direction is to use an alternative to IBM i Access for Windows data transfer, the new Access Client Solutions (ACS). IBM also does not support Office 365 which has been upgraded to Office 2013 and beyond. Later releases of Office 365 use Office 2013, so we expect you will see the same results with Office 365. Therefore the data transfer add-in is not supported when using Excel 2013 and beyond. IBM development has chosen not to rewrite the System i Access for Windows 7.1 data transfer add-in so that it will conform to the changes starting in Excel 2013. Never versions of Excel may also experience the same problem. The screenshots have been taken with 2010, but the same principle applies in 2013.This document includes problems that have been reported when using the Excel data transfer add-in starting with Excel 2013.

Select the macro ZoomLevel80, click the Options button and enter a keyboard shortcut, for example Ctrl-8. Assign a keyboard shortcut to the macro: Click the 'Macros' icon on the Developer ribbon. The Zoom level is stored with each workbook, though, so when you open another workbook that was not set to 80% zoom, you can use the recorded macro.

The macro code above will run every time this macro workbook is opened. The personal macro workbook is loaded every time Excel starts. Select the 'This Workbook' module and in the code window put this code: Private Sub Workbook_Open()Ĭlick the Save icon. In the 'Modules' section you will find a module with the macro you just recorded, but we can leave that alone. On the left, find the VBA Project (Personal.xlsb). Now hit Alt- F11 to open the Visual Basic Editor. Start the Macro Recorder and in the 'Record Macro' dialog select 'Personal Macro Workbook' in the drop-down for 'Store macro in'. If you don't know whether that is active, follow these steps: You can create a macro in your Personal.xlsb.

Ms excel 2013