View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Macro to Save As with filename based on cell contents.

Hi ImAFellow,

Norman, when I run the script I get an error "400" with no
explanation.I've double- and triple-checked the myPath path
(which is actually "D:\WORK\=ACCOUNTING\Invoices Pending",
and not as I specified in my first post) and it checks out. So does
the worksheet name.


What could the problem be?


I regret that I can only refer you to a post by Tom Ogilvy:

http://tinyurl.com/kask3


---
Regards,
Norman