-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
savefile
-
J
VBA Wb.Save causes Excel to Crash
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...- jscranton
- Thread
- application.displayalerts error excel savefile true
- Replies: 1
- Forum: Excel Questions
-
B
Excel VBA Save Workbook as current workbook name
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...- benjigarc123
- Thread
- activate sheet excel macro save workbook savefile
- Replies: 0
- Forum: Excel Questions
-
Save files as date & time by default! This may be simple and I'm trying to figure out myself too..
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:)- pedie
- Thread
- savefile
- Replies: 19
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
Excel VBA Parse Column A into multiple columns help but with conditions
- Started by BalloutMoe
- Replies: 57
Hello, I have a TXT file that gets imported in excel and it always ends up in column A. I am trying to split the data up however. The middle... -
Data with Different score
- Started by sksanjeev786
- Replies: 30
Hi Team, I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data... -
Looping a macro through all visible sheets?
- Started by GlennJ
- Replies: 29
I have a macro that does exactly what I need. I just need it to do the same thing to all sheets. Any help would be appreciated. [CODE=vba] Sub... -
Loop through Column, looking for an array of values, If NOT found, delete entire row
- Started by blbat
- Replies: 29
So I tried to modify some good code from Joe4, but ran into some walls. I'm trying to modify his working loop to cycle through Column "D", find... -
VBA to extract values starting with specific character
- Started by sncb
- Replies: 21
Hi all, I paste two cells of data into A1 and B1 with different formats and spacing like below and I need to extract only those values that start... -
macro/vba fix for not a blank, blank in Go To Special
- Started by LorettaAlsop
- Replies: 20
I am writing vba code (thru using macros) to format a ws. In a portion of the formatting I identify the blank cells and replace them with the cell...
