xlsx

  1. J

    How to detect / bypass the Workbook Recovery window and process

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

    VBA Code to show two different file types

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

    Save as Workbook

    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:= _...
  4. B

    Save As Non Macro Enabled Worksheet-VBA

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

    Get File Format Using File Content

    how can i get the file format of pptx, docx, xlsx files with vba without using their extension?
  6. BlakeSkate

    Insert 1st sheet of most recent xlsx file from directory [vba]

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

    Load and merge xlsx into xlsm workbook

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

    Any chance mdb to get data from xlsx

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

    convert xls to xlxs files.

    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...
  10. XL Pro

    Save as v2007 explicitly?

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

    VBA to copy/paste formatting from open XLSX file to many closed XLSX files

    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:
  12. C

    Convert CSV to XLSX keeping columns and unicode

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

    Run-time error '1004': Method 'Activate' of object '_Workbook' failed only on new PC

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

    Best way to run a macro on every xlsx file in document?

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

    Macro works perfect on xls.files but not on xlsx.files

    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 =...
  16. N

    Saveas XLSX

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

    Loop through a folder of XLSX and add cell contents to filename?

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

    Help to get XLSX sheet back into remainder of Access Db, please?

    I have a database in Access 2010, flat table with no relational tables. I was required to send the ‘Membership’ data to ‘head office’ for data cleansing, re GDPR requirements so I chose to send only name, address, contact details and not the other fields I have developed. The...
  19. S

    Copy data from an XLSM worksheet into a XLSX worksheet

    The XLSM file is called FileA.xlsm The XLSX file is call FileB.xlsx I'm trying to copy data from the XLSM tab into the XLSX tab. Let's say the tab to I want to copy from is call COPYFROM and the tab in the XLSX is COPYTO. I know the code to open the xlsx file. Workbooks.Open...
  20. I

    Power Query - change Text to Date

    Hello I import & consolidate multiple files from the same folder using Power Query. The file name is "XXX 210618.xlsx" and I use below code to extract date from the name of the file when importing data. Text.Replace(Text.End([Source.Name],11),".xlsx","") My issue is that once imported 210618...

Some videos you may like

This Week's Hot Topics

Top