Save File

**ddbusiness** · 10-01-2010, 06:47 AM

I am having trouble saving a file in a different location but using the same file name.
I open the file from the "C:\Aus_Nav\2011\August" folder and then I change the data automatically through some other code and then after that code is run I want to save it by default back one folder "C:\Aus_Nav\2011\" folder. I want it this way as next year the opening folder would be "C:\Aus_Nav\2012\August" and I would want it to be saved into "C:\Aus_Nav\2011\". Even better would be to save it into the a folder that is the current month the file is being saved (I don't think this 2nd option is possible and that's why I suggest the other option).

The "Application.Dialogs(xlDialogSaveAs).Show" uses the same file name as I want but it saves it into the same folder it was opened from. I've research for many hours and tried several ways but have succeeded.

I would appreciate any help anyone can give me.

**snb** · 10-01-2010, 07:41 AM

Please Login or Register  to view this content.

**royUK** · 10-01-2010, 07:43 AM

What code have you got now?

**ddbusiness** · 10-01-2010, 06:48 PM

Sorry I did not reply last night as I went to bed just before you replied RoyUK being 10pm in Sydney.
The code snb sent I can't get to work as it saves it in the same folder listed on the first line of the code.
Myself when I posted this I was only using the dialog save as code.

Please Login or Register  to view this content.

**ddbusiness** · 10-01-2010, 06:51 PM

It seems the the code only saves it in the same folder list in the first line (August) of the code and not rather than (2011): one folder down from the original
Sorry I shut my computer down just as you sent your reply as it was late in Australia.
Thanks for any suggestions

**ddbusiness** · 10-03-2010, 04:18 AM

I've come up with some other code but it doesn't quite work.The dialog box does save a file in one folder up from where the file was opened from so I can choose a different folder under it. But now I loose the original filename in the dialog box. The dialog box does not have a filename listed. Thanks for any help you can give me.

Please Login or Register  to view this content.

**snb** · 10-03-2010, 11:42 AM

Please Login or Register  to view this content.

I fear your eyes were to tired when you tested.
Prerequisite for the code to work is that the filepath has more than 1 subfolder.

**ddbusiness** · 10-05-2010, 11:47 PM

With help from a few the following has helped me resolve this.
Thanks

Please Login or Register  to view this content.

Save File

LinkBack

Thread Tools

Rate This Thread

Display

Save File

Re: Save File

Re: Save File

Re: Save File

Re: Save File

Re: Save File

Re: Save File

Re: Save File

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions