Posted to microsoft.public.excel.programming

Gary[_11_] Gary[_11_] is offline

external usenet poster

Posts: 7

moving folders

I am trying to move a folder from "quotes" to "sales" and
cannot get it right. What is wrong?
Sub Move()
Dim sFolder As Scripting.folder
Dim sDestination As String
Set sFolder = "\\quotes\" & ActiveSheet.Range("S7")
& "\" & ActiveSheet.Range("h14")
sDestination = "\\Sales\" & ActiveSheet.Range("S7")
& "\" & ActiveSheet.Range("h14")
MoveFolder sFolder, sDestination
End Sub

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
Moving text around cells without moving boarder lines	Dale	Excel Discussion (Misc queries)	1	December 15th 09 06:14 PM
Arrow Keys Moving Window Frame instead of Moving Between Cells	nemmex	Excel Discussion (Misc queries)	2	April 9th 07 09:08 AM
Offline folders	Stefano	Excel Discussion (Misc queries)	0	January 24th 07 12:45 AM
Personalize folders	César G.	Excel Discussion (Misc queries)	2	April 5th 06 04:20 PM
Moving workbooks between folders	Ozzie	Excel Discussion (Misc queries)	3	January 25th 06 09:25 AM

All times are GMT +1. The time now is 10:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us