0

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

2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by apegram
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.