xlsx

Good Evening, I have the following code which I want to be able to loop through all the files in a folder that will change daily. The code itself basically opens up a data delimited file, converts to excel and then deletes the original file. At the moment I can do it one by one and it works...

Hello Members, I have a file that is imported to my C:Drive from a company system; however, I am only able to import using a xls extension. The imported file exceeds the maximum rows for xls; therefore, it creates additionally data tabs. I need the file to be in xlsx format all in one sheet...

On my desktop a folder named data, how to delete all files with extension txt ,xlsx,xls but not to delete xlsm and csv with vba. There 1000 files in that folder

I would like to click a macro button and download an xlsx file as new sheets on my current excel file The link: http://us.spindices.com/documents/additional-material/sp-500-eps-est.xlsx?force_download=true It has multiple sheets and I would like for the vba to add those sheets onto my current...

I am working with a successful macro in saving the document via clicking a macro control button. However, I was wondering if there is a way to have the document save to another format. The reason is that some of the people on distribution for this form are pulling it up on their cellphones...

Hi Mr Excel Expert, Please help ... I have huge CSV file with about 4 Million rows. I need macro to open that CSV then split it every 1 Million rows into different worksheets but still in one XLSX file. So with 4M rows the result is one file XLSX with 4 worksheets each got 1M rows. Because...

It has always been my understanding that macros can only be created in .xlsm file formats. Yet if I open a .xlsx file, create a button, put code behind the button, and click SAVE...I get a warning about how it will be saved as a macro-free file...yet the code remains and if I click on the...

Need to search and replace text in multiple xlsx files located in a folder. Can someone guide me on this one.

We had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Office 2007, restored all data files and now when we open Excel files we cannot format them proerly. The page breaks will not edit properly. All the...

I received a file that has several columns and some of the columns contains data that can start with a zero. Problem is that when I open the Excel document, the zeros are dropped in those data cells. If the file came as a .CSV or .txt file, it wouldn't be a problem but that's not the case...

Hi, I'm trying to remove the macros from a specific worksheet. My idea was to just save it as an xlsx file then move that sheet to where I wanted it. The method works in that it removes the Module1 code, but it doesn't remove the code that I have attached to the actual worksheet, (i.e. when in...

So, i was copying some files after work from one partition to another. I then accidently deleted both partitions due to being really tired. I managed to get my files back using recovery software. However one of the files recovered was an Excel file. Ms Excel says its corrupted snd that i can't...

I'm receiving #N/A for most (about 95%) of attempted VLOOKUP entries. Does it matter that my reference array is in a xlsx and where i'm wanting it to land is in a csv? Also, might be helpful to know that the value on the csv that i'm looking up is a result of a function that reads 2E+11. If i...

Hi All, I'm keen to add a field to a spreadsheet that populates a cell with the username of the last person who edited the file, as in the system or logon name, e.g. first.lastname syntax. I would however like to keep this sheet as an .xlsx and not have it as an .xlsm. I have the code to use...

I have got a csv file. it contain an output of a state. I have got another .xlsx file which contain the needed column entries. I wanted to copy the contents from the csv file to the excel file with its corresponding matching column entries. Alternately the source can be changed to txt as well...

Hi there, Hope you can help me out with the following, it should hopefully be simple and I'm just missing something! OS: Windows XP Excel version: 2007 I have an excel worksheet with the following column: |Date| |01/01/2012 00:01| However, for my work, I only need to extract the date, not...

I have a requirement to prompt a user to select 2 files from a defined default LAN directory. File1 is a excel 2010 .xlsx file File2 is a .csv file File1 contains multiple tabs named Tab1, Tab2, Tab3 ... Tab(N). File2 contains some header infomation followed by multiple rows of data and some...

I have a workbook with an ActiveX button that makes a copy of the activesheet and emails it. I figured out how to remove the button from the copied sheet and how to save it as xlsx instead of xlsm. However, how do I stop Excel from warning me that I am saving it in this format and my VB...

I have a spreadsheet that I've been using for years to track my finances which was saved as .xls. I recently updated it to .xlsx and I'm suddenly having circular reference issues on every tab. The most perplexing one is if I type =TODAY() into any cell, it shows up under Circular References...

Hello- I have a client who is developing an ROI calculator in Excel 2007. They would like to consider converting the workbook to a web app eventually. Questions... 1. Is there a way to do this within Excel 2007 natively? 2. Are there any "best-of-breed" tools that can be purchased for this...