Alternative Download Locations For MOREFUNC.XLL 5.05?

Mar 26, 2009

Are there any alternative places to download MOREFUNC.XLL? The link at the Morefunc for Excel site is broken, and the forums seem currently busted as well.

View 2 Replies


Nbtext Fx From The Morefunc Add-in Freeze

Feb 10, 2004

does anybody know why i can't seem to use the nbtext fx from the morefunc add-in? it will freeze my computer up everytime i try and use it.

View 9 Replies View Related

Set Locations Using VBA

Dec 5, 2007

I have to manually cut/paste each excel doc which belongs to a specific Store folder, and copy then into their own shared directory, so for example:

Lets say my company has 10 Stores, and I know their online folder locations, the first step I guess would be for me to map the locations of each store, I am not sure what the best way to do this is, would I use the Case select ? to make the set = ?

So for example, Stores 1 - 10.

Set 1 = Dir("Z:Northwest1")
Set 2 = Dir("Z:Northwest2")
Set 3 = Dir("Z:Northwest3")
Set 4 = Dir("Z:Northwest4")
Set 5 = Dir("Z:Northwest5")
Set 6 = Dir("Z:Northwest6")
Set 7 = Dir("Z:Northwest7")
Set 8 = Dir("Z:Northwest8")
Set 9 = Dir("Z:Northwest9")
Set 10 = Dir("Z:Northwest10")

I am not an expert on Case Select, but was thinking:

Select Case myStores
Case Is = 1.......................

View 9 Replies View Related

Backup At 2 Locations

Dec 15, 2012

The code below works. Now I need that while it does the backup file in the same location, we also took into C: Backup_Contabilidade. Finally also put the date and time.

Private Sub Workbook_BeforeClose(Cancel As Boolean) With Application
End With

Application.DisplayAlerts = False

[Code] .....

View 3 Replies View Related

Counting In Different Locations

Dec 14, 2011

i am counting hotels in different area of 1 city

city area hotel_name hotel_name hotel_name
NY st-1 A001 B001 C001
NY st-2 B001 C001 D001
NY st-3 D001 E001 A001

count by checking NY and see how many branches A001 is having in all these areas. (i should get answer 2)

View 6 Replies View Related

Download File From Web Using VBA?

Nov 12, 2008

I have been working on automating IE. Part of my task involves using explorer to download a file from a given url and save it to disk. I've figured out how to launch explorer and start the download, but then a dialogue box appears asking whether to save the file and where to save it. how do I automatically get past this and save the file to e.g "quotes.xls"?

View 7 Replies View Related

Backup Spreadsheet In Several Locations?

May 13, 2014

I have a spreadsheet on a server, password protected, and certain columns, rows locked...

This is shared with 6 others and can only be accessed one at a time.

If It so that when the user saves the spreadsheet it saves over itself on the server it's located AND on the individual users computer as backup; how would I go about doing this!?

View 3 Replies View Related

One Cell Reading From Different Locations

Dec 1, 2008

the attached workbook, I am looking for M19, N19 & O19 to read from different locations depending on how many cells are called on when info is entered in P8.

View 10 Replies View Related

Resetting Shape Locations

Apr 12, 2012

I have many spreadsheets that use shapes such as arrows and other symbols. The process for these spreadsheets is to move the shape (arrow for Ex) to indicate a specific location of pain or something like that.

Once the arrow is in position, the spreadsheet is printed to PDF and and a snapshot (in adobe) is "taken" and the picture (with the arrow) is pasted into our application.

My questions is how can I move the shapes back into position when you want to do it all over again.

When I have a few shapes I use

PHP Code:

Set sShape = ActiveSheet.Shapes("Right Arrow 6") 2
    With sShape
       .Top = 220
       .Left = 91
       .Rotation = 20
   End With 

For each shape

But if I have lots of shapes, 50+, it's a bit more cumbersome.

Can I loop through the shapes when I enable the macros to pick up the current positions and use that information when I do a reset (loop back again to move any shape that were touched back to where it was when the spreadsheet was opened?

Currently I have them close the spreadsheet without saving and just reopen.

View 3 Replies View Related

Same In-cell Dropdown In Two Locations

May 21, 2012

I made an analysis table that shows a list of prices on a certain company. I have a table on one worksheet and I made a chart (from that table) on another worksheet. I'm using an in-cell drop down list on the table worksheet to change to different companies. Is there a way that I can put the same drop down list on the chart worksheet? Essentially, I want to be able to switch the company on either worksheet and have it change on both worksheets. I'd like to keep the chart and table uniform and running together.

View 6 Replies View Related

Determine Net Displacement Between GPS Locations

Oct 20, 2012

I'm trying to determine the net displacement between GPS locations and am wondering how I can easily code this in Excel. As far as I know, you need to calculate the distance between Point B to Point A, Point C to Point A, Point D to Point A, and so on. The following is the formula that I would use:



Point A

Point B

Using the following formula (or setup), this is how I would calculate net displacement:

(123460-123456)^2+(3700010-3700000)^2 = (16)^2 + (10)^2 = 256 + 100 = 356

I assume if I want net squared displacement, I would square root this value SQRT(356) = 18.867

If my formula is correct above, I wonder why Excel gives me an answer for the following net displacement formula (same as above just using Excel formula): (A3-A2)^2 + (B3-B2)^2 = 116

Using this same formula, I could incorporate SQRT in as follows: =sqrt(((A3-A2)^2) + ((B3-B2)^2)), which results in 10.77. This value is clearly different than the value above (18.867) thus I wonder if I'm just mis-calculating something in Excel.

View 4 Replies View Related

Preset Tab Locations In Workbook

Sep 10, 2007

i have a User form that i'd like to add preset tabs command locations to.

For example,

on open i'd like the active cell to be on cell M3. and as the user presses the tab button jump to the following cells locations:


View 9 Replies View Related

Moving File Locations

Mar 5, 2010

I have to select about 200 odd files from a folder, and move them to a different folder. The problem is, I have to manually select the 200 files from a list of approx 10,000 (not in order).

I have a list of the filenames (with extension) in an Excel Spreadsheet, and I'm wondering if there's a way to automatically move the files using an Excel macro or something?


File location = C:EBDumped
and I need to move the 200 files to C:EBSent

So I would need to move ONLY the files where the file name is in the Excel list.
The file type (extension) is always the same, but the name (and length of the name) is different.

Is this possible using Windows XP with Excel XP?

View 9 Replies View Related

Can't Download Trusted Hyperlink

Aug 29, 2009

I have looked through the XL2007 security settings and can't find any way to list a (known secure) hyperlink as trusted so that it will download without manual intervention.

View 11 Replies View Related

Search And Download Subtitles By VBA

Feb 23, 2014

I'm trying to use macros in order to download subs directly from the Excel sheet. The idea is put the name of the film or television series in an exce cell. When you set enter, the vba programme search the subtitles into the web site (such as Search in 6.626.100 subtitles | : Seek & Find Subtitles, or Subtitulos de Series - Comunidad hispana de traduccion de Subtitulos) and then download the right sub into a local folder.

I have found information about API for windows, and I used a code to download a statical file (without searching), but how to download files after queries.

View 2 Replies View Related

SUM-OFFSET: Sum Of Each Name From The Download Sheet Tab

Oct 23, 2008

I don't know why my Sum/Offset formula is not functioning correctly. =SUM(OFFSET(Download!H2,0,MATCH($B$3,Data!A1:P1,0)))

I'm trying to attain the sum of each name from the Download sheet tab but my formula returns a 0 instead of 2,181(the correct answer). The rows on the Download sheet are varies so I thought the Offset formula would be best. Could you review my spreadsheet and formula? Can this formula accommodate an exclusion criteria? example sum all the count except for the one with the maximum time from column D?

View 2 Replies View Related

Download Data From SAP To Excel?

Dec 7, 2006

how to download data from SAP to excel?

View 8 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 Download Pictures From Excel

May 16, 2012

I know how to insert pictures into Excel, but how do I download them from Excel into my computer.

View 1 Replies View Related

FTP File Download With Loop?

Jun 2, 2014

I have the following code that I want to download everyfile at the listed ftp site to a folder on my computer. I was thinking about trying to make a key with dates in thisworkbook sheet1 starting in cell A1 and have it loop through.

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


View 1 Replies View Related

How Can I Write A Macro To Download

Mar 23, 2007

how can i create a macro to open the page


and download all the form into excel automatically?

View 9 Replies View Related

Mass Hypelink Download

Jun 13, 2008

I have a list of 2000 hyperlinks (http) that I need to download, I'm working on a corporate network so I can't just use a mass download client. Cany anyone give me some guidance creating a macro to save the target of the hyperlink as a file then move on to the next hyperlink until the list is exhausted.

View 9 Replies View Related

Download Html Source From The Web

Jun 19, 2008

I need to do seems quite simple, I want to grab the source of a webpage into a string (where I'll then to some fiddling about with it to strip it down to the information which I need). Currently I'm trying to do it using the webbrowser object and meddling around with the .document properties, but I can't figure it out.

UserForm1.WebBrowser1.Navigate UserForm1.address.Value
grrr = UserForm1.WebBrowser1.Document.body.innerText
UserForm1.sourceoutput.Value = CStr(grr)

View 9 Replies View Related

Download Toolbar Icons

Feb 19, 2008

microsoft toolbar buttons as I'm not especially artistic, but would like more choice when creating custom buttons ?

View 3 Replies View Related

Average Formula For Multiple Locations?

Mar 30, 2014

HTML Code: 


I have the above array formula which I wanted it to calculate the average of all products selling in each store, but it seems to be calculated each?

In column b I have the store number, column I is the sales, I want to average all the sales in column I for each store.

I have probably over complicated?

View 3 Replies View Related

Verifying A List Of Names And Locations?

Aug 21, 2014

I have 1 list with two columns, where column A is the location (a 3 digit code), and column B is the name (a 4 digit code).

I have a second list with two columns, again column A is the location, and column B is the name.

I want to make sure the locations and names in the second list match what I have in the first list. If they don't match, I somehow want to flag this in a third column.

View 4 Replies View Related

Turning Locations In Cells Into Values

Aug 4, 2009

I am looking to do find the latest date in a list of dates but have several problems:
1) The dates are all in one column on worksheet 1, but are sourced from other worksheets. So even though it looks like '8/7/09', the value of the cell is 'Worksheet2!B4'. This is making the MAX function not work

2) How to deal with the blank cells in the MAX function?

View 12 Replies View Related

Identify Multiple Locations More Than X Miles Apart

Mar 16, 2014

Distance Calculations Example 1.xlsx

I need quickly identifying multiple locations based on their proximity to an initial location and each subsequent location selected. I have attached an example spreadsheet that is structured in the following manner:

Cell H2 is the 'initial' location that will be used to identify all subsequent locations
Colums A through C are location specific details including latitude and longitude of all 450 possible locations
Column D is a distance calculation based on the difference betwen the location in column A to the 'initial' location in cell H2
Cell F2 is the necessary minimum distance between locations(in miles)
Cell G2 is the number of locations needed(this will vary)

What I am trying to accomplish is to fill column H with the number of locations specified in cell G2 that are atleast the minimum distance in F2 apart from each other, like drawing virtual circles around the locations on a map.

I am pretty sure this can be done with a Macro, but am not sure if that is the best solution or not. I am a novice Excel user, so even though I don't know the solution, I can already see two issues:

1. Whatever the solution is, the reference in column D will need to change to calculate the distance for each subsequent location instead of staying absolute with cell H2(H3 for second location, H4 for 3rd, etc...)
2. With each selection that is made, any location less than the specified distance in cell G2 should be removed from any future choices for subsequent locations.

View 4 Replies View Related

File Locations (code To Specify Where A Database)

Oct 27, 2008

I use the below code to specify where a database is:

View 2 Replies View Related

Finding Sum When Locations Of Inputs Not Originally Known

Mar 5, 2013

I have a spreadsheet where there are two drop down menus with various options. Based on those two inputs, my spreadsheet calculates a "savings" for each row. Now, I want to have cells that will keep a running total of each combination possible. I tried:

=IF(AND(A2:A37="OKC",C2:C37="AF33"),SUM(G2:G37)) but it didn't work...

A column is where you can enter 1st option
C column is where you can enter 2nd option
G column is where the savings results for those combination of inputs is populated.

I need a cell in say, J column, to sum all numbers from G column, where the combo of "OKC" and "AF33" exist.

View 6 Replies View Related

Copyrights 2005-15, All rights reserved