I have a macro that saves a file on the same location the original file was but with a different name. I run the macro and it works fine (and the same with other team members).
When I share this file with some folks from China they run the macro and it seems that it doesnt work. The...
Hit type mismatch error at the saveas filename row , and i believe its because there is a mixture of string and integer for the variable in the filename. Can anyone advice on this?
Dim prd as string, dept as string, yrs as integer
I'm trying to find a way to add a ''save'' function at the end of my macro to save my file in Excel format (originally a .txt file), while keeping the same name the .txt had. I was able to either do one or the other (Excel file that didn't retain the original name, or text file with the...
is it possible autorun this VBA code when i open a excel file?
Application.DisplayAlerts = False
Application.OnTime Now + TimeValue("00:30:00"), "SaveThis"
I have some code that performs a number of operations on some excels, saves them and moves them to a new folder. I have some currently that are crashing Excel on the Workbook.Save command. I turned on Alerts and created an error trap but Excel just crashes. How can I figure out what is going on...
Hello, I have this file 08.22.2017_13.07.34.csv whose name changes daily with respective date and time. Using the macro below i am only able to use it with this file name. What I want it to do is be able to use it with any excel file that i open. I also want it to save using the current...
When i save the WORKBOOK's name by default it save as BOOK1, but I want it to be today's (=now) date and time instead on Book1...Is that possible...
I check the options the can't seems to locate it:biggrin:
Please help thanks!