excel 2013 macro issue

My reports used to connect to our database using a VisualFoxPro ODBC driver, but the new version of the database requires an SQL connection. I have been able to connect just fine, my problem is that I need to modify the macro that lets me change the database path when the report is given to...

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)...

hi there! im a school registrar, could someone teach me how to put macro on my worksheet: 1. encoded a rows of student details (e.g. First Name, Middle Name, Last Name, age, sex etc.) in sheet 1. 2. in the same sheet (sheet 1) a botton or control to create a new sheet (in the same workbook)...

I have float over tools that used to open and work with a keystroke based on the active workbook, but in Excel 2013 it is unpredictable. In the backend activeworkbook may not be the last workbook you were looking at because of this multiple ap focus nonsense. Is there a workaround anyone knows...

Hello, A macro that I use to insert pictures of several items into cells at once is no longer working now that I am using Excel 2013. I have virtually no experience with coding, so any help is much appreciated. Here is the code: Option Explicit Sub AddItemPhoto() Dim photoFolder 'Dim...