xlsx

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

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

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

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

Hello, I found a snippet of code that will loop through a folder and do a specific function (i.e. insert a formula). I am looking for one of the functions to be changing the extension from CSV to xlsx without creating a new workbook. Can any one share the line of code that will perform this...

I need some help. I want to check if the folder contains xlsx file, if there is just one then the code should follow. If there is no xlsx file in the folder the macro should stop. For all different extension sotp as well. I have been blocked if the first file has different extension. Sub...

Hello I am saving a file from xlsx to csv (for upload to our system). However, the date formats required are yyyy-mm-dd - which I have done in the xlsx. But when saved to csv it doesn't retain that format. Any ideas? Thanks in advance. M:)

Is it possible to create a macro to transfer a xlsx worksheet to a xls workbook. (Possibly by using VBA code).

Hi, I have the following VBA script that works perfectly. But it saves the file as an XLS file and I need it to save as an XLSX. I've tried just changed the "(*.xls)" to "(*.xlsx)" but that doesn't work for me. Please help! Thanks!! Sub Save_File() Dim file_name As Variant file_name =...

Hi all, I am wanting to have a random number generate button that generates a random number (between 5000 and 20000) in cell J2. I am needing to distribute the file as a XLTX. I would like for the button to only show until it is clicked to generate the random number. The workbook is protected...

Hi, Im wanting to: Filter a named range (MyRange01) by a value in H1 Save range as XLSX with H1 as filename Loop this through values H1:H50 until blank Example: if H1 = london Filter Myrange01 column B by value H1 Save as an XLSX named: london.xlsx Is this doable? I have vba to save sheets...

I have some XLSM files that I need to send to some people who know VERY little about Excel, much less how to deal with changing their settings to use an XLSM file. I only need for them to see the content. I have already massaged the data in to the form they need it to review it. HOWEVER, when...

Good Monday morning to you! Is there a way to make it so an XLSX will pull data/reference a CSV file in the same folder? Right now I'm simply opening both files, copying the CSV and pasting the data into a tab in the XLSX. I was wondering if there was a way to eliminate the need for the copy...

Hello. I am trying to create code that copy and pastes information from sheet 1 (the whole sheet) of an xlsx file, we'll call it "Workbook 1", located on a users desktop (could be any user, but will always be on their desktop), into sheet 2 of a different xlsx file, called "Workbook 2". The...

Hi, Is it possible to add a vba script to an xlsx file or do I need to save the file as xlsm? Thank you for your help, Nick

good afternoon, I am looking for a way of relinking back end tables if the links get broken. back end file name changes sometimes. my links are not just a back end single accdb, there are 3 accdb's and 2 excel xlsx or xlsm files. I used access to link them, however when updated back ends...

We have a database that we need to reformat to be able to through into Access. I need change the spelling of addresses to conform to certain parameters (e.g. dr instead of drive or dr., st instead of street, ln instead of lane, (650) instead of 650 or 650-.etc). The data needs to be changed i...