extension

I have a workbook that I am making copies of and saving those copies as different names. For some reason, what appears to be random, some of the files don't get the .xlsx extension added to the saved file. The files are being saved with the correct name convention I setup, but the file...

Sheet1 contains the data <tbody> Department Position Name Extension </tbody> What I would like on sheet2 is Row 1 = 1 merged Column with Department Value Centered Row 2 = Column 1 Position, Column 2 Name, Column 3 Extension Repeat while Department Value is the same, when the Department...

Hi, Is it possible to save the Active Sheet data to the desktop as a text file using the Active Workbook Name and the file Extension .asc instead of .txt. I need to save it as tab delimited if the workbook name starts with the Letter A if not then save as comma delimited. Also If this can't be...

The excel files corrupt when saved to a file server instead of the file there is a folder with the file name of the excel file plus a number of extra charactors (random) and in the folder a file with a randon group of letter and numbers for a file name but no extension. This file can be...

Some of my excel Files on Servers have been renamed with the extension .arena. I tried renaming the files with appropriate extension, however the file remains unreadable. The applications will try to open the file but it says it is corrupted. Any help is greatly appreciated. Thanks

So when someone sends me an excel document I can open it as an attachment. But if I right-click the document to save it locally and then browse to it I get an error that says "excel cannot open the file "Filename" because the file format or extension is not valid. Verify that the file has not...

Hi, I have a macro which runs a routine on a number of files. I wrote it in Excel 2013 and have been using it successfully on that version for close to a year. However, today I tried to run it on a different computer which has Excel 2010. For some reason when the macro opens a workbook, the...

Sub PasswordSave()Application.DisplayAlerts = FalseApplication.ScreenUpdating = False SaveAsName = Application.GetSaveAsFilename( _FileFilter:="Excel Files (*.xlsx), *.xlsx") ActiveWorkbook.SaveAs Filename:=SaveAsName, FileFormat:= _xlNormal, WriteResPassword:="test", ReadOnlyRecommended:=False...

Sub Deleteexcel() 'You can use this to delete all xls files in the folder Test On Error Resume Next Kill Application.ActiveWorkbook.Path"*.xls" On Error GoTo 0 End Sub I have code above that is trying to delete every file with xls extension. I have wrong syntax, but no idea...

I have a spreadsheet that I open, selected a directory, and it gets files that are going to be put through a GIF creation process and a rename process. The problem is that there is currently no filtering applied in the code. I am a bit of a noob but can understand very very basic vba, just...

Hello, I have a code that works well for saving to multiple locations. However, I would like for the code to check for existing files in BOTH locations and if one exist then to save under sme name with different version. i.e testfilev1. Hope I explained that right. thank you very much...

Hello, I have code that will open up a couple thousand excel files over the years one at a time and run some code. However, the extension has changed over the years. I was wondering is there a way to have excel open up all the different file types with variable file names. My guess so far is...

Hey Everyone, I have a list of 7000 contacts. This list includes separate columns for first names, last names, addresses, zip codes, etc. In the phone number column the extension is also included. However, I need the extensions to be separated into their own column. Is there any trick to doing...

Hi all, I'm using the below code to prompt users to save the finished output from a macrobook and while the file can be opened safely, it throws up an error message; "the file you are trying to open, "...filename here...<FILENAME>" is in a different format than specified by the file extension...

Hi, I would like a macro that performs the following, however I don't really know where to start. The macro should... 1. Autofill dates from the Start Date ("D5") for x amount of years. Autofill begins in Range("C10") 2. Point out the THIRD 'wednesday' of every month with a "1" in column D...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

We're doing a data migration and I have a phone number field with no standard of format. Some phone numbers have (-) dashes some have (.) periods between sets of numbers, and some have phone extensions on the end with either x###, X ####, ext ###, and some other variatoins. The extensions will...