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

ActiveWorkbook.SaveAs(fileName)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.