savefile

Hi all! 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 prd=ThisWorkbook.Sheets("Main").Range("I10").value...

Hi, 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...

Hello. is it possible autorun this VBA code when i open a excel file? Sub SaveThis() Application.DisplayAlerts = False ThisWorkbook.Save Application.OnTime Now + TimeValue("00:30:00"), "SaveThis" End Sub

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! Ped:)