file extension

  1. Johnny Thunder

    Update to Existing Code to Search for File Extension .xls or .xlsm

    Hi guys, working on updating a workbook that contains some code that was inserted into a UserForm. I am having an issue because the code looks in a specific folder with both .xls and .xlsm file and the usual "*.xls*" wildcard doesn't seem to be working? I have tried both "*xl*" and "*xls*"...
  2. D

    VBA workbook! Disguise .XLSM macro file extension

    Hi Guys, This is a very silly question, but I thought I would ask as I'm desperate. I have created an .XLSM file which I need to upload to an Intranet site. Unfortunately it seems this site only has the ability to take files in the following format: xls, .xlsx, .xlt, .xltx, .xsd
  3. D

    Prevent Change in File Extension?

    Hello, Is there an effective way to prevent a user from changing the file extension of a file? For example, if a file needs to remain .xls I want to prevent a user from changing it to .xlsx, etc. I assume I would need to add code to the Workbook_BeforeSave event? Or is there a better way...
  4. MrManBoy

    VBA to copy & rename closed workbook with variable file extenstion

    Hi Trying to achieve: The code below checks the if there is a copy of that file with a predetermined extension and if not, then create the copy with the original extension. However, it has come to my attention, that despite the file names are always the same, the extensions are not. Is there a...
  5. G

    Macro to find missing extensions

    Hi, I'm a newbie...just to state that up front, please don't throw rocks! ;) I'm a creative designer by trade, but have been getting into more 'expanded' requirements by clients. Anyways, here's my question, I have an ongoing monthly gig that I'm supplied with a spreadsheet that includes...
  6. F

    VBA- Selecting file to copy a range into existing sheet

    Hi all, I'm trying to accomplish something that I can't seem to figure out in VBA. It's a little hard for me to explain, but I will try my best. What I want to do is prompt the user with a Windows Explorer window to browse for a file. The file that the user navigates to will be a .csv file...
  7. G

    Save a Workbook generated by a template as .xlsx, then keep going.

    Hi.... I have a requirement to be able to use a Template to allow the User to complete a Workbook, then save the Workbook in two different places all under VBA control. The User enters info into the spreadsheet, and "behind the scenes" (i.e. in Macro code) the single Worksheet has sensitive...
  8. S

    Excel 2010 does not recognize files created in earlier versions...

    Our company has recently transitioned to Excel 2010. I have a worksheet that links to and pull data from multiple worksheets on a network drive. This worksheet needed to be transfered to 2010 and reformatted in order to work properly. My concern is that all the files it links to are still in...
  9. P

    Macro - Date and data analysis....

    Hi, I am analysing a bunch of file data and due to the large volume of data the sorts and filters take ages to run. Column B contains the size of the files in bytes. Columns D, E and F contains their last access, date created and last modified dates. Column H contains the file extension. I...
  10. C

    File extensions hidden vs. visible

    I am wondering if anyone can shed some light on how having file extensions hidden vs. visible in a folder effects macros run on files in that folder. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> For example, with the target file already open, I get a...
  11. K

    Change default file format/ extension in save as dialog box

    We're about to move to Office 10 from Office 2003. We have certain files which will always need to be saved as .xls as they are used to upload into our financial system. Can anyone help with code to change the default file format in the save as dialog box so that the user doesn't have to...
  12. S

    inserting dxf in power point

    Hello , anyone knows how to insert picture with extension .dxf in power point. i'm using power 2007. i'm able to insert this picture in lower version. please help. thanks.

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