Cell Address And Http://local.live.com/

May 20, 2006

use an address in a cell and http://local.live.com/. i would like to paste an address into http://local.live.com/ from a cell (or concatenation) into the "Where" textbox...?

View 2 Replies


Copy File From/to Ftp/http Server

Sep 24, 2006

to copy files on computer which runs excell.
But is there a way to copy files from/to servers?

View 3 Replies View Related

VB Code For Conditional Formatting On Live Value Cell

Jul 3, 2008

Is there a way to look at a cell's own value and then format it accordingly using VB?

I have a cell whose value changes based on DDE link to live price data.
Cell is "Q5".

When the new value is greater than the old value - i want to format the pattern color of the cell.

When the new value is less than the old value - i want to format the pattern color of the cell.

Does anyone know how to do this please or is there a way to do this using spreadsheet formulas as oppose to VB?

View 9 Replies View Related

Need To Pull Street Address Out Of Full Address In A Cell

May 20, 2014

Assume the following list of addresses are all in separate cells of a single column (A1-A4). I just need the formula to extract the street addresses, and then a separate formula to extract the zip codes.





View 2 Replies View Related

Send / Receive HTTP Request - Insert Text Into Cells

Jun 28, 2013

Right now when I send/receive an HTTP request, I have the text displaying in a MSG Box. I want to just have the text inserted into cell A1 instead. I know I have to alter MsgBox MyRequest.ResponseText, but anything Ive altered it to, doesn't seem to work.

Sub http()
Dim MyRequest As Object
Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
MyRequest.Open "GET", _
' Send Request.
'And we get this response
MsgBox MyRequest.ResponseText
End Sub

View 2 Replies View Related

Hyperlink Error: "Unable To Open [link]. The Internet Site Reports That The Item You Requested Could Not Be Found. (HTTP/1.0 404)"

Feb 23, 2010

I'm trying to build a hyperlink using text formulas in Excel but I get the following error message: "Unable to open [link]. The internet site reports that the item you requested could not be found. (HTTP/1.0 404)". The strange thing is that if I copy-paste the link in the web browser, the page opens normally (which proves the link is correct).

View 4 Replies View Related

Open Workbook From Local PC

Jan 10, 2007

I have created a form wherein i have created a textbox to enter the excel filename and three different combobox to select the year, month and the day respectively. These are actually the folders on my hard drive and the excel files which i want to open is inside these folders with similar names. I want to search these files for the selected year, month and day from the combobox. The filename will be provided in the textbox. the path for the files is say c:yearmonthday*.xls

View 6 Replies View Related

Vba Hyperlink To Local Worksheet

Mar 7, 2007

I would like to, using VBA, assign a hyperlink to an excel cell that links to another worksheet within the same workbook. I've tried the forums, and combined with a previous post and MS Excel Help File, I've come up with the following attempt:

With Worksheets("Test Destination")
.Hyperlinks.Add Anchor:=.Cells(counter + 4, 5), Address:=strHyper2, _
TextToDisplay:=(#1/1/2007# + counter)

End With

strHyper2 is previously defined: strHyper2 = "[WeatherTester.xls]1!A1"

My spreadsheet file is "WeatherTester.xls", my worksheet is "1", and "A1" is the desired link location for the cursor. Counter is an integer. I get the error "Invalid procedure call or argument". I also tried to enter a hyperlink directly through the formula property, but Excel didn't like the single quotations I had to use within the HYPERLINK function. The hyperlink formula works in the following form: =HYPERLINK("[WeatherTester.xls]1!A1","1 Jan")

View 3 Replies View Related

State And Local Sales Taxes

Feb 21, 2009

Our state carries a 4% sales tax on all items except food and prescriptions.
Our county carries a 3% sales tax on everything.

Attached on my work sheet:
Column "C" determines if an item is either food or non-food.
"G5" is the subtotal of column G
"G4" is the S/tx on "G5" at 3%
"G3" is the S/tx on "G5" at 4%.
"G2" is the gross pay out.

My question is:
I'd like a formula for Cells "G3" and "G4" that can determine which items paid for in column "G" match a "N" or an "NF" in column "C".

If an item in column "G" represents a "F" in column "C", then there should not be anything in cell "G4" If an item in column "G" represents a "NF" in column "C", then there should be a figure in "G3" & "G4".

View 2 Replies View Related

How To Read All The Filenames From Local Drive ?

Dec 3, 2008

I need to know how to read a filename from my local drive c: ? for example in my local drive i have some 100 files, i need to pick there filename, date and time stamp .. etc.

View 7 Replies View Related

Creating A Local Named Range

May 8, 2006

I am working on a process model, which requires that the same basic procedure be carried out for each unit in the process.

One worksheet is allocated to each unit with data concerning the flow streams being passed from the previous unit and the product being linked to the next unit. Although the same procedure is therefore being followed on each sheet, the input data differs.

I currently have the code to perform the required technical operations and calculations for a single unit. This code is very much dependent on named ranges.

I want to use the same core to perform the routine-operations, but need either unique named ranges on each page or I need a way to define name that is limited to the specific worksheet on which it is located.

For example, I might have an input range for a heater and splitter, with a technical add-in in VBA performing calculations on the input for each unit. How can I use two separate instances of the name "Input" instead of "Input_Heater" and "Input_Splitter"?

View 3 Replies View Related

HyperLink To Pictures Saved On A Local HD

Jul 16, 2006

The default program for opening JPG files is "Windows picture and fax viewer" which is fine with one of my colleagues. Upon declaring and clicking on a Hyperlink, to a JPG fle, the picture is opened in "Microsoft photo editor". How can one define the program in which Pictures opens via Hyperlinks will be displayed!? (WINXP & Office 2002)

View 3 Replies View Related

Updating Local Excel File Through The Internet?

Apr 14, 2014

30 people in different countries use a sophisticated VBA Excel file on their local PCs, let's call it myexcelfile.xls. This file contains no custom data, as all data is stored in myexcelfile_backup.xls.

The biggest challenge with this set up is that whenever there is a newer release or bugfix of myexcelfile.xls, I need to send it out per email to 30 people and hope they replace it with my updated version.

Note that newer versions can replace older versions without any data loss, as all data is stored in the backup file.

Idea: with tools like WGET or BITSADMIN, I was thinking of creating a batch file, that would simply download the latest version from a FTP server, and replace the older version with the newly downloaded one.

Constraints: I shouldn't be using any software that is not native to Windows 7the files can sit in different folders on these 30 computers, therefore the update mechanism would have to identify the path they are in.the update mechanism would have to close the file first before running the update. Question: What is the best way to go about this? A DOS Batch file? Or another excel file that is just the "updater", meaning, it's only purpose is to download the new file from the web and overwrite the old file?

View 1 Replies View Related

Macros Is Saving Server Side And Not Local

Feb 17, 2009

I have a macros in my spreadsheet when I open it a number in the macros goes up 1 each time the worksheet is opened. I want to put this file on a server that can be accessed by various people. The problem I am getting is every time someone opens it from a different location with a different PC the number starts at 1 again. I want to keep the number going up 1 each time no matter who opens it.

View 4 Replies View Related

Slow Workbook When Connected To Local Network

Apr 26, 2009

I have Excel 2003 SP3 on Vista Home Basic fully patched. My code runs very slowly until I pull out the ethernet cable then it runs quickly.

View 9 Replies View Related

Download And Save Picture From Url Into Local File

Jan 28, 2010

I have a program operating in excel 2007 that extracts a picture from a URL and puts it into a PPT slide. I now discover that PPT 2007 doesn't allow this.

So my intent now is to download the jpg into a local file and then import into the PPT.

This is from a couple of sites:

At the top of the code:

Option Explicit

Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" _
(ByVal pCaller As Long, _
ByVal szURL As String, _
ByVal szFileName As String, _
ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long

in the excel cell if a URL picture needs to be inserted it starts with the prefix "picture=" then the http address.

This did not work.

So I then copied the code from the websites into a module (changing the destination file and URL to mine of course) and called the procedure and still nothing.

View 7 Replies View Related

Get External Data Web Query From Local Directory

Jun 18, 2006

I am trying to wirte a macro that will allow my users to import data from a HTML file locatedon their local hard drive. THe directory information will not change however I would like the opporutnity to "choose" the appropriate file prior to completing the macro. Do I need to construct a form first?

Sub QuestionGetExtData()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;C:foofoo.html" _
, Destination:=Range("A11"))
.Name = "foo.html"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False......................

View 2 Replies View Related

Local Settings Overriding Savechanges:=false

Feb 2, 2007

I have an Excel 2003 application that automatically opens and closes a lot of workbooks. When done with a workbook, I close it with: ActiveWorkbook.Close SaveChanges:=False

On most users' machines, this works well. On one user's machine, the procedure is still asking: " Do you want to save the changes you made to 'filename'? "

at each workbook close. Considering that a typical run might inspect over 2,000 workbooks, this is a problem for the user. Is there a setting that can override "SaveChanges:=False"?. If so, where would I find it, and how would I programmatically turn it on/off?

View 2 Replies View Related

Connecting To A Database Without The Local Machines Odbc

May 4, 2007

I'm working on a spreadsheet that will connect to a firebird DB (Programmed using VBA and ADO intially).. The spreadsheet itself will reside on a server in a shared folder..

When a user opens the file up, I'd like for the spreadsheet to use the servers ODBC connection, and not the client machine.. This way we don't have to install the Firebird ODBC driver on each client workstation..

View 9 Replies View Related

Open URL Or Local Html File With Command Button?

Jan 16, 2010

What is the code to open a URL or local html file with a command button?

View 4 Replies View Related

Send A File By Email Versus To A Local Desktop

Jul 13, 2007

Case "TD"
strfilename = "\TomsblackibmTomsProposals" & strfilename

I would like to send this file by email if possible instead of to his computer. The user recently went from a desktop "in the office" to a laptop "all over the place".

Sub Save_and_SaveSalesman()

Dim strPath As String, strPath2 As String, CurrPath As String

Dim WB1 As Workbook
Dim WB2 As Workbook

Set WB1 = ActiveWorkbook

'First thing, save my work

CurrPath = WB1.Path

'ASSUMING THAT C6 and O3 are BOTH in WB1
'move this line HERE: only do this once, and concatenate in the Select..Case later
'doing thsi inside the Select..Case pulls values from WB2, which might cause errors.............................

View 9 Replies View Related

Finding Multiple Local Minima/maxima From Data

Jun 8, 2007

I've tried a few searches to find this info, but have come up empty, so hopefully this isn't a complete re-hash of another topic...

I am trying to find a way to locate multiple local minima/maximas from my data. My chart essentially looks like a straight horizontal line with multiple, small spikes pointing downwards. I'd like to be able to locate the position of these minima easily.

View 3 Replies View Related

Using Macro To Find Email Address In Address Book Of Outlook

May 22, 2014

I am struggling to find a macro which can look at a name in column 'BT' and search it in the address book of Outlook to then place the email address of that person in column 'ED'

There are 35,000+ people in the address book and there may be over 5 email addresses for one name, so is there any way a message can appear for the user to select which email address is correct if there is more than 1 contact for that name?

View 1 Replies View Related

Create List Of Drives (local And Network Mapped) On Computer

Nov 5, 2012

how to create a list of the drives on my computer using VBA. Maybe I missed something.

View 2 Replies View Related

Dynamic Hyperlink To File Names Found On Local Drive?

Mar 31, 2014

I want to list file names from a directory and sub directories and hyperlink them. I have been able to list the file names onto an excel sheet, but I cannot get it to hyperlink to the file.

'Force the explicit delcaration of variables
Option Explicit
Sub ListFiles()


View 1 Replies View Related

Split Address Which Is In Single Column Which Contains First / Last Name And Address Without Any Comma?

Apr 24, 2013

I have a list for addresses in excel in single column as shown below - aanandhi narayanan 3430 chemin de riviere sanjose,CA95148


abdi abdi 5390 monterey rd #6 sanjose,CA95111

Sheribel Abinsay 3212 Gateland CT San Jose, Ca 95148

I need the result to be in a way like -

3430 Chemin de riviere
San Jose

3838 Glengrove way
San Jose

5390 monterey rd#6
San Jose

3212 Gateland CT
San Jose

I have around 12000 records with the same format.

View 9 Replies View Related

Get Email Address From Global Address Book In Outlook

Feb 25, 2014

On a worksheet called "Contact Info" column A starting in row 2 I have a list of names (variable length). In Columns B2-D I need the email address, work phone number, and cell phone number.

View 5 Replies View Related

Live Data Download Through VBA

Jan 26, 2012

I wanted to know how to download live data (stock data from a a website) through VBA.

View 1 Replies View Related

How To Capture The Value From A Running Live Value

Jun 9, 2008

I have a cell (for example, "A1") which is inserted with a WINROS formula to retrieve some data into my spreadsheet. And it is running live at all time.

Actually, I can't think of any formulas to capture the value from cell "A1" to "B1". Because I do not want the value that I captured into cell "B1" running live. I just want the value "B1" fixed after captured.

View 9 Replies View Related

Consolidating Live Tables

Nov 26, 2008

I have two tables that pull data from two different SQL tables via an ODBC connection and refresh every 5 minutes. The table headers etc are all identical (it is support call information FYI) but what I want to do is display those tables as one as opposed to two seperate tables - can this be done relatively easily and hopefully without the use of VBA? (Unless anyone is willing to provide the code of course!!)

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved