Posted to microsoft.public.excel.programming

Little Penny[_3_] Little Penny[_3_] is offline

external usenet poster

Posts: 48

ActiveWorkbook.SaveAs

I'm using the bit of code to save my workbook base on the value in a
cell.

ActiveWorkbook.SaveAs FileName:=FiName

But it always savse in the my doc folder. Can I force it to save in
the folder of my choice.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Help with ActiveWorkbook.SaveAs	Martin X.	Excel Programming	3	August 15th 07 02:15 PM
ActiveWorkbook.SaveAs	franks	Excel Programming	6	August 6th 07 10:04 PM
ActiveWorkbook.SaveAs Returns	BHatMJ	Excel Programming	3	May 19th 07 02:31 AM
ActiveWorkbook.SaveAs problem	SandyUK[_11_]	Excel Programming	2	November 14th 05 02:54 PM
activeworkbook.saveas	J Silver	Excel Programming	0	June 25th 04 09:01 PM

All times are GMT +1. The time now is 01:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us