So whenever I attempt to save a fresh excel file, it will have my default save as option as XLSX.
But I frequently have to download XLS files and then edit them. Whenever I finish I go to save as, and it tries to save it as a text (tab delim) file every single time.
I have checked and confirmed...
I am a lead maintenance mechanic and trying to figure out how to create dated shift reports. Our naming system is
(Master file is named "Shift Report.xlsx")
Shift Report 7-16-2021 D1
Shift Report 7-16-2021 N1
Shift Report 7-17-2021 D1
Shift Report 7-17-2021 N1
etc...
I have to generate these...
Hi All
I have a macro in which I have to change the folder adress everytime I want to convert CSV to XLSX. how do I make it read the folder that I copy the excel file in it ? and how do I convert the tabulation of those CSV file that have semicolon ; to xlsx with separate columns ?
this is my...
I'm working with a Word/VBA system, and as it goes, it opens an XLSX to get some information from it. One of many users reported that nothing came from the XLSX, so I manually opened Excel to open the file which the code should have opened, just to prove it wasn't a permissions / access issue...
Hi
I'd like to run code which opens a folder and only shows two specific file types (binary and xlsx files).
I've got the code below, but it only shows xlsx files when run.
Does anyone know why binary files are not shown, as well?
TIA
Sub BinaryOrXls()
Dim fd As Office.FileDialog...
Hi,
I have macro excel Sheet and I would like to save as xlsx format with application.username along with ddmmyyhhmmss in a specific folder without closing excel macrowork excel sheet..
Please advise if we can copy clipboard on last saved xlsx worksheet.
ActiveWorkbook.SaveAs filename:= _...
I was trying to create a macro that when I open a workbook that is macro-enabled I could simply run some code that will change it to an xls or xlsx and save it as the current file name. I need it to save it to its current location. Thanks as always
I'm looking for a way to insert an entire sheet from whatever the most recent xlsx file is from a specific folder location
so lets say theres 3 xlsx files in "C:\Users\bsnyder\Desktop\Excel Program\backups"
i would want it to automatically insert a sheet with the data of the first sheet of the...
Hi.
I am having trouble visualising the best way forward for this problem.
I currently have a master workbook with three sheets A,B,C
Within this master workbook, there area a number of buttons and VBA code On sheet "A" , and one for example can duplicate sheet A, to A1, A2 etc.
I then...
I know accdb is better to be used to get linked data from xlsx.
But for some reason my platform can only use mdb.
Anyone got any experience mdb can also get linked table data from xlsx ?
Help...
I found a macro online that works to convert .xls files to .xlsx files. But it works for one file at a time. I would like to modify this code so it loops through all the files found in a folder. Folder path is static (does not change). Currently I have these files in...
In XL 2016:
Is there a VBA fileformat for saving an Excel file explicitly as ver 2007? I have a legacy program that can read an Excel 2007 xlsx file, but not 2016.
I have an open xlsx file with a page that has formatting that I want to copy/paste (formatting only) into a number of other single-page xlsx files in the same folder. How can I do this using VBA?
:confused::confused::confused:
I have a directory with semicolon-delimited CSV files containing unicode signs. I try to convert them to XLSX using the solution from this thread, but fail in important parts:
the code makes XLSX from CSV, but all CSV data comes into the same column and all unicode signs are broken. However, if...
Hi Folks,
I have an old excel model last modified in 2010 that was written by a pretty decent VBA / SQL programmer who has since deceased.
All our old machines are running Windows 7 professional on a 64 bit OS using 32 bit Excel 2013 (8 gb RAM).
A new PC installed recently runs...
Hi Everyone,
I was hoping someone could help me.
I need a macro that can got to a folder
FOLDER_PATH = "F:\MY Docs1\New1\Run New Project\Data 1 sheets"
and open every xlsx doc only then run a macro call "repair1" then close and save
any ideas the best way to do this bearing in mind the folder...
Dear All,
Run time error 1004 when using sheet with more than 65000 lines .xlsx ). Even if they are not used.
I fear it has to do with the way I search the last used row.
Endrowhelp = Firstref.Column
Cells(50000, Endrowhelp).Select
Selection.End(xlUp).Select
myEndRow =...
Hi All,
I have a macro where it needs to saveas the file as Xlsx and its works fine, however in few names i have issue.
I have the file names in column A and this would be used as file name while saving.
for example :
UVVSA SA DW CV this saves as UVVSA SA DW CV.xlsx
But the issues is that...
Hi,
I'm wanting to loop through all XLSX files and add the cell contents of Sheets("Sheet1").Range("B1") to the end of the corresponding filename.
Is there a quick way to do this?
Thanks for any help
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.