import

Hi all, Looking to get some expert help as i'm a novice with VBA. I've currently tried searching online and i can't seem to find a macro that can help with what i am trying to do. Essentially i have large data files with more then 1.6 million lines of data. I currently have a macro which...

I want to import ,say, D column from .xls (not csv) file, data is range, not table. How to do that ? I found how to import named column, but not basic

Hello. I need help designing a macro. I have no clue how to do it, never done a macro yet. I want to import into an excel file, the games and the scores from a web site (ie. FlashScore.com: Live Football Scores, Livescore ). I want to assign this macro to a button, so I can refrash the data...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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