I'm battling with an Excel VBA problem.
I'm working in a spreadsheet in a folder called "Master". On the spreadsheet, I have, amongst other data:-
Cell c5 the SalesRep
Cell c6 the Customer
cell c7 the QuoteNo.
I then run a macro to do some calculations. After the calculations, I want the macro to save the file to a different file path: c:\quotes\SalesRep\Customer\Quoteno.xls
How do I do that?
Any help would be sincerely appreciated.
Thank you
Goggem