saving file

Hi there, I'm looking to take a document, and save each page as a separate Word doc. I lifted the code from Word's website to split the document, so that's fine. However, I'd like to name each page based on a textbox within the document, and I'm not sure how to do that. Is it easier to: (a)...

Each day a receive an email containing an .xls link which has various tabs of data. What i would like to do is, when the email arrives, to automatically open and save the sheet to the hard drive, in a particular location with the date added on the end! ie: newfile010416.xls im very new to...

I would like for the user to be able to choose the path and filename to save a file. I can embed the path and filename in the VBA code but I would like normal Excel save screen to be displayed. can anyone help please? Thanks, Bernie This is my code with embedded path Sub ExportToFile() ' This...

Hello All, I have around ~100 users who are divided into 5 batches, they work on spreadsheet that has been shared on a network. My BIGGEST challenge is that since it is a shared spreadsheet it often leads to crashing or some or the other error popping up when opening the file. I somewhere read...

Hey folks, greetings! I have been dealing with this issue for a while already. Because of my work I must create files and save them with variable name (date of creation), the format should be CSV. I made a macro that makes all the work for me, taking the name from a specific cell and saving...