filecopy vba error 70 Mannford Oklahoma

Address Tulsa, OK 74146
Phone (918) 378-2225
Website Link
Hours

filecopy vba error 70 Mannford, Oklahoma

You may have to register before you can post: click the register link above to proceed. Show: Inherited Protected Print Export (0) Print Export (0) Share IN THIS ARTICLE Is this page helpful? It has not been a good day. Public Function fCopyFile(strFileName As String) As String Dim lstrSource As String, lstrDestination As String On Error GoTo ErrfCopyFile Thanks for the help!

Advertisements Latest Threads Happy Birthday Captain Zed! You'll be able to ask any tech support questions, or chat with the community and help others. Thanks ""Peter Yang[MSFT]"" wrote: > My pleasure! > > Best Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > Microsoft Online Partner Support > > > ===================================================== > > When Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More...

Peter Yang[MSFT], Mar 31, 2008 #10 TomT Guest That did it Peter, thanks very much for your help.... ""Peter Yang[MSFT]"" wrote: > Hello, > > Based on my test, this issue See if you can do that. I am trying to use the filesystemobject FileCopy command, but get the error "70 - permission denied", even though I have full control permissions on the file and the folder to Put a STOP just before the copy line.

ok Else Call MsgBox("CopyFile failed") End If HTH Matthias Kläy -- www.kcc.ch Matthias Klaey, Mar 26, 2008 #3 Peter Yang[MSFT] Guest Hello, You may also want to run as administrator Is it OK for graduate students to draft the research proposal for their advisor’s funding application (like NIH’s or NSF’s grant application)? Have tried: ... The time now is 12:34 PM.

If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Here's what I'd try: 1. Reply With Quote 12-23-2011,06:08 PM #4 GTO View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Sep 2008 Posts 3,254 Location Hi Fadib, You are most welcome current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list.

Is there a place in academia for someone who compulsively solves every problem on their own? Member Login Remember Me Forgot your password? Sign Up Now! To do this, I have a button on a form which calls the copy routine.

I have figured out the problem:>> Very good. therefore, I am using window API to move the file and copy it to anothe place. The error is because I selected the source folder as the destination folder in the Save As dialogue box Last edited by jmsrickland; May 6th, 2011 at 02:21 PM. Get 1:1 Help Now Advertise Here Enjoyed your answer?

Cover an unusual board with minimum chess rooks Pronuncia strana della "s" dopo una "r": un fenomeno romano o di tutta l'Italia? dialogue box All information is correct and I am the administrator and I own the website from which I am downloading a file I put there myself which shouldn't have anything more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation You must do that, by Saving any current data that is being edited.

Can a Legendary monster ignore a diviner's Portent and choose to pass the save anyway? Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Is there a way to test if the Error 70 will occur before attempting it? If you wanted to inspect/ite… MS Access How to underlay a section in Microsoft Access Reports Article by: SeyerIT I originally created this report in Crystal Reports 2008 where there is

Why are so many metros underground? Hello and welcome to PC Review. Isn't that more expensive than an elevated system? The permissions for the file are set > for > full control for all users. > > Here is the sub: > > Public Sub CopyFile() > > Dim fs As

Join them; it only takes a minute: Sign up What causes Error 70 in Excel VBA? If I use the File System Object can I be sure that any data from the form has been written to the backend file? Thank you. Get 1:1 Help Now Advertise Here Enjoyed your answer?

With windows explorer, go to the folder in question, right click and try creating a new text file. Thanks, Jnana Jnana Sivananda Thursday, May 02, 2013 5:34 PM Reply | Quote Answers 2 Sign in to vote Public Function Copy(FileSrc As String, FileDst As String, Optional NoOverWrite As Boolean Here is the sub: Public Sub CopyFile() Dim fs As Object Dim isthere As Boolean Set fs = CreateObject("Scripting.FileSystemObject") isthere = fs.FileExists("c:\Database\Accounting\UpdateAssetMaster.bat") If isthere = True Then fs.CopyFile "c:\Database\Accounting\UpdateAssetMaster.bat", "c:\database" End Privacy statement Community Resources O365 Technical Network MSDN Forums UserVoice Stack Overflow Follow Us Twitter Facebook Office Dev Blog © 2016 Microsoft United States - English Terms of Use Trademarks Privacy

gajendraks, Jun 29, 2012 #17 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? Remove the write-protection device from the disk or open the file for Input. JimD. 0 LVL 92 Overall: Level 92 MS Access 50 Visual Basic Classic 33 Message Active 1 day ago Assisted Solution by:Patrick Matthews2010-06-24 Hello sjlevine34, Error 70 with CopyFile is Not very familiar with VBA - would really appreciate some help on this!!