file format

Hello friends, I'm trying to save an Excel file with VBA code to the location C:\Users\Work\Desktop\Google Drive. I am able to successfully do this with ActiveWorkbook.SaveAs ("C:\Users\Work\Desktop\Google Drive\" & varEventName & " " & varDate & " " & varReportType & ".xlsx") However when...

Hi, I currently have a macro in my file (XLSM) which has a step where the user saves out the workbook in the current format. Sub SaveAS_Final() Dim strName As String SvName = Sheets("Instructions").Range("C51") Application.Dialogs(xlDialogSaveAs).Show SvName End Sub But since my...

Hi, I am using the below macro to spilt my original workbook into many different workbooks and the macro works perfectly but I have two questions. The first and main on is: Is there any way I can save the new files in .xls format instead of the format of my original file which is macro...

I'm working in xl2010, and have a workbook with ~70 sheets. I'd like to save the sheets as individual .csvs, each with the name of the sheet. I tried using the following code: Option Explicit Sub SaveShtsAsBook() Dim Sheet As Worksheet, SheetName$, MyFilePath$, N& MyFilePath$ =...

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

Anyone have a list for all of the file format numbers? I've done some poking around on the interwebsbut have only come up with the following... <o:p></o:p> <o:p></o:p> FileExtStr = ".xlsb": FileFormatNum = 50<o:p></o:p> FileExtStr = ".xlsx": FileFormatNum = 51<o:p></o:p> FileExtStr = ".xlsm"...

Hey All Thanks for your help in advance, My Issue: This code works fine but my main question/issue is the difference to when you manually save a .CSV (MS-DOS) File you are prompted with the following message " .csv may contain features that are not compatible with CSV (MS-DOS). Do you want to...

I have a large Excel file that I believe was originally created in Lotus 123. The file has been converted over the past 10+ years to each new version of Excel etc. It's been actually "Converted" using the menus in Excel and has been "saved as" xlsm and xlsb. I think creating a fresh file that...