1. B

    Code converting xlsm to xls

    As you can probably tell by looking at the code below, I simply run the code when I have a xlsm file open and it saves it as a xls. A problem Im having is if i accidentally run the code on a xls I will get error at the Kill Filename. Is there something that could be added at the beginning where...
  2. B

    Experience of XLS Padlock

    Hi Is There anyone with experience of the software XLS Padlock (copy protect ). I am looking for a good way to copy protect my worksheet. Or is there any other software to use. Best regards Bengt
  3. B

    XLS Padlock user?

    Hi Is there anybody out there who have tried XLS Padlock software to copy protect a Excel workbook.
  4. B

    Save As Non Macro Enabled Worksheet-VBA

    I was trying to create a macro that when I open a workbook that is macro-enabled I could simply run some code that will change it to an xls or xlsx and save it as the current file name. I need it to save it to its current location. Thanks as always
  5. E

    Is it possible to specify the path and filename of an xls file and use it as a reference without opening it?

    Is it possible to specify the path and filename of an xls file and use it as a reference without opening it? In VBA or formulas. Thanks!
  6. S

    convert xls to xlxs files.

    I found a macro online that works to convert .xls files to .xlsx files. But it works for one file at a time. I would like to modify this code so it loops through all the files found in a folder. Folder path is static (does not change). Currently I have these files in...
  7. A

    loan calculations

    How do i post an xls file? thanks
  8. D

    Run-time error '1004': Method 'Activate' of object '_Workbook' failed only on new PC

    Hi Folks, I have an old excel model last modified in 2010 that was written by a pretty decent VBA / SQL programmer who has since deceased. All our old machines are running Windows 7 professional on a 64 bit OS using 32 bit Excel 2013 (8 gb RAM). A new PC installed recently runs...
  9. S

    Add Validation list in VBA Excel 97/2003 (.xls)

    Hi guys! I'm currently working on a macro where I need to populate a validation list for a cell. The list comes from a string that's joins elements from an array. Here's the code: If Not IsArrayEmpty(Clas) Then For i = PrimeraClase To UltCla Clase = CStr(Ana.Cells(i...
  10. S

    .xls refresh all keeps enabling itself?

    I have a report (.xlsx) with some data connections to a SQL query that sometimes crashes on certain people's PCs. They seem to get better reliability from .xls files, however some of the queries are quite expensive and take a while to run, and I'd prefer to disable the background refresh and...
  11. M

    Excel Speed

    Would you please explain what is the Excel calculating 8 processor(8)? My spreadsheet is talking a long time to open up and inserting rows and column. Does it make any difference whether I save the workbook in xls or xls files. is there any solution to make my workbooks faster to open up? Thank...
  12. F

    Exporting data to a new xls workbook

    Hi, I am trying to export data from an xlsm to a new xls. But the problem is that it only copies the first row and I need a table to be copied. My macro is this one: Sub ExportarTXT() Worksheets("Import").Activate If Sheets("Import").Activate Then Range("A1").Select If...
  13. F

    Macro works perfect on xls.files but not on xlsx.files

    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 =...
  14. B

    Downloaded spreadsheet not opening correctly?

    I've made a workbook in Excel (obviously) on my Mac, saved as a xls document and emailed it as an attachment. When it is opened on a windows pc (Excel 2007) it isn't displaying or functioning correctly even with macros enabled. For example I have in cell drop-down menus which aren't...
  15. J

    wheere can upload Xls Files?

    Hi friends where can upload excel files for ask a question? Thanks
  16. F

    Power Query data from "XML (MS Excel)" file type

    I'm using SAP BEx Broadcaster to routinely send SAP reports via email (and concurrently adding to team-space). The output format is listed as "XML (MS Excel)" format. It is sent via email attachment with "xls" extension and older style excel icon. When opened directly from excel (ie 2016) an...
  17. A

    Macro changing all files extensions in the folder to .xlsx

    Hello! I have an issue with Power Query add-in. As you know, Power Query doesn't allow to work with files with extension .xls. The issue is that I have many files in my folder (over 50), the majority of which have extension .xls. I need to get and transform the data from folder with Power...
  18. 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...
  19. P

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

Watch MrExcel Video

This Week's Hot Topics

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