online

Due to a transition, I now have to use an online portal to connect my current excel files (located in local drives now) to my access database. Does anyone know how to import an HTML website which is an Excel file to access? Similar to Office 365 Excel FILES. The actual source I'm using is a...

I have recently upgraded my Excel from version 2010 to 2013. However, the VBA help file seems go online by pressing F1. How to turn it back to a local chm file? Thanks a lot!

hello, I want to transform the first table to the second: ¿can you help/guide me? <colgroup><col span="3"><col span="2"></colgroup><tbody> Segment Channel Product.ID jan feb Domestic 1 23 5 1 Domestic 1 54 1 5 Online 2 43 34 5 Segment Channel Product.ID Month...

Hello all, I'm trying to figure out how to do this properly, but I can't figure it out yet. I am trying to make a cell in my workbook, reference the value of an uploaded file (and cell) in onedrive. Can anybody help me with this? I have no issues with a local computer address, but I can't...

I am attempting to create a search where the user enters the search criteria and the return would search an online sheet and return multiple results and columns. Example: Search Dog Results Sam Brown 12 Tested Sam Yellow 15 Not Tested Sam...

Hello guys, I am banging my head on this one. I would like the spreadsheet to have access to an image online, everytime I open the spreadsheet I want it to retrieve the image and show it. I am a newbie with macros, so I would appreciate details. Is there any way of doing it without macros, btw...

I'm working on a macro to download three files from this website (North America Rig Count | BakerHughes.com). I want to run this code every week, but the link addresses change when the workbooks are updated. The names always stay exactly the same. Is there a way to open the workbooks?

Hi, I'd like to know if it is possible for my spreadsheet to be updated/linked to other worksheets that have been uploaded into an online database? Any direction would be greatly appreciated.

Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...

Hi Everyone, I am new to VBA and I need to fetch values from following form into excel sheet.https://www.moneygram.com/wps/portal/moneygramonline/home/estimator?LC=en-US Once the user clicks on estimate, the exchange rate is displayed. The excel sheet has column headings as the field names in...

Hello,</SPAN> My question is as follows:</SPAN> There is a linked spreadsheet on the internet, i.e. the data it is not directly on the webpage but instead you click on the link and then it asks you if you want to save or open the spreadsheet. I would like to insert a specific range of that...

Hello, I'm trying to set up some way to automatically download data into Excel from a website on a routine (daily or weekly) basis. I've never tried anything like this before, and it looks like I need a lot of help. To complicate it, the website is password-protected (I have the password). Is...

I want my group to be able to search my excel membership data from the web. I want it secure, we currently have a sign in forum (phpbb) which is where we would like to place it. Is where a web application for this, or a software that I can install that will allow the user to search the data and...

We recently completed an online Excel test that people can take then post the results to Facebook so if you're an Excel expert and have 5 min to spare, we'd love to get your input on the questions and format to help make it better. If you can help, we'd really appreciate it ... plus you can let...

Hi All, I am a big fan of Mr Excel but I am surprised that he does not have any subscription/paid online based Excel training courses/tutorials. I mean there are plenty of resources on Mr Excel but they are not organised in a way that a book would be organised. I will be happy to pay a premium...

Hi all, A client of mine who has developed an Excel analysis application would like to know whether it can be run on a server, for either internal intranet use by a client of his, or on an internet facing server. Is this possible with Excel? Thanks in advance. Yoogie8