xfile

Hi I want to improve the code below. I am thinking if it is possible to display file browser for the user to choose file from. Like when you click open in Excel, a file browser will be opened to help users to select a file. Can I do that here? Thank you very much Sub wbs_open() Dim xfile...

Hi When I run the code below, I get this message But that defeat the purpose. I mean, if I entered file name as Hello.xlsm, sill I get that message. How can I improve that code? By the way, if I save the file as "*.xlsm" before running that code and then when I run the code below, I wont...

Hi everyone I have the following code that I pinched from another website that opens all text files in a folder but I need multiple tabs to be treated as one delimiter... I know you are the guys to help!! :) Sub Test() 'UpdatebyExtendoffice6/7/2016 Dim xWb As Workbook Dim xToBook As...

Hi I wrote the code below. It did not give an error message but it did not move a sheet from from one workbook to another. The main workbook is called Book1 and the file I want to open is 1.xlsx. I passed the path and file name correctly. The second file will open but the copy would happen...

I'm trying to put together a photo album macro for Word...select a folder and have each of the image files inserted into table (2x1) with the image in the first row and the file name in the second row. I basically have the general process for the first loop, but after that, instead of...

I'm using this to import data from multiple files in a folder; <code class="vb keyword">Sub</code> <code class="vb plain">ImportCSVsWithReference()</code> <code class="vb comments">'UpdatebyKutoolsforExcel20151214</code> <code class="vb spaces"> </code><code class="vb keyword">Dim</code>...

Hi, Im using below code to combine txt files to one excel sheet data file. I need to edit my code to "take" files only from the last 7 days. Any idea how to do that? Thanks!! Code: Sub list() Dim xSht As Worksheet Dim xWb As Workbook Dim xStrPath As String Dim xFileDialog...

Hey, I'm hoping someone can help. I've recently landed a very laborious task which involves importing multiple CVs into an excel document for manipulation. I found this code which works great! Imports all my selected CSV files Into Excel, into separate tabs, however, as its VB it seems to...

Hello all, I'm trying to adapt the below file rename code in order to be able to operate recursively (i.e. perform the operation on all files also found within subfolders of the chosen folder), preferably using File System Object, but I'm having trouble figuring out how to do so. Sub...

Hi, I found this macro in one of the forum online. This macro is sending the excel into the email as an attachment, but what I need is to send the content of the sheet as part of the body of the email and not as attachment. Can someone assist me? Sub Rectangle1_Click() 'Update 20131209 Dim...

Here is the code that I've gathered together for this. As the subject mentions, the code is placing an extra file extension on the names of Outlook attachments. The files still open, but it looks silly and I'd like to correct it. Can anyone tell me which lines need to be changed/added to...

Good morning, I have the below script that works perfectly well on a windows machine. However it doesnt run on a Mac Operating system. Can I get your guidance on what I need to do to the code?

Hi all, i'm using the macro below to send try send a worksheet via outlook. The button created in my worksheet is called reconcile. The problem is when .display is used the macro runs fine, but when i change this to .send and click the reconcile button nothing happens. I've seen this has...

Hi all, I am importing .rpt files into excel using a vba code that I've attached at the bottom. Currently, I select a folder to import, and it imports all the files within that folder. I need to be able to check if I have imported a file before, and not import it again. The file names are a...