deleting a file without an address

[sassriverrat]

anyone know how to get excel an open workbook without specifying an exact address?

 

[Yongle]

Your title does not match your question

What are you trying to do?

 

[bobsan42]

I believe the post (and title) was edited because I was posting this:

save the filename before saving the file to the new location. After successful ssaving delete old file.
something like this:

dim varFile as string
varFile = thisworkbook.path & "\" & thisworkbook.name


.... your code for saving to new location ....


Dim objFS as object
Set objFS = CreateObject("Scripting.FileSystemObject")
objFS.DeleteFile varFile, True

 

[sassriverrat]

sorry.

So if I took a workbook, dragged it onto the desktop, saved-as into documents (so now I have a copy on the desktop and a copy in my documents folder), and then I wanted to kill the original file that was on the desktop, how might I go about doing that? Note: Maybe i want to drag the original somewhere else, so I can't specify the desktop...it's gotta be dynamic. Does that make sense?

 

[sassriverrat]

awesome so just to make sure (and I need to put a copy on my thumb drive before I start experimenting!),

put the code in, by my code for saving-as, the second part of your code will delete the original file, regardless of where it was saved? And presumably I cannot have both files named the same thing...despite being in different locations?