2007 macros

Guys, On my work machine I was running XP and 2007 Excel. While we migrated to 2010 Excel and Windows 7 Enterprise I needed to use a few project plans. These contained a few macros and were password protected docs. I use Excel 2016 at home so just opened them on USB. Now when I try and open...

Hi! I've been putting together a spreadsheet for awhile now and have been able to piece it together up until this point, my knowledge and understanding has run dry. We're running 2007, have a couple macros working already and creating a tool setup sheet for our CNC department and some tool...

Hi all, I am not massively clued up on Macros and am having an issue that I think relates to my settings rather than the macros themselves. No matter what workbook I open, if it has a macro in it, it will run the macro to a point, then stop, I hit the play button and it completes the script...

I have the below code which selects all data below A5, includes the 17 columns on the right of it, and then offsets by one so I don't clear the title row. <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console'...

Hi, I need to copy some data every month, paste it into a spreadsheet and then save it as a new file with updated date Sub InvoiceBackup() Sheets("ASM001").Select Range("A1048576").End(xlUp).Select If ActiveCell.Row = 5 Then Exit Sub Range( _...

Hello, Below is a macro that i had written in 2007 that oes not work anymore and i have no idea why. It gets as far as opening the first file but then stops with no error. It's supposed to open a file browser, then i click on the first of 3 files then it copies the data and pastes it back into...