file extension

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

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

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

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

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

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

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

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

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

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

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

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.