xls

  1. D

    Automatically copy an entire sheet from one .xls to another

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

    vba import *.xls with todays date

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

    Range1 = Range2 not quite working... with numeric values as strings/text

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

    Extract 3 columns from multiple xls files into a new xls file

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

    Full protection of sheets

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

    save as (without password and as xls file not macro enabled)

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

    XLS vs (XLSXM or XLSX ) speed performance

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

    csv to xls

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

    choose xls or xlsm?

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

    Save as xls file with date and time end of same file name from different location

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

    Extracting unique values and counting them in large xls

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

    Get name of all xls file open and put in a listbox?

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

    VBA-Copy/Paste Issue Excel 2013

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

    how can I wirte code to delete only xls extension file from current workbook's location?

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

    Problem with xls file

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

    vba runtime error 91 object variable or with block variable not set

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

    Importing from sharepoint using VBA almost there (I think)

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

    Extracting xls files from a folder directory

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

    export to xls vba

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

    VBA Code to Import csv files and save as xls files

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top