website

Hi Guys, Below function: HYPERLINK(HLOOKUP($A187,'FID Shelf'!$G$7:$AE$27,M$1,0) this function receives value 'various', inside 'various' in another sheet I have hyperlink to the website, but function doesn't recognize hyperlink, I receives meesage "Cannot open specified file'. when change...

Hi guys, In Sheet1 i have the following formula which displays the value(hyperlink to website or distrubution list) from Sheet2. =IF(ISNA(MATCH($A77,'MM Shelf'!$F$7:$AG$7,0)),"",HLOOKUP($A77,'MM Shelf'!$F$7:$AG$27,L$1,0)) This works correctly but how do i get to appear as a hyperlink so...

Hi, I am new to Access, so bare with me. I have 2 tables, both with date fields. One tables records visits to a website, by date, and the other records sign-ups by date. I have created a cross-tab query to count the visits by month and a second cross-tab query to count sign-ups by month...

I have a workbook with sheet 1 the data for clients. I need to lookup the client name and pull through specific data from sheet 1, their website address located in column D and copy that website address to sheet 2 column B. Their website address is a hyperlink and if I use the normal vlookup it...

Hi, Can you help me guys on this. I am trying to auto extract/pull data from a website using a SetCursorPos, everything went well except for selecting the date as it doesn't allow to force input the date and it only allows to select on the "datepicker". Here's the code I am trying since I...

Hi Guys. I need to create a button command that will launch a website that is selected from a DV list. I currently have a DV list in cell D15, that the user can select a useful web address. I then have a button which when clicked needs to launch the selected website in Google Chrome...

Hi guys. Can anyone help me with a code to export data from a website with login? access www.myurlfake.com/login user: userME pass: user123 after login goes to this page www.myurlfake.com/requests and exports the entire webpage

Hi All, I am trying to get the real time data from the excel file in the below website on my working excel file. https://www.eia.gov/petroleum/gasdiesel/ So if you go to the website, then you can see two excel files with the name "full history" that i need to link to my excel workbook. I...

Hello. Please, I need to know any safe website, where I can upload in easy steps my workbook, so in that way when I post a question here will be easier for you guys, just click the link. Thank you for reading this.

Dear Excel community, I have a spreadsheet where I will update periodically, key economic indicators such as manufacturing PMI, GDP growth rate as well as balance of trade for various countries for example. The data source will be via this website...

I am trying to get data from a website into a table in Excel. I am just using the regular button (get data - from web) in Excel (No code) Works fine for two websites but for a different website I am getting the following error: Details: "The remote server return an HTTP status code '404' when...

Hi there, I was wondering if someone could help get me started with a relatively straightforward script. I'd like a script that scrapes a particular piece of data from a website. Ideally, I could enter a URL in cell A1 and in cell A2 enter the following formula: =scrape(A1) and it would the...

I have a website that requires and username, password and a unique IP address depending on what device you are logging into. I would like to build a spreadsheet and with VBA autofill this information by clicking the specific IP. Is that possible with Excel?

I have a list of info in a spreadsheet and i need to get it into fields on a website. I thought sendkeys might be useful as cell A1 needs to go into one field, then there are 3 tabs before B1 needs inserting and so on....... However, if I have the spreadsheet and the webpage visible at the...

Hi, So I want to add a feature into a current spread sheet were the cost of a material is updated automatically based on a figure from a website. an example of this would be the price of Aluminium. I want a cell in my spreadsheet to automatically update when opened to the the price of...

history - I work in procurement and have been operating a 'picklist' to help folks get the supplies they need for almost 6 years. The project started as an excel html website (static) and matured to a wordpress site. HQ nixed the wordpress site, needs to be hosted on the intra-net. back to...

Hi, I want to have a link (to a website) within other text, so something like: Please refer to website link for further information Thanks for any help, Catherine