location

So I have some code that I don't want to run until after the user selects save on the SaveAs save location prompt but it appears the BeforeSave event runs the code before the prompt even opens. Is there anyway around this or some other method to define a trigger event for once the user selects...

I have a program that ACW helped me with years ago(pretty sure it was Excel 2003 aka v11, currently on Office 365) that does a look up and converts name to its corresponding item code. This uses a range named "lurange". I am now running into an issue it appears that "lurange" is defined as lines...

there are three spreadsheets I use that I would love to be able to force to always open at a specift size [focus]. if a screen location could be specified as well that would be great. is this possible?

So I want to initiate the save as for the file when the user clicks the "Finalize report" button but there's a small difficulty I have the name for the file and the location of the file in a sheet that takes todays date and formats it to match the location of the file in the network drive and...

I'm trying to insert vba code into a macro to will allow the user to access an excel data file in a directory location they do not have access via network security. I established the following network user id "salesid" and the password is "salesdata' the location of the file is...

I am looking to extract the SN: from the Cell Regardless of the other Info in the Cell. Is this Possible? <tbody> Serial Number <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Summary Description [TSupport] Incident J3MH200000 routed to...

Hi there, I hope this request finds you well and in super fine spirits today ;-). I have searched through the archive and see that there are plenty of excellent solutions but not one that fits all my requirements (i'm just such a control freak!). This is my first request so apologies if...

Hi to all, I’m trying to get the result in the following statement: Sheet1: Column A - I have the list of part numbers. Column B - I have location (A) Column C - I have location (B) Sheet2 Data: Column A - Part numbers repeated Column B - locations repeated Column C - Quantities The result...

i have 2 columns of data ( label text ) the labels are location specific , the 1st & 3rd column details the location for each. how can my spreadsheet merge the 2 label columns so that the locations are in progressive rows? so my data is F,G,H,I and i need J,K to auto sort F is location, G is...

Hello,</SPAN></SPAN> I got a column "I" with values bringing back from formula sum</SPAN></SPAN> I want to filter all duplicates of this "I" column and copy all C:I columns to location columns L:R</SPAN></SPAN> Example....</SPAN></SPAN>...

I am creating the body of an e-mail with some file location. This code works if Fileloc does not have spaces: HTMLBody = "Hello ..<br />next line ..." & _ "Click <a href=" & Fileloc & ">" & "some location" & "</a> to ..." How can I amend it to take into account...

In Excel, I have created a sub that creates an e-mail in Outlook and adds some text in the body. In particular, I have text which is a location, such as: C:\MyLocation\MyFiles\ The problem is this is displayed simply as text. I want it to be hyperlink. Can it be done with VBA from Excel...

Hi all, I have merged two pieces of code together and it is working perfectly. To make it more perfect I wanted to modify it once more but I am having trouble making that work. I have some code that looks for text files in a hard coded folder location. Then a pop up box asks the user what text...

Hi All A while ago I used a forum and posted a problem which was solved by using a VBA script. This script works most of the time but not always. The original problem I had was that I get given an excel sheet with 3 columns detailing a description, a part number and a location. I needed...

Hello, I am a more or less a beginner with respect to Excel and need a little help here. I am a poker player and keep track of my winnings and losses in an Excel Sheet with diagrams etc. In essence the important part of the sheet looks something like this: <tbody> location net total...

Hi Thank you in advance for any help with this one. To put things into context, the spreadsheet as a whole filters a number of pivot tables by 'manager name' and this updates some data which updates a chart in five different sheets. This chart is then copy and pasted as a picture in...

I am trying to write a do if loop command that takes a look at data in 3 different columns and then outputs a value to a 4th column (F in the command). When I run this command, Excel stops responding, I have even left my computer for a few hours and still not responding, please help with what...

Hello all, i have 2 listboxes. one is populated by a command button, it sets a list of vendors. from that box a the user can click on a vendor of choice, the second listbox will then populate with the parts that are at the chosen vendor. (both are dynamically created arrays) my...

Hi, I am looking to create a document which can find a specific bit of information based on multiple criteria. Currently i have a function which looks at a table for a Specific phone number, What i want to do is pull more a number based on a location code and the name of the number for example...