Move a file created by macro

[sunilbsrv2k]

Hi All,

I have a macro file, which on opening will create a file and save it in a folder.

I have created another macro to open the above macro file.

My question here is to move the file created by the above macro to a different folder.

Please help.

Below is my code:

Sub fcr_macro()

Dim wb As Workbook
Dim clname, compname As String
clname = Range("D2").Value
compname = Range("D3").Value
Set wb = Workbooks.Open("<path/file>")

wb.Close
End Sub

 

[Keebellah]

open the file
save the filepath to a variable
save the filename to a variable
set a variable with the destination path
close the file
filecopy the path and oldfilename destination path filename
kill original filepath and name

and all this in correct VBA syntax filecopy and kill are evalid commands, you do not have a file move or move command

and save the fullpath (path and filename) to a variable
close

 

[Fluff]

Have a look at Ron's site https://www.rondebruin.nl/win/s3/win026.htm

 

[Keebellah]

Ron's a great site

the syntax, just in case...

FileCopy myFullFileName, newPath & newfName
Kill myFullFileName

Of course you have to set the variables and the values for each, don't forget the final backslash in the newPath

 

[sunilbsrv2k]

Hi All,

Thanks for your reply. Even the website you shared is also very good.

However, my issue here is slightly different.

the codeline: Set wb = Workbooks.Open("
") will open a file that contains a macro. And this macro will create a file in a folder.

I want this file created by above macro to be moved to a destination folder. And I want this to be accomplished in the above code mentioned in my first post above.

Could you please throw some light on this

Thanks
</path>

 

[Keebellah]

You’ve got all the code you need so just place it in that macro an let do its work
I’ll see if I can pick this up after the soccer games later this evening

 

[Keebellah]

Can you paste the code from that workbook that opens the workbook and creates the file?