strfile

  1. R

    Opening a Workbook from a File Dialog Box

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

    VBA Import Code to Access Help

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

    Find And Replace in Multi excel files with multi worksheets

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

    Consolidating information to master sheet

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

    Macro to download outlook attachments not working

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

    Importing CSVs to Access with VBA

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

    Cannot make this script work!!!!!

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

    Tweak to speed-up macro

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

    Copy Paste Without Opening The .csv file/s

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

    Copying Entirerow to Defined Cell

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

    Can I overwrite an existing BAS files when importing modules?

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

    Populating Master Spreadsheet from Excel files in folder with VBA

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

    VBA - Save Selected Email Attachments to a folder - Keep Duplicate Items

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

    SAving A copy of worksheat

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

    Merge CSV files into one master sheet

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

    Merge CSV files into one master sheet

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

    Working XML parser, efficiency/compatibility

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

    VBA XML Parsing question

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

    Adobe XFDF to Excel VBA

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

    Extracting data in Word textboxes to Excel

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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top