external data

Hi, i have a lot of lines a code, there are ranges of some cells. Each one save a position of others books by reference. Sheets("test").Range("b3").Value = "='\\server1\DATA\dataset\cabinetes\L31\time\" & year1 & "\" & cmbMes.Value & "\LAST" & "\[L" & "31" & "_" & txtDia.Value &...

Hello I have been trying to retrieve data from a data feed server but code is taking almost 10 minutes to get the data. When macro is executed through a button, excel freezes for 10 mins. I want to speed up the process within 2 minutes. It generates almost 8000 records but takes 10 mins approx...

So, somehow I was able to get the list to show up like I wanted. then I wanted to do better, deleted the code aaaaaaaaaand it won't work. Now I can't even get the RowSource to work with the Name Manger dynamic range I set up. At one point I could get a click event to run but not return anything...

Hello, i'm getting sql syntax error trying to return data from external data base. any assistance in figuring out what im doing wrong would be greatly appreciated! With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _ "ODBC;DSN=WEDRPGNR1;UID=CDL;PWD=sAB2021"...

All, What's the best way to bring data from one access file (user-oriented) to another one (main database center)? I tried using Append Query, but it adds all rows and not only the ones that are new. Moreover, it seems to be a manual process rather than an automated one. Thanks!

Hi there, I am looking for a wizard to help me out on this one. I've created a rather advanced Excel workbook that tracks stocks (analyses, gives alerts, atc). The only thing missing is real time stock prices. I have tried many many things to get real time stockprices in my spreadsheet (power...

Hello, I'm trying to get external data from a number of different excel files across different Locations, WITHOUT needing to open the files. I want to aggregate all data from one year (on different Closed workbooks) into a single sheet (per store) on the Open Workbook . The Closed woorkbooks...

I currently have a link on a spreadsheet that will open the source file for when data may need refreshing. How do I get the data to refresh by clicking this link without the source file opening up?

Hi, I have a Workbook that serves as an aggregation of data from several other external workbooks (same file directory). The workbooks being referenced are all uniform, so the specific sheet and cell reference is always the same in a column with the only thing changing being the workbook name...

I am trying to pull Historical data for derivatives into excel and keep running into a wall. https://www.nseindia.com/products/content/derivatives/equities/historical_fo.htm This is the link from where I wish to download the data into excel. I can pull the CSV file individually from the...

Normally I search a long time before posting but I have to get to a meeting and if I cannot get this answered now (4pm EST on a Friday afternoon), I cannot finish work planned for this weekend. I would DEEPLY appreciate any help! The research I've found looks like there is no solution from...

I been reading up codes available on the net from various sources and have debug with self-taught programming to make it work but I'm having difficulty proceeding on. As you can see, it comes from a source. Browsing a folder & reading the files works fine with the code, I need to copy values...

Dear all, Recently I have come across a problem regarding the use of pulling external data from XML files to Excel 2010. I work for a very small hotel. The hotel database we are using is very poor by any standard, so we cannot but make up its deficiencies by pulling some of its data to Excel...

I have a mirrored table so I can show selected data from a larger table. Problem is, one of the columns contains serial numbers which are a combination of number only and number and text values (i.e. 1208667 and 1029FB6). When I refresh my mirrored table, only the number values appear, not the...

The end goal is to have an Excel Table with a refreshable data connection to a web table. The reason to have an Excel Table is to use that Table as a reference point on other sheets, to perform calculations on other sheets, and to create summaries on other sheets. All of this is made much...

Hello. I'm hoping someone will be able to help me with this one, I'm looking to search an external workbook for any occurrences between 2 dates. The dates are obtained by looking up the dates from a business calendar which is in a separate sheet. That is retrieved by the HLOOKP function I've...

Hi everyone, I did a few searches on this but didn't find anything, so hopefully you can give me a hand. I have an Excel file that is pulling data in from Access queries and when I open the file, I don't see any issues. The links seem to work and if I change the data going into the query, I...

Hello, is there a simple way (or not) to get data results from a table within a PDF that has more than one table in it?

Hey guys! Thank you for the immense help you have already given by being so active. I have an excel file with some VBA code (fairly new to the (for me) more advanced stuff). The code is working fine, and was working when I was creating it. Now when I make a change in the file, save, close...

Hi, I have data spread across several worksheets. When I change the data in the Master spreadsheet I would like it to update data in the other worksheets. For example, when I update a sale in the Master spreadsheet from Pending to Sold, I would like to also update in the relative sheets. When...