importing

I am importing a text file where the date columns are coming through as whole numbers (yyyymmdd). When I try to transform to date, I get error. I tried to add a custom column with DAX formula Date(mid([Column1], 1,4), mid([Column1], 5, 2), mid([Column1], 7, 2)). Then I get error "The Name DATE...

Hello, I have a disturbing problem with the way Excel is importing data via pasting from IE. If the html table has a field has the entry: 826E2 Excel changes it to 8.26E+04. The format for the cell in Excel is General. But, even if I enter 826E2 into an worksheet cell formatted as General...

I have recently switched from Excel 2016 to Excel 2017 and when importing data from a .csv Excel formats the import as a table when I click on load. This means I then have to change the format to convert it to a range and then get rid of all the colour banded rows. Is there a way to prevent...

Hello, I am a newbie to excel and I have a sheet that is receiving data from a website everytime that i hit the refresh button but when I protect the sheet it does not let me refresh the data that i need from the website. The data that I am importing from the website I use it to make other...

Greetings... Simple? Apparently not... Setup: I receive each day a payroll extract in CSV format, I have written code to clean it up and once cleaned I would like to export it into an Access database. NOTE: I do not want to import from Excel into Access... I want to export from Excel into...

Hi Guys, I am using the transferSpreadsheet command in Access to import multiple tables (> 60 files) from a folder containing Excel files (each files has 1-3 imports to one table in Access). I can import files individually but I am trying to create a loop but I am not that familiar with the VB...

Hi All, I'm working with a great macro that allows the user to select a specific excel file in importing it into their already open excel workbook. Dim wsDest As Worksheet Set wsDest = ActiveWorkbook.Sheets(11) Application.ScreenUpdating = False On Error Resume Next With...

Hi, I am trying to import a few columns from one excel spreadsheet to another. Below is the code that I have found on a forum which is working fine. the only problem I am facing is it is importing only one column.can someone please guide how I can edit the code so that I can importing multiple...

Hi there, I currently have a excel workbook labelled "MasterRegister" with a worksheet in there called "Register". I have a vba code whereby it pulls data from a closed workbook called "RO Status Log - Practice Copy" and inserts it into the "Register" spreadsheet. Here is the code: Option...

Is it possible to import a spreadsheet with an if statement?. Example: I need to import a spreadsheet from a list if I select a certain category. If Cell A2 = any from the following list, Project, Open, Closed, All. I need it to import that list spreadsheet. I know i can nest if statements in...

Hi All, I am using Excel 2013 and am having trouble with an import macro. I have a macro that I am currently using to try and import a file into my excel workbook. The file that I am trying to pull in is a .csv file, but it opens in excel when I open it on it's own and it reads just fine...

Hey guys, I'm a newbie in excel vba I'm in a internship for my school and my time here is almost ending and I need to do this or I fail I'm dealing with something that I don't know nothing and don't have enough time to learn without further ado I will explain, my problem is to create and add to...

Hi all, I have a massive matrix of pricing data (a sample below) in excel that I would like to import into and use in Access. The horizontal headers are "tickers" and the vertical are dates. <tbody> Date ACL SJ Equity BAT SJ Equity CSB SJ Equity GRF SJ Equity 1/2/2014 3764 658 12315...

Hey guys. So I've been working on this the past two days and no one seems to have a good solution (that I found), but I'm sure there is one. I have an excel document that contains a bunch of data but the first column contains a date for event. I have code that pulls the data from that excel...

Good Day all, Recently one of our users created a number of Macros in which she placed on two customized tabs for Excel 2010. Later, as the administrator I was asked to add the customized tabs to 72 other users. I have very limited experience with either VBA or XML so I simply copied her...

Hopefully this is in the right forum. I have over 50 different sets of data in CSV format containing clients information. I want to create a MASTER FILE with all this data in one place. Problem I have is two fold :- Not all files are in the same order of Columns , eg one might be TITLE...

Hi folks, I've seen a few similar posts to this but not one that seems to fit my needs. I'm looking to import multiple text files into the same sheet, placing subsequent text files below the previous one. I'd also like to remove the headers in the text file (just the first row) as the files...

<tbody> I have been beating my head against the wall because I can't figure out what is going on. When I try to import data into a table I am getting "Field "F42" Doesn't Exist in Destination Table" error. I have a "client lists" table...

I'm building a consolidation workbook that imports two worksheets from several different workbooks. One sheet is called "Summary", one is called "E-video." Every workbook has a "Summary" sheet, but not every workbook has an "E-video". My problem is that when I use On Error Resume Next (in...

ppptrp03.p 1+ 3.6.13 Inventory Valuation Report Date: 17/09/13 Page: 1 Federal-Mogul Sealing Div Time: 19:56:21 Product Line: CHEM...