import

  1. B

    Import SharePoint Excel Files

    Does anyone know of a way to import excel files directly from a SharePoint into access
  2. B

    Auto Run "Import Database" upon open file

    I need some help here as still learning Excel Macros I have few sets of code within an excel file. 1) clear "results" data if "input" criteria has any change 2) Export "results" as a separated file in values only - button 3) Import "Database"- button So far, I tested them separately, all are...
  3. S

    Data Importing Wizard - Terrible Data Set - delimiter issue

    Hello, I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited...
  4. S

    Data Importing Wizard - Terrible Data Set - delimiter issue

    Hello, I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited...
  5. R

    Array compare?

    I have a project (proprietary, can't go into details, sorry) where I read in data from a server and convert it to a user friendly graphical form. It get's repeated over time and sometimes the source data will slightly change from what was previoulsy imported. My users have asked for me to do a...
  6. K

    Importing data from multiple workbooks to one sheet in master workbook

    Good day all. I'm busy to automate some of our time sheets and overtime reporting. Each employee completes his/her own timesheet in a Excel Spreadsheet. Some of this information is then merged into a monthly summary. At the end of the month the employee is using a button, with a Macro, to print...
  7. O

    Help with csv data import

    Hello, I am wondering if anyone can help. I am looking to do a data import from an excel csv. I want to use this for a table seating plan. On the plan, there will be upto 50 tables. Each table will have a title (table 1, table 2, table 3 etc). Under each table there will be upto 15 guests...
  8. T

    Pasting selection into sheet in another workbook fails if excel is opened in another instance

    I have a spreadsheet that imports data from a different workbook to import and update items in the destination book by pasting data from the second workbook... It all works absolutely fine - although in some cases when the second workbook (with the data to import) is opened, it opens in a new...
  9. A

    Access from XML/XSD

    Hello, does anyone know if there is an easy way to import XML data and relationships into access? I am interested in working on a publicly available dataset (here: https://www.hesa.ac.uk/support/tools-and-downloads/unistats) but have only been able to import the xml tables - not the...
  10. P

    Import Sheet error

    I am trying to import a sheet from one excel file into a new file. I created the below to accomplish this saving it into "PERSONAL.XLSB" When I execute the code, I keep getting: Run-Time error '1004': Copy method of Worksheet class failed I am able to open the sourceworkbook as expected, but...
  11. R

    Append Date to Imported CSV

    I have a pretty simple database that I use for basic reporting. Every day I download a csv report from a website that contains sales metrics from the previous day. There are 4 columns of data (A-D in Excel). The Access table I import into has 6 fields (the first being an auto number record...
  12. D

    XML Import Confussion

    Hey all, First time poster here, but i've lurked on the site for a while. I'm looking to import an XML in to Excel but i'm having issues with it. I've used the Import wizard and feel like i'm most of the way, but i'm missing something probably simple. The XML is a few hundred records and has...
  13. I

    Web Import issue with text in the data table

    Hi I am trying to import data from the web. Some of the fields in the table originate from user input free format text which includes line breaks. The importer is interpreting this as additional rows and creating these in excel. Is there any way I can prevent this? I haven't been able to...
  14. S

    Import word doc into excel and keep formatting

    Im trying to import a word doc into and excel sheet, which i can with the use of vba, here is my codeSub cmdbtnImportwordDoc_Click() Dim docAppl As Word.Application, docMyDoc As Word.document Dim SourceFile As String Dim Dest As Range Dim wbkSource As Workbook Dim SourceRange As...
  15. spencer_time

    Delete rows beginning with ! and insert row with text into multiple sheets

    Hello, I am trying to make a complex spreadsheet that will import .s2p files (just text files with a different extension) containing some data, each to a different sheet, delete the beginning comment rows, add a row that has headings describing the data. All of that for the raw data files...
  16. lockarde

    Exporting Userform design and code to import in VB

    Hello all, I've recently created a userform within excel to take care of some quick calculations I regularly have to do. After getting it all set, I thought, why not make it a stand alone app, instead of having to run excel everytime? I tried exporting the userform, and I get two files, one...
  17. W

    Import CSV file into table.

    Hi guys, Hopefully you can help me out, i want to import an CSV file into an table. Normally i setup a connection and i use that connection to import the csv file. But more people are using this excel file and a person is using office 365 and the connection is not working in the new excel...
  18. John.McLaughlin

    Change to UPPERCASE - My VBA Macro Imports lowercase data Sheet 1 to lowercase Sheet 2?

    Hello! I use a basic order form clients fill out and send me. Then I have a VBA macro that reads every cell of the submitted form, and pastes the value into the corresponding "In House" form. Trouble lately, a few people are sending everything in lower case. Can I modify my copy or paste...
  19. D

    Import File into Table with Import filename and date

    Hello, Can this be possible to add the filename and date when importing excel file. I have a table of import file and i need to add the filename and date to the table for the records purposes. Is also possible to select the file. Any help is much appreciated. Thanks
  20. G

    VBA to Import CVS Files

    Good Morning, I've got the code below -- I was hoping just adding CVS to the filter would allow me to import it but it doesn't so I need to help. How can I get this code to import CVS files? Sub ActiveRateCategory() Sheets("ActvRateCat SumRpt").Range("A:M").Clear Dim wkbCrntWorkBook As...

Some videos you may like

This Week's Hot Topics

Top