xls

Morning all. I ideally need to take a specific sheet from a specific document and copy it's entire contents, formatting, filters etc into a new xls such that when i open the new xls it will get all the data once more from the original sheet. I know that you could simply set the new xls to copy...

Hi All, I'm importing a xls file into an xlsm file. This xls file is created each day onto a workers desk top. My question is, is there a sub that I can provide to first check if the xls file has todays date in the 'Date modified' string before my other sub begins the import? Does anyone...

In spreadsheet 1 I have a list of codes ('00001, '00045, 'J1364 etc - not all are numeric). They are displaying fine as Text in xls 1. I need to essentially copy them to xls 2. I run the following code: oWB1.Sheets(1).Range(Cells(r1, cPaste).Address, Cells(r1 + rHeight...

Hi, I am new to the forum and heard a lot about it. I am sure, I will get answer to my query, which I am struggling to solve. Here it goes I have 1000's of xls files where I am trying to fetch the information of 3 columns and corresponding rows into a new xls file. How to do it without...

Good day. I have some excel project and is circulated in a group of people. Some sheets contain complicated formula so I protected the sheet and allow them to just view for their reference. My concern is that some have removed the protection ..... Please advise on how to fully protect sheets...

Greeting to you all once again i need help on this, i have a password macro enabled excel file but i want a macro that will save a copy of the file as value, xls (not macro file), using the file name and adding the current year to its name, please help me out on this also. Thank you all.

Hi, My question is more theoretical. We have a file that requires the use of complex formula for a large set of data. The XLS version of the file is much faster than the XLSX or XLSM version. I understand why the XLS file is faster and explain it to one of the managers. Whoever the manager...

Hello, In addition there is a .csv file. I have more than 500 like this file. I tryed some way but they deform file's forms. Columns and rows intermigle each other. If you know an other way please can you help me? https://www.dropbox.com/s/ofi4bskjrfj5afb/01.02.2016.csv?dl=0

good evening, I currently use the following vb:- Sub savetab() ' ' savetab Macro ' ActiveWorkbook.SaveAs Filename:="C:\times" & Application.PathSeparator & ActiveWorkbook.Sheets(1).Name ' However i can only send this to my recipients as an xls...but before send the final draft, i need to use...

Hi i need vba code which can save as xls file with same name + date and time but from different location without opening file. For example: there is 1 file c:\abc\xyz.xls i want to save as this xyz.xls file with date and time(like xyz_15_01_2018_15:45 PM) from different location (from different...

Hello everyone, I have an excel file like table below. I want him to extract me only the unique items from "Source" column and then to count them in "Ocurences" column. I did it with with DATA--->Advanced--->copy unique entries etc. and then countif... but this xls has 8000+ rows, so it...

To all I want to create a simple GUI with a listbox and ‘process’ button (done!). In that listbox I want to add the name of all the xls files currently open (in my excel session) On the processbutton.click I then want to take get the name selected and pass it to a function 1. How do I do...

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

Sub Deleteexcel() 'You can use this to delete all xls files in the folder Test On Error Resume Next Kill Application.ActiveWorkbook.Path"*.xls" On Error GoTo 0 End Sub I have code above that is trying to delete every file with xls extension. I have wrong syntax, but no idea...

Hello everyone! Please help to solve my problem. I need to open .xls file which was created in Excel 2010 two month ago. But now i get a message "Data cannot be repaired." So how to make excel file repair? Thanks in advance.

Hello, I am facing to a unknown problem for forums in my country. I hope here I will find an answer. I've created a vba macro for handling a .xls file. What I don't understand is why is it working with some xls files and why not with others. I get the error message in the title at this...

Hi all, I've been working on a excel workbook, where I want to import a workbook from a specific excel file, that is located in a sharepointfolder, into another excel file (named Import.xlsm). I'm able to import the workbook, if source-file is on my C-drive and .xls format. Private Sub...

Hi guys, Please I have this VBA code which combines multiple excel workbooks into one excel sheet as long as all the xls files are in one folder and no other file formats in it. Here is the code Option Explicit Public strPath As String Public Type BROWSEINFO hOwner As Long pidlRoot As...

Hi excel gurus, I have the following code which works perfectly: Sub export_lionbridge() Dim New_file_name New_file_name = Application.GetSaveAsFilename(, "Microsoft Excel Workbook (*.xls), *.xls") Sheets("Sheet1").Copy ActiveWorkbook.SaveAs FileName:=New_file_name, FileFormat:=xlNormal...

Hi, I am absolutely new to the world of coding and I need a simple code to do the below: Open up files using data import from csv, (however many there are) and save files as xls. All files are saved in a central location. Can anyone please help me with the code? I have to open up so many...