Hi,
As a total newbie to VBA, I'm hoping someone can point me in the right direction. My problem is simple (see attached file), I need to assign a macro to a button that saves the workbook with a specific filename at a specific location within the Windows 7 OS.
So the file I've uploaded has two cells specifying the file location to be saved (B2) and the file name to be used (B3). My macro code is is assigned to Button 2 and its code is:-
but when I click Button 2 I get an error message (which also pasted into the file)
Can any one help solve this?
Many thanks
Bookmarks