strfile

I would have thought that this should be fairly straight forward but I'm running into issues on opening additional workbooks from a userform. So yes, I have a userform with a button that when clicked opens up a number of additional workbooks. Is this a problem with the string sent to...

Hi Everyone, I am creating an import code for Access from Excel that takes every excel file in a folder, imports the designated Sheet (i.e only Sheet1) and within a designated area of space in the sheet(i.e Sheet1!A32:T1881) and import it to an access called Table called "Test1". This I have...

Hello to anyone. I'm trying to find a solution (a vba) that open all excel files inside a folder, then search IN ALL WORKSHEETS of each excel file for "40;" and replace it with "48;" , then save and close files. I found the following vba in microsoft support website, but it doesn't work for me...

Task: Looping a macro through multiple workbooks and extracting a table from one tab then transposing that list to a master to make one long data set of all the workbooks. The end task is to easily create a pivot table using this information. I need the data set I am copying from to be dynamic...

Hi, I need to download lots of attachments from various folders in outlook and trying to use the code below. The issue is that on some folders it works just fine but for others i get a runtime error 13 on the line in red. Any ideas on why that's happening? Also, is it possible to ammend the...

Hey, I have 55 CSV files that I want to export in to Access, I am currently using a macro but it only takes the first file from the directory, I need a loop to take all of the files from the same directory but I am not sure how to implement it, any help would be appreciated. I am using the...

Good Saturday to everyone! I have been trying to tweak this script for days, but I am no expert. This script automatically kicks in every time the main Excel file is closed. It should: 1 - Export a sheet called "Master" from the closing Excel file by creating a new one called Master(Progressive...

Hello, I am using a macro to rename all my file in a folder with a specific cell value, the macro also rename the sheetname with the same cell value. It works fine for what I need, the only drawback is that the macro is sometime terribly slow. 1) Could someone give me some tweak to speed-up a...

Hi Guys,, Need your help.. How to make this formula works with .csv file/s. Thank you :) Dim fso As Object Dim fld As Object Dim strSearch As String Dim strPath As String Dim strFile As String Dim wOut As Worksheet Dim wbk As Workbook Dim wks As Worksheet Dim...

Hi All: When the criteria is met, I want vba to copy entirerow from external workbook/s to this workbook starting from a selected cell. Example at cell (C2) instead of (A2) as per current formula. :) Dim fso As Object Dim fld As Object Dim strSearch As String Dim strPath As...

My current code simply adds a 1 to the module's names, just wondering if there's a replace command I could use or some other method, Thanks Sub Import_basFiles() Dim StrFile As String StrFile = Dir("C:\users\steve\desktop\basfiles\") Do While Len(StrFile) > 0...

Hello, I have a mastersheet that needs to pull data from about 10 spreadsheets and insert the rows underneath each other. However, it is not working out as I think it should. It is running the code, but it is pasting the results on top of each other and starting from column S instead of column...

Here is a code I found online to save attachments from email mailbox. If I receive emails with the attachments named the same it will not save all copies. Is there away to make sure it captures all emails? Public Sub SaveAttachments() Dim objOL As Outlook.Application Dim objMsg As...

HI, I would like to save a copy with today's date to a specific folder,. Just a copy, I do not want it to open or prompt, The below code ,is not working anymore, what is wrong with it: just a copy so I will not loose my everyday work. Sub Save() Dim dtDate As Date dtDate = Date Dim...

Hello, I know that similar questions were answered in the past but none of them are exactly what I'm looking for. I'm trying to merge multiple CSV files into one master sheet and then archive the used files. Of course, I found this very useful thread where my question was answered. All...

Hello, I know that similar questions were answered in the past but none of them are exactly what I'm looking for. I'm trying to merge multiple CSV files into one master sheet and then archive the used files. Of course, I found this very useful thread where my question was answered. All...

Good Morning Mr. Excel, I've written a working xml parser macro that processes an emailed adobe survey. It uses early binding of the MSXML library and seems to work as intended. I guess I'm requesting feedback on if there is a more efficient way to code and I'd like to make sure its...

Good Morning, Thanks to the help of this board and google, I have been able to write the below macro in excel: Sub GetFormData() Dim XDoc As MSXML2.DOMDocument Dim xEmpDetails As MSXML2.IXMLDOMNode Dim xEmployee As MSXML2.IXMLDOMNode Dim xChild As...

Good Afternoon, I'm using the following code to scan a folder of all *.XFDF files and inport the results in excel. The macro works on a single file, but will not work in a loop. I'm open to suggestions. Thanks. Sub GetFormData() Dim XDoc As MSXML2.DOMDocument Dim xEmpDetails As...

Hello, I have a large amount of word documents (1000+) that have data stored in textboxes. I need to extract this data to individual cells in excel. Ideally, each word document would be recorded with a hyperlink to its path and a line for each data entry. I have found the following code written...