Thread: Saving a workbook to a specific directory
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chris Hankin[_4_] Chris Hankin[_4_] is offline
external usenet poster
  
Posts: 56
Default Saving a workbook to a specific directory
Thanks again Vergel,

I used the following code to fix my macro. It now works great.

If MyPath < "False" Then
ActiveWorkbook.SaveAs MyPath
End If

Cheers,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote