Saving Excel file without Opening (from windows)

[Jabba69]

Sorry if this is in the wrong place...

No idea if this is even possible, but is there a way I can just save an Excel workbook without opening - in order to save as current date/time?

I already have multiple Macros that Open files, refresh reports, save, put in a given location etc etc.
But occasionally I want to send a report to a customer that may have been created a few days ago (and I don't want them to know that it's been ready for a few days). I usually just open it, and save and close.

it would be really useful if I could somehow just save it without opening.

Any ideas if this is possible?
Thanks

[kev_]

The easiest (and safest) way to do this is by opening and closing a file (rather than by fiddling with file attributes)

Try this:
- save the atttached file to the Desktop
- double click on it to open the file
- browse to your chosen file
- click open
- file is then Opened, Saved & Closed
- attached file is also closed

When you first open the file:
- {ALT} {F11} get's you into VBA area
- double click on ThisWorkbook in left panel
- the module with code below should open up
- modify the folder from C:\TestArea\ (remember the trailing "\")
- after modifying the path, remove the apostrophe that I have placed in front of OpenAndSaveAFile
(which currently prevents it from running to allow you to change the path)
- then save the file and double click on it to open it again

In ThisWorkbook module:

Please Login or Register  to view this content.

[TMS]

Why don't you just rename it in Windows Explorer?

[Jabba69]

Thanks Kev

I have something similar, which I use when I need it for a folder which contains a load of files. But I'm looking for a more 'quick and dirty' approach, where I can just action on the odd file here and there directly from windows.

[TMS]

But I'm looking for a more 'quick and dirty' approach, where I can just action on the odd file here and there directly from windows.

See Post #3

[Jabba69]

Why don't you just rename it in Windows Explorer?

Thanks. But this doesn't seem to save, just re-names. Ie, the 'Data modified' and 'Date last saved' attribute stays the same.

[TMS]

Maybe this then: https://www.online-tech-tips.com/com...s-and-folders/

[kev_]

You cannot be dealing with a huge number of files, so this should work for you

Why not save the files into nominated folders and then
- when the PC boots up every morning auto-Open Excel file that contains a macro to open, save and close all the files in those nominated folders
(you say that "I have something similar, which I use when I need it for a folder which contains a load of files")

Painless - everything dated to today's date without any user involvement

[Jabba69]

Thanks Kev, TMS...

I think there are a few ways around it, but that they are perhaps over-complicating it a bit.
For these where its just the odd file, I can just open, save, close in a few keystrokes I guess. I was just being lazy, and hoped there was a magic windows explorer shortcut button to do it!


Thanks anyway!

[TMS]

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[kev_]

Thanks for the rep

[TMS]

Ditto. Thanks for the rep.