Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error when already same name / Macro save as cell contents NeedToKnow Excel Discussion (Misc queries) 2 June 19th 08 04:40 AM
Create filename based on cell contents JR Hester Excel Worksheet Functions 7 April 4th 07 11:34 PM
Create filename based on cell contents Rudy W Excel Programming 2 December 3rd 04 03:23 AM
Automatically include contents of a cell in "Save As..." filename. Bryan Linton Excel Programming 1 September 1st 04 12:14 PM
using a macro to define the contents of a cell as the save as name SeanMagoo Excel Programming 1 September 3rd 03 10:59 PM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"