I have figured out some code to copy all the data from a table, create a new workbook, paste the data and then save the workbook as a CSV as the name of the original table the data came from. I now am trying to figure out how to save the file as a custom name from cell L23 from...
Recently I have started recording and editing macros. I am really new in this field and I am not able to find the solution for one of the latest macros I have recorded. When I run the macro below I get the following error message:
Run-Time error '1004':
Is there a way that when saving a file the file name will automatically become whatever value is in a specific cell?
For example cell B3 in a form will be the item number. When the user saves the file I would like the file name to automatically save as whatever is typed into cell B3.
Wondering if you can help; I have a slightly specific one which I'm struggling to crack.
My workbook has 4 sheets:
1) 'ORIGINAL' (as an example, lets say A1 value = 'face', A2 value = 'cheese' and A3 value = 'head'
In short I'm trying to save...