.xls

Hi Everyone, I just joined and it's my first post. Just got a new computer with Ecxel 2016, was using Excel 2010 on old computer. With 2010, when I take a .xls file and save as a binary spreadsheet, it highlights the name minus the .xls file extension. The new file becomes a .xlsb, easy...

I have a folder with multiple .xlsm files which I need to programmatically save as .xls file. Anybody have a vba script to do this?

Hi all, Ive got the coding more or less down. However, im trying to figure out if excel could import the 1st 5 excel file's data to one Sheet 1 then the next 5 to Sheet 2, etc... Currently, its importing everything into one sheet. Any help is greatly appreciated. Thanks! Sub ImportFiles()...

Hi all, in need of some help to import new data into new column. Currently, Ive only managed to import the data but with every new data, they are stacked below. I need them to be in a new column. Eg. data1 A2:B2, data2 D2:E2, etc... Also, is it possible to import the filename of the import data...

Hi guys, I having trouble importing only the column a and b. I am importing excel file data (500 of them) into a single sheet and would only like to extract values from 2 columns. I am new to vba and got dumped by this job because our IT guy is in the hospital. My job is on the line :( need...

Hi all, Ive came up with the VBA to import multiple excel data (.xls) into a single worksheet. However, the format is still not what I want. Could someone please help? I am still working on my VBA skills. 1. Currently, the VBA imports all the columns. I would only need column A and B. The data...

Hello Everyone, I need some help with a macro that I am working on. I use the Macro within one workbook to open up to 33 other workbooks, copy information and paste it into the initial workbook. The problem has come up that within the 33 workbooks, some are saved as .xls and others are saved as...

A colleague of mine has an Excel file where the font sizes and background cell colours of individual cells sometimes appear to have changed spontaneously when she re-opens the document. She had formatted the columns to different colours to indicate what they were being used for (various types...

Hi, all. I just got upgraded to MSOffice 2007 and mostly it's fine, with the usual bugs that come with such moves. However, one of my duties is to upload an .xls file to a website for display. The last time I did this with 2003 it worked just fine, but the first time I did it w/ 2007 it did...