Solved

Moving Files

Posted on 2003-10-29
5
186 Views
Last Modified: 2010-05-03
All I want To Do is move  a file from location Text1.Text to location of Text2.Text from a Command Button thanx in advance!!!
0
Comment
Question by:mattewjones
5 Comments
 
LVL 8

Expert Comment

by:ampapa
ID: 9640939
Do you mean move the text from text1 to text2?
0
 
LVL 51

Expert Comment

by:Ryan Chong
ID: 9640964
Try:

Name Replace$(Text1 & "\" & fileArr(i), "\\", "\") As Replace$(Text2 & "\" & newname, "\\", "\")
           
0
 
LVL 51

Accepted Solution

by:
Ryan Chong earned 50 total points
ID: 9640971
oops, should be simplified to:

Name Replace$(Text1, "\\", "\") As Replace$(Text2, "\\", "\")

of course, add the validation if necessary.
           
cheers
0
 

Author Comment

by:mattewjones
ID: 9641080
spot on thanx!!!
0
 
LVL 11

Expert Comment

by:dbrckovi
ID: 9641247
This is how i understood your question.

In VB, under Project, select references. Click 'Browse' and find a file scrrun.dll  (Should be in ...\System32 directory)
Click Open and OK.   Then use this code in you button.

For copiing:
------------------
Private Sub Command1_Click()

    Dim fso As New FileSystemObject
    fso.CopyFile Text1.Text, Text2.Text

End Sub


For moving:
------------------
Private Sub Command1_Click()

    Dim fso As New FileSystemObject
    fso.MoveFile Text1.Text, Text2.Text

End Sub

0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Notepad++ how to remove delimiter : from beggning of the line? 3 114
Add a task in Outlook from access 11 42
clicking a shape in a frame array vb6 3 47
TT Auto Dashboard 13 95
Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question