Save a macro enable Excel file in a specific location with VBA.
Save a file in a specific location with VBA. Save a file with different file formats with VBA.
51 = xlOpenXMLWorkbook (without macro’s in 2007-2016, xlsx)
52 = xlOpenXMLWorkbookMacroEnabled (with or without macro’s in 2007-2016, xlsm)
50 = xlExcel12 (Excel Binary Workbook in 2007-2016 with or without macro’s, xlsb)
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Great video thanks , would u please help me how u run report as per date in same location ie.. day 1 day 2 day 3 so that having month reports in daily basis
Hi, I like your macro, what if I send the file to my friend? Would it be on the same location?
Thank you so much
Very helpful and easy to use. Thank you
How can be done without a path? only the name and type of the file to appear
How to save axcel file to word files with macro
This is a great video, thanks for the share! Is there a way to have the file path be a cell reference as well? If so, how would you go about doing that? Thanks in advance for your reply.
Run Time Error "1004"
Microsoft Excel Cannot Access the file 'There are several possible reason:
> The file name or path does not exist.
> The file is being used by another program.
> The workbook you are trying to save has the same name as a currenty open workbook.
Hello again, Barb. I have utilized many great features you have taught and mentioned in your videos. Thank you for providing them to us. I have a question about the path to save a file. If I provide my macro enabled Excel file for others to use and because their path to save the file would be different from mine (E.G. mine is C:UsersJoeDesktopProject _Name and another user would be C:UsersBillDesktopProject_Name), is there a way in ExcelVBA to just save a file to any users DesktopProject_Name folder without having to change the coding for each macro enabled Excel file?
I followed instructions and it worked. I would like a display alert and prompt me yes or no if saving suplicate
i followed your instructions but i cannot get a new excel file saved. the active workbook just closed and nothing happened thereafter, no files can be found in the specified location. what should I do? Thanks.