importing

Hi all, hoping someone can help me, I have seen variations of this code everywhere but nothing that works for what I require it, there's always one thing which make's the other code not relevant to my workbook. Essentially, I will have a main workbook which my VBA macros will be written in, I...

how do I keep the text format columns for columns A and X when importing a csv or text file to excel? when I used to use Excel 2010 I could pick the format for each column but I don't see that option when clicking data>from text/csv file and then it creates a query

Hi, I have used iqy files for excel on mac. It loaded the table results and i was able to format it but it left the hyperlink as needed. I decided to try power query and used my windows version of excel and I am able to make the connection and pull the data. Much easier to deal with. But the...

Good afternoon, I have run into an issue I am in need of assistance with. I am importing data from 5 Excel spreadsheets into a sixth, however when it queries the first of the five files, it’s returning the data plus an infinite number of blank rows, up to the max and is not...

Hello all, Recently I have noticed that my dBase has not been importing all data from the excel sheets into the dBase tables. After examining the dBase, the tables and the raw data sheets, I see no reason why it shouldn't be importing. I was hoping someone here might have an idea why, though...

Hello All, I need to import an excel 'Range' which contains texts and images into Word document. I have used the below code. Problem is images are misplaced after importing into word document and few images are above the text content. how do i maintain the structured format even after...

Good morning - I have 115 text, tab delimited, files I want to import into a single sheet of Excel. I found this upon searching: https://www.mrexcel.com/forum/excel-questions/8822-importing-multiple-text-files-once.html, but I want to also import the text files last modified date into a...

I have a saved import that I want to run using VBA instead of the ribbon (because I have other actions I want to happen while with the import (First I am deleting the records in the table where I am importing) My import name is Import_ModelGeneralvluItem I cant find it on the internet. Any...

I am trying to record a macro wherein I am importing stock market data of Nifty fifty stocks from NSE website: https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm However, the destination cell only displays the following message "no data". Could you please tell...

I have an extremely large table (4.8MM records) that is the result of users importing excels with the same format into this table. From what I can tell, there are a significant number of duplicates within this population (likely from users importing the same excel twice). The tricky part is that...

Set wb = Workbooks.Add ThisWorkbook.Activate ActiveSheet.Copy Before:=wb.Sheets(1) wb.Activate Workbooks("Copy of TEST2 - Copy.xlsm").Close Dim path As String Dim fileName As String path = "C:\Users\andy_\OneDrive\Desktop\VAMLog\" fileName = "SAVEPDF.frm"...

Hello, I'm trying to setup a macro that will allow me to upload a spreadsheet "ABC.xlsx" each time I run it; however, I keep getting a conversion error. The reason appears to be some data is not yet populated (blanks). Is there a way to import the data so everything is short text so everything...

Hi, I'm doing my first baby steps in power query. I tried to create query from excel workbook through the 'Get and and transform' and it took ages, but when I tried to do the same through the "Data model' UI it took just seconds... Why is that? What is the difference between the two methods...

hello I have some external data that I import daily into a spreadsheet using VBA. The data I am given is not consistent - there are often spaces in the string in data in column 'I', and I would like to clean it up before importing. The spacing is also never consistent so I would like to make...

How do I go around doing this? everytime when i import a new excel sheet using an vba command I would like it to extract the files name, sheet name and todays date when importing? and have it above the data while it is importing ... I am unable to do it since the data is dynamic and i dont...

Is there any way to import macros from a .bas file other than 1 at a time? I have many to do.

Hi! I am studying for the bar exam and have 20 old exams with model answers in a word document that i would like to transfer into excel with each question in a cell in one column and the answer in the adjacent column so that I might mail merge them to print out flashcards. I have tried various...

Hey, I'm hoping someone can help. I've recently landed a very laborious task which involves importing multiple CVs into an excel document for manipulation. I found this code which works great! Imports all my selected CSV files Into Excel, into separate tabs, however, as its VB it seems to...

Hello, I using a VBA and VBScript to pull data from SAP and saving as a txt/csv file, then importing the data into Excel. My problem is that i would like to import the data into a data table, but Excel doesn't like to import data into an existing table. I've played around with connections...

Hi, I am importing worksheet from an excel file in access. When I try to import excel file. I can see below message. Both the excel file and access files are saved on the same path but in a different folder. Excel file does not have any formulas or hyperlinks. Pop-up is as below A potential...