Create Registry Of Users In Order To Push Out Updates
Jul 17, 2013
I have created an excel application using VBA that is posted publicly on a website and currently being downloaded by users around the world. I would like doing either of the following:
1) create a simple way to keep track of who has downloaded the application (e.g. is there a way to have people register with their email when they open the program for the first time?) so that I can send a mass email whenever a new version of the application is available
OR
2) be able to automatically send a notification to users when an update to the application has been made (e.g. is there a way to tap into Microsofts' update notification system so that it automatically updates the application for users with internet connection?)
View 1 Replies
ADVERTISEMENT
Jul 1, 2012
I am trying to create a chart which updates every time a new date (and its data) is added to my list below:
Date
Clicks
Impressions
Click Through Rate
01/06/2012
3
93
3.23
02/06/2012
4
100
4
03/06/2012
2
102
1.96
The chart plots the number of impressions and the Click through rate (on a secondary axis) against the date.
I think I need to use the offset property but am not totally sure how to do this
View 3 Replies
View Related
Nov 26, 2012
I have an excel workbook that serves as a master workbook. I have to create 30 copies of this workbook, 1 for each site. Each workbook will have small differences in the data held. This is because I will refresh the sheet before saving it. There is a dropdown list on the 1st tab of the workbook that contains the names of the sites. The sequense, I suppose would be like: select the next name on the dropdown list"calculate" the spreadsheet to enable the refreshsome sort of "save-as" with the name from the dropdown list forming the name of the file. The Master file must be kept intact.select the next name from the dropdown listcalculate the sheet ........and so on I have a few other things I will add to the script like Protect Sheet etc.
View 1 Replies
View Related
Sep 18, 2012
Modify Macro3 and use the InputBox function twice so that Macro3 would ask the user for a particular month and a particular year; and then Macro3 uses these user’s inputs to create the calendar template for that month of the year. For example, if the user enters February for the month and 2012 for the year, Macro3 would create a new
VB:
Sheets("Template").Select
Sheets("Template").Copy After:=Sheets(1)
Sheets("Template (2)").Select
Sheets("Template (2)").Name = "January"
[Code]...
View 1 Replies
View Related
Feb 12, 2013
I've written a ton of VB macros that do various things to a raw data sheet. I want now to create a custom menu (in the the menu ribbon bar at the top of the screen). I'd like this menu to be used to activate the various macros for whoever has my add-in.
I've found several examples on how to create an add-in, and creating custom menus, however they all for when someone opens a workbook with the code, and then they remove the custom menu when the workbook is closed. I would like my custom menu to stay on the users ribbon bar no matter what workbook they have open. The only time the custom menu should not appear is if the user removes the add-in.
View 6 Replies
View Related
Feb 7, 2014
I am trying to create a master file, with a macro built in, that will allow multiple users to use it at once. The macro is to open a dilouge(sp sorry) box showing the contents of a specific folder, allow the user to selct one of the sheets, then copy and paste the set details from the hidden tab on this sheet (All sheets will be the same barring title), append the details to the master list in the first empty row.
I've got this far thus
Sub Macro1()
'
' Macro1 Macro
'
'
' Modify this folder path to point to the files you want to use.
FolderPath = "My Folder name here"
' Set the current directory to the the folder path.
ChDrive FolderPath
[Code] .....
So I can copy the row, but I can't get the first part to open .
View 3 Replies
View Related
Apr 1, 2014
I am trying to create a sheet which captures the Worked hrs for users in various cells. The SUMPRODUCT does not seem to be working for me .
Attached is the sample sheet which i would like to get the SUM using SUMPRODUCT.
Col D under Data Sheet has the names and these are repetitive. The Hrs / min in column E & F (Regular Hrs) & Additional Hrs / min under H & I.
I would like to have the Regular hrs + minutes to SUM up against each individual and displayed in consolidated under Col D (Regular hrs) & Col E (Additional Hrs).
I am using Excel 2010 and when i have used the same formulae in 2003 it worked. Not sure why it is not working in 2010.
View 2 Replies
View Related
Jan 7, 2010
I've had my Excel 2007 set up for the longest time to show the 30 most recent files when clicking on the office button. After changing it to 50 the office menu in Excel runs off the bottom of the screen and I can no longer get ot the options at the bottom to change it back. Does anyone know the registry key to modify this setting back to the 30 that allowed the full menu to be visible?
View 2 Replies
View Related
Sep 4, 2006
How to search and get the path of a folder present in windows registry using VBA excel.
View 9 Replies
View Related
Mar 14, 2007
Is it possible to make a setting in the registry, so next time excel opens
the addin is not "marked" in the addins-list. I can't do it manually because, because the close_event in the addin will be executed and that will screw things up.
Currently I'm looking at the regkeys: addin-manager and options, I see a change in the registry if I close XL when I unchecked an addin from the addin-list. It looks promising, but Iám not familiar with it
View 3 Replies
View Related
Mar 23, 2014
how to retrieve Install date of Windows from registry (or form any where else). I know this date is saved in key "HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionInstallDate", I used RegRead but it return "0" (zero)
View 6 Replies
View Related
Jun 23, 2014
I need a code to sort worksheets in a huge workbook. Is this technically possible!?
The information containing the worksheet order is available in worksheet "Aux", column A contains the rank (1,2,3,...etc.), whereas column B contains the corresponding worksheet names.
View 2 Replies
View Related
Sep 7, 2013
Way to create order and quote numbers. I'm currently starting an order number with a "O" in front of the order number and a "Q" in front of the quote number but this presents a problem when trying to create the next consecutive number because the number has a letter at the start of it so I can't use the method plus 1. I'd just simply remove the "O" and "Q" from these numbers but I need the numbers to be unique from each other and putting the "O" or "Q" in front was the only thing I could come up with to avoid the numbers ever being identical. I often need to look up these numbers and return the values in that row so the numbers need to be unique from one another.
The information for quotes and orders is saved on separate workbooks but I'd still like the numbers to be unique from one another.
Having a letter at the start of each number or a work around for using the plus 1 method when you do have a letter at the start of the number?
View 9 Replies
View Related
May 13, 2009
I am trying to create custom sort list. It works below when I define range as A1:A79.
Sub SortWS2()
Dim SortOrder As Variant
Dim sheetsorder As Range
Dim Ndx As Long
Application. ScreenUpdating = False
With Worksheets("Sort Order").Range("A1:A79")
For Ndx = .Cells.Count To 1 Step -1
Worksheets(.Cells(Ndx).Value).Move before:=Worksheets(1)
Next Ndx
End With
Application.ScreenUpdating = True
End Sub
I have created a dynamic range called sheetsorder. If I revise my code it does not work.
Sub SortWS2()................
View 6 Replies
View Related
Jun 26, 2008
I need to create a purchase order page whereby each item is then transposed into seperate sheets detailing the product along with price etc. I need the po number to be automatically generated to follow on from the previous therefore giving us a continuous po thread. I also need the purchase order as typed to be saved into a seperate sheet / file each time so that the po is always blank when someone else creates a new post
View 4 Replies
View Related
Sep 17, 2009
Hi Guys,
im really stuck and could use one of your expertise.
i have an excel spreadsheet with 65,000 lines of data
i have 9 Coloums in the the file
Despatch DateCustomerDseqOrderLineItemPost CodeVol m3Gross Kg
13/02/09jason00002029095R055TR4 8QQ0.1099280.3313/02/09jason00002034741R043TR4 8QQ0.31621218.313/02/09jason00002034742R064TR4 8QQ0.8793673213/02/09jason00002034743R045TR4 8QQ0.94863684.9
i need a line here to sum it before the next order starts?
13/02/09jason200002033141A157WD18 7QX0.02832113/02/09jason200002033142A096WD18 7QX1.609288213/02/09jason200002033143A125EJAWD18 7QX0.849646.813/02/09jason200002033144A09JJAWD18 7QX0.13732102.8
im trying to create a formula that will sum each order on another new coloum which i will create called total weight
i need it to search the date then the customer name then the gross kg and total them up as there is multiple orders
View 9 Replies
View Related
Apr 11, 2014
I'm trying to make an order form that is based off of a price list. Basically there will be 200 items or so someone can just enter the quantity they want into a column. I would then like another sheet on the workbook to auto-populate all of the fields available. The thing I'm having trouble with is I don't want the finished form to be as long as the price list with blank rows in-between. I've been reading up to make a macro work for this, but have had no success.
View 3 Replies
View Related
May 15, 2014
create macro in order to protect Data Validation rules.
e.g. If user copy and paste cells from others source which is not in the same validation criteria or not contain any validation rules, the existing validation will gone.
so, is there any macro which will be able to automatically run to prevent the data validation?
View 7 Replies
View Related
Jun 20, 2014
I am trying to create a spreadsheet that will automatically increase the work order number by 1. The cell will always be in the same place. The idea is that when the file is opened it populates the number. After being closed and reopened the number will be 1 higher than the previous.
The page will reused by various people to create and print work requests for my mechanics, I want it to assign the W/O automatically.
View 11 Replies
View Related
Oct 8, 2008
I’m getting data from query. My data has fields: Item No, Customer ID & Sales rep.
I need to find out for each Item number which customer put order and who was the sales rep. (Excel 2002). see file attached.
View 4 Replies
View Related
Jul 17, 2014
I have a lot of data to try and summarize but they are in multiple smaller tables. I wish to only extract 2 variables, 'number' and 'total' from all of my smaller tables (lots of them) so the problem looks like this, i have these tables for example where the 'total' title is in a different column depending on which of the smaller tables you are looking at:
cat 1
cat 2
cat 3
total
[Code]....
I am trying to get:
number
Total
123456
30
234567
60
[Code]...
Because the number column is fixed and all of the smaller tables will all have a number in the same column maybe i can insert a column next to the number column and say "find the value where the column title is 'total' - however the location of the column title would change so not sure if this would work? I was also thinking of sorting the columns but that will not work either because of the smaller multiple tables?
View 4 Replies
View Related
Feb 8, 2013
My problem is to create a macro that will list all folders, subfolders and files in an order in excel. So that I know which folders and files belong to which main folder, more like a hierarchy.
For example,
Sourcefolder
Subfolder 1
File1
I have code that list all files in folders and subfolders, but it does not put them in a hierarchy fashion.
View 8 Replies
View Related
Jun 26, 2014
I work for a Machine Shop in the Toledo area. We use a quotation sheet to quote our products to our customers. It has 3 cells that describe the Customer, the Contact person at that customer and finally that Contact's Email Address. I have a drop-down menu in each of these cells. The first, Customer, is based off a simple list of our customers. The Contact drop-down then uses the Indirect Function to search the worksheet for that Customer. The drop down is actually based off of a Range Name saved as that Customer's Name.
However the problem is many of my customers have & or , and since Excel does not allow those symbols or even spaces in a Range Name I have to use Substitute to be able to keep the spaces and the & or ,.
It is important that on the Quote Sheet the Name of the Customer is identical to the actual name of the company so I cant use AND instead of &.
Currently my Second drop down, Contacts, has a formula that looks like this {=INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($H5,"_"," "), "3", "&"), "2",","))}.
My problem is that when I give the Range Name a Name , my drop down doesn't work and Excel tells me that the above formula results in an error.
View 6 Replies
View Related
Dec 30, 2009
Not sure if this is possible but...
What I'm trying to compile is a sheet for this...
1. user enters a date
2. user selects from dropdown list
3. user enters numer via text box
4. user pushes button to complete data transfer
Example info:
1. July 12, 2010
2. clothes
3. 112.27
Formula or method to complete the following actions...
Enter "112.27" in column "clothes" on row "12" on the sheet "July". he method has to be sound for changing columns, rows and sheets.
I've got the calendar and interface done, but I cannot figure out ow to get the data to the specific cell on the sheet. his seems to require "pushing" data rather than "pulling"...
View 10 Replies
View Related
Jul 5, 2014
[Code] ...
How to push strResult into an Array? And how to set and use something like an id?
strResult.id = n
I would like to archive something like:
MsgBox (strResult(0))
MsgBox (strResult(1))
MsgBox (strResult(this.id))
etc
View 13 Replies
View Related
Nov 6, 2009
I have an Excel 2003 spreadsheet with pupil test scores and would like to automate the total. Example attached.
There are N tabs (one for each class; there is one or more class in each year group) of raw data; all the scores are numerical but some entries may be blank. After entering the raw data I would like to press a button on each “Total” tab to collate the data.
Total A presents the data in class order; the column marked Class should just say A1, A2, B, etc. If there are multiple classes in a year group then they should appear in order, that is, A1 followed by A2 followed by B, so on.
Total B presents all the data in ascending surname order.
View 14 Replies
View Related
Feb 3, 2010
I'm looking for something that will be able to push or pull data from a workbook (named "Personen - test.xls" = persons) to an other workbook (named "Personen per maand.xls" = persons/month). In attached documents i tried to make clear (sorry, it's in dutch) what i would like to do. In English; the marked data in "Personen - test.xls" should automatically be shown in the marked area in "Personen per maand.xls". I think the biggest problem is the fact that "Personen per maand.xls" is a standard-document which should be filled -time after time- with many different data's from several "Personen - test.xls" documents. These documents are all named different, the data is always given in the same way. So in my opinion i should make something where i can tell excell which document to use and something i can tell where to put the data. But i really don't know how to do this...
View 11 Replies
View Related
Nov 23, 2009
i have a Macro Button which overlaps the cell G2 (a merged cell)...
is it possible that "when Press Enter Key on cell G2 then Launh a Macro.
or
when press space bar on cell G2 then Launch macro"... Macro is same as the Macro Button that overlaps G2...
this would prove to be a faster way than using a mouse to click on a macro button.
View 9 Replies
View Related
Mar 3, 2007
This is one of several questions I need to ask to perform a larger task. I want to initiate VBA code using a push button. What code do I need in the VBA to do this and rules behind using it.
View 4 Replies
View Related
Jan 22, 2008
I was trying to build a macro which will push - copy and paste (but only values) the last raw down for one line. I tried to use existing answer for copy, paste and pushing down rows find on this forum, but raws a just moved without pasting the values.
View 3 Replies
View Related
