Alternative Download Locations For MOREFUNC.XLL 5.05?
Mar 26, 2009Are 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
ADVERTISEMENT
Nbtext Fx From The Morefunc Add-in Freeze
Feb 10, 2004does 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 RelatedSet Locations Using VBA
Dec 5, 2007I 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.......................
Backup At 2 Locations
Dec 15, 2012The 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.
VB:
Private Sub Workbook_BeforeClose(Cancel As Boolean) With Application
.CommandBars("Cell").Reset
End With
Application.DisplayAlerts = False
[Code] .....
Counting In Different Locations
Dec 14, 2011i 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)
Download File From Web Using VBA?
Nov 12, 2008I 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 RelatedBackup Spreadsheet In Several Locations?
May 13, 2014I 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!?
One Cell Reading From Different Locations
Dec 1, 2008the 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 RelatedResetting Shape Locations
Apr 12, 2012I 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.
Same In-cell Dropdown In Two Locations
May 21, 2012I 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 RelatedDetermine Net Displacement Between GPS Locations
Oct 20, 2012I'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:
A
B
C
X_Coordinate
Y_Coordinate
123456
3700000
Point A
123460
3700010
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.
Preset Tab Locations In Workbook
Sep 10, 2007i 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:
P3
Q5
P7
Q7
P9
Moving File Locations
Mar 5, 2010I 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?
example:
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?
Can't Download Trusted Hyperlink
Aug 29, 2009I 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 RelatedSearch And Download Subtitles By VBA
Feb 23, 2014I'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 | SubtitleSeeker.com : 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.
SUM-OFFSET: Sum Of Each Name From The Download Sheet Tab
Oct 23, 2008I 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?
Download Data From SAP To Excel?
Dec 7, 2006how to download data from SAP to excel?
View 8 Replies View RelatedLive Data Download Through VBA
Jan 26, 2012I wanted to know how to download live data (stock data from a a website) through VBA.
View 1 Replies View RelatedHow To Download Pictures From Excel
May 16, 2012I know how to insert pictures into Excel, but how do I download them from Excel into my computer.
View 1 Replies View RelatedFTP File Download With Loop?
Jun 2, 2014I 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.
Code:
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
[Code].....
How Can I Write A Macro To Download
Mar 23, 2007how can i create a macro to open the page
[url]
and download all the form into excel automatically?
Mass Hypelink Download
Jun 13, 2008I 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.
Download Html Source From The Web
Jun 19, 2008I 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)
Download Toolbar Icons
Feb 19, 2008microsoft toolbar buttons as I'm not especially artistic, but would like more choice when creating custom buttons ?
View 3 Replies View RelatedAverage Formula For Multiple Locations?
Mar 30, 2014HTML Code:
=100*($I2/AVERAGE(IF($B2=$B$2:$B$38129,$I$2:$I$38129)))
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?
Verifying A List Of Names And Locations?
Aug 21, 2014I 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.
Turning Locations In Cells Into Values
Aug 4, 2009I 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?
Identify Multiple Locations More Than X Miles Apart
Mar 16, 2014Distance 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.
File Locations (code To Specify Where A Database)
Oct 27, 2008I use the below code to specify where a database is:
View 2 Replies View RelatedFinding Sum When Locations Of Inputs Not Originally Known
Mar 5, 2013I 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.