How To Transfer Autocorrect Words To Other Computer Simply Export And Import
Sep 20, 2013
simply to say i want export and import all my "auto correct" words to other computer instead of typing manual...
Here some example am using daily ..
PLAN MISMATCH IN CPOS WITH CAFP 1
P2P NOT ELIGIBLE P 2
NEED CLARITY ON PLAN AND TOPPINGP 3
NEED CLARITY ON TOPPING P 4
NEED CLARITY ON RECEIPT AMOUNT AND RECEIPT NUMBERP 5
NEED PLAN APPROVAL P 6
if i type P1 in a cell it will show PLAN MISMATCH IN CPOS WITH CAF, i have like this many words. i want load it another one computer instead of adding manual typing. is it possible?
View 5 Replies
ADVERTISEMENT
Jul 8, 2014
I am having trouble with transferring a Macros to another computer. I have saved and sent the file via e-mail as a .xls and .xlsm to no avail and tried other methods of transferring the macros to the other computer. Also No I cannot copy paste the coding information to the other computer since there are multiple macros buttons since they are add one item and subtract one item from separate rows for inventory at a warehouse (about 100+ rows x 2 = about 200+ macros buttons).
View 1 Replies
View Related
Dec 8, 2006
I have a rather large workbook with around 10 sheets. i want to setup a 'export' button on this workbook that will allow a user to save raw data from this workbook into another excel workbook and an ' import' button that will allow user to import raw data and use the existing formulas/links from this large workbook.
As in sample file, i want to be able to export/import all the cells that are orange in colour (in my actual file, all raw data cells are not actually orange, thought colour coding it would make my problem easier to understand)
I was thinking around these options:
1) Copy and then PasteValues from the large worksheet into another workbook for exporting and same idea for importing
2) For all raw data, copy out all the values and put their corresponding addresses in another excel sheet. e.g. column1: Sheet1!$A$1, column2: value
and import it in by reading the address n value.
View 9 Replies
View Related
Apr 21, 2007
I have found code by John Walkenback
I need to adapt it to allow several worksheets to be exported to a workbook .cvs .Then imported back into the original workbook including all blanks.
I have included the Walkenback workbook and a test workbook that I have been playing with.
Just about reached the brick wall with my abilities on this problem
View 4 Replies
View Related
May 14, 2007
I have been copying the work sheet ranges
"Consolidated Data" D4:K17
"Support Schedule" D5:W504
"Tangent Calx1" D4:F34 , J4:J34 and M4:M34
"Tangent Calx2" D4:F34 , J4:J34 and M4:M34
To a seperate worksheet for export to a txt file {for saving}
Then {when required} importing the txt file data into the worksheet ,copy the data back to the worksheet ranges and re-calculating the data. I have struggled to trying and butcher the code and delete the copy stage and write just the required ranges to the txtfile.(And reverse)
View 8 Replies
View Related
Sep 8, 2006
write code to post Excel data directly to Peachtree using VBA rather than the export/ import process?
View 5 Replies
View Related
Jun 10, 2009
how to prevent that autocorrect "feature" in the Excel 2007 VBA IDE? It always deletes the last space I type after a second or so, i.e. moving the cursor to the left whenever I stop typing (to think for a moment or so).
View 9 Replies
View Related
Jan 27, 2010
Macro to export and import a module and assigning different macro automatically ...
View 9 Replies
View Related
Oct 11, 2012
I'm looking for a way to replace periods with colons using VB when a value is entered into a cell ranges. The ranges are
C4:L5
C9:L10
C14:L15
C19:L20
For info, this is an annual timesheet with 13 sheets in the workbook, each hosting 4 weeks of the year.
The cells are formatted as [h]:mm. Making an entry in the autocorrect table to replace . with : does exactly what I want. Unfortunately this is a global Excel setting rather than a single spreadsheet setting. I'm looking for a way to achieve the same using VB. Whenever a cell in this range on any sheet is modified I need that cell to be checked for periods and have them changed to colons.
In short (for example), I want to be able to enter 12.55 in a cell formatted as [h]:mm and have it autocorrect to 12:55 rather than enter a value of 301:12. Is this achievable without autocorrect?. It would need to only check the current cell been modified rather than scan all 4 ranges on all 13 sheets every time any cell is changed.
View 9 Replies
View Related
Aug 7, 2013
I am using Excel 2007. I would like to be able to type "dlta" followed by a space and have autocorrect change it to the symbol for Delta (a triangle). I got it to work in Word because I could right click and paste the symbol in the autocorrect dialogue box. Excel won't let me do that. I also tried typing Alt+68 because I believe that is the code for the symbol I want but all I get is a "D".
View 11 Replies
View Related
Mar 23, 2007
I only want to do a "macro" in VBA that must do two things
record the keys pressed (during only 5 minutes)
and save the results in a text file
It is the only code in VBA I try to write
I found public documentation (legal stuff I mean)
about GetKeyState
I have snippets of code for save data as txt file
But I don't succeed in finishing the all code.
My purpose is to show to my daughter in law that if she doesn't respect rules
on the net, I'm able (but I don't want to really do it, it's just a threat) to know what she's doing.
If I want a real keylooger, I've downloaded one on the net.
I haven't done that and I don't want to.
I don't think a vba code with
the function getkeystate and Open file (an only that)
is a danger.
View 3 Replies
View Related
Oct 12, 2009
I'm trying to put this formula into cell B31...
ActiveCell.FormulaR1C1 = "=R[-2]C/R[-1]C"
Current value of B29 is "1"
Current value of B30 is "0"
Result in B31 after formula is "#DIV/0!"
Mathmatically, the result should be "0"
I read Excel's help and it said something about putting this in...
IF(B31=0,"0",B29/30)
which I tried to, but it's giving me other errors.
How can I get cell B31 to put in a "0" if either B29 or B30 have a zero in their cell?
View 9 Replies
View Related
Apr 1, 2013
In a column range, i need to enter sequences of minutes and seconds as follows:
12:08
13:19
16:49
28:13
I had changed the format of cells to mm:ss but if i enter 12:08 excel shows it as 08:00 unless i enter it with the hour (00:12:08)
Is there any way to avoid entering the hour each time but simply minutes and seconds?
View 4 Replies
View Related
Feb 4, 2010
column I row 11 has a functional argument that simply states to display the output
as .843 I need to edit it to .844 and I cannot seem to find out where or howto edit it.
There are others like this that I need to do too so I need to learn how to do it. Not just have someone do it for me.
ALSO as you can see this sheet displays #N/A all over the filled in cells... I would like them to be blank until I enter some pertinent info... I tried this is cell m7 BUT as you can see in m12 it goes back to the N/A
View 4 Replies
View Related
Feb 2, 2010
On Sheet1, Row 2 I have my columns named January-December, which correspond to the names of the other 12 sheets in my workbook. I want to test and sum the same range of cells in each sheet by simply coping and pasting the formula. I am using INDIRECT and SUMPRODUCT, but is there a better way? It seems to have caused the sheet to run slowly. Perhaps it's just the amount of data. Here is an example of the formulas I am using:
=SUMPRODUCT((INDIRECT("'"&B2&"'!$B$3:$B$200")=$A$2)*(INDIRECT("'"&B2&"'!$C$3:$C$200")="Yes")*(INDIRE CT("'"&B2&"'!$E$3:$E$200")))
This gives me the intended result. B2 in this case is January. C2 is February and so forth.
View 3 Replies
View Related
Sep 20, 2006
I have a column of words in Column A and I want to replace all the times that these words appear in the rest of the excel sheet with the words in Column B. If someone has already answered a similar problem link me to the thread because I can't find anything.
View 5 Replies
View Related
Jun 3, 2014
I'm looking for a macro to remove all words (in a single word per cell format) in a range (approx 100 columns & 7000 rows), except for a list of 100 words.
I'd prefer to email the file if that's okay.
View 7 Replies
View Related
Jul 16, 2009
I've been using conventional method to do this and it's time consuming. I would like to total up 2 column. A multiply B to be exact. Below are some examples:
Table 1 - Before totaling up:
Quantity
Product
5
2 x Button A White
3
4 x Button B Pink
4
5 x Ribbon A Black
2
3 x Thread A White
6
2 x Cloth A Blue
Table 2 - After totaling up:
Quantity
Product
10
Button A White
12
Button B Pink
20
Ribbon A Black
6
Thread A White
12
Cloth A Blue
I need to have the sum of the "Quantity" multiply "Product". Or in short A x B.
And the end result need to have the number and "x" sign removed while keeping on the the products names. (2 x ) Take note it's "number" space "symbol" space.
View 9 Replies
View Related
Jun 23, 2006
I am trying to find certain words in a column and delete the word and characters following. For example, Say I have a column of info as seen below. This is a test of me. I am just experimenting with this stuff. Deleted (6/15/01) Let me know what you think. I am not sure about it all, but I guess I will figure it out. riviledge1 (01/05/06) Now let's see what happens when I try to test it.
I want to find all the "Priviledge1 (01/05/06)" and replace with nothing. Please note, the date will change with each record, so I need to figure out how to tell Excel to find "Priviledge1", delete it and the date behind it. So I want to delete "Priviledge1" and the next 11 characters including the space.
View 3 Replies
View Related
Feb 4, 2013
On to the topic, I have all the US and Canadian states abbreviated (CO = Colorado, etc.) and was wondering if there is a way to make all of them convert to their respective names in one fell swoop instead of writing it in for each one, one at a time. Something along the lines where I can make, CO = Colorado, TX = Texas and then hit enter and all of the abbreviations would convert. Some kind of command.
View 2 Replies
View Related
Jan 22, 2010
I want to sort on number of words, i.e. if a cell contains 1 or 2 words etc, with the cells containing 1 word coming first then cells containing 2 words. Also, if possible, first the cells with fewer characters.
View 9 Replies
View Related
Nov 9, 2006
I have tried Sumproduct and Countif and can not get a proper count of rows that contain specific words in multiple columns. I have attached an example spreadsheet where I am looking for a result of 7 rows that contain 1 to 4 specific words within phrases. The example looks for the words: "virus", "spyware", "malware" & "adaware", and ignores any other words like "aware" or "ware".
View 7 Replies
View Related
Feb 15, 2007
I have 4-5 separate lists of words/letters and I would like to combine them in a certain order but creating all possible combinations resulting a new word. It's like a conjugation tool for verbs. For example if List 1 = be/el/ki/meg; List 2= m List3=e/é; List4= gy/" "; List 5=" "/ek/sz/nnek So the output has to be (if the order is List1+List2+List3+List4+List5)= bemegy/bemegyek/bemegysz/bemesz/bemész/elmegy/elmennek/ ..... and all possible combinations.
Preferentially I would like to automate it in a way that it straight outputs into MS Access. Also can it be automated that it reads the list from a file (database)?
(Also can it recognize the word by letters? Because the basic word that I would load the program= List2+List3+List4)
View 2 Replies
View Related
May 16, 2006
I have several files of data that are from a data logger. The data is broken up by day. Each day has roughly 43000 rows of data, at its sample rate. This has made charting the data a nuisance. Is there a way to resample the data so it fits in the 32000 points excel can chart? In the future I will set a sample rate that will keep the number of points below the 32K per series. I would like to be able to have the total number of points reduced by averaging the data not by simply deleting one of every four rows.
View 5 Replies
View Related
Jun 16, 2009
1. Are the Workbook Environment and the VBE environment simply two different forms? Meaning, when I press alt+F11, am I just switching between 2 default forms?
2. Is Excel itself written in VBA? And if it's written in VB or C, which would make more sense, is the GUI side of things written in VBA?
The reason I ask is pretty simple. I really love the way the Workbook environment and the VBE environment are set up. I want to use them as models for my own forms. Both environments seem little more than two very complex forms. And I want to replicate so much about them.
3. But is it possible to replicate anything I see as part of these environments in my own forms?
For instance, what is the VBE Project window? Is it a ListBox? I need to code a form that does something very similar to the way it groups and collapses Projects and their sub-groups like Microsoft Objects, Sheets, ThisWorkbook, etc. I've used grouping to make rows and columns collapsible. But never items in a ListBox... But am I right to assume that I can do so, just because Excel's environment does it? Meaning, can it be assumed that anything I see Excel doing itself, a talented programmer can replicate in forms of his own?
View 3 Replies
View Related
Jan 29, 2008
I'm attempting to import around 200 (and growing!) separate text files into Excel. I am using the formula below to import the text file and then using a separate macro to select the information I need, copy it into another spreadsheet, and then run the import macro again.
However, I have a problem in that my import macro gives me 'Run-time error '1004:
Application defined or user defined error''. At first this wasn't a problem as the information is pasted into the spreadsheet despite the error anyway. However, now that I am looping the macro it is obviously causing more problems as it prevents the loop. I would really appreciate it if anyone knows of a work-around or can spot an error in the coding to resolve this!
The code below shows is for the import macro only:
Sub ImportTextFile(FName As String, Sep As String)
Dim RowNdx As Long
Dim ColNdx As Integer
Dim TempVal As Variant
Dim WholeLine As String
Dim Pos As Integer
Dim NextPos As Integer
Dim SaveColNdx As Integer
View 8 Replies
View Related
Apr 1, 2008
I have a simple macro importing a .csv data file to a worksheet every 30 minutes.
When the macro runs an Import Text File dialog box displays.
What do I need to do to have the macro run to completion without the dialog box interruption?
Sub RefreshHourlyData()
htime = Now + TimeValue("00:30:00")
Application .OnTime htime, "RefreshHourlyData"
Sheets("H1Updates").Select
Sheets("H1Updates").UsedRange.Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Range("A1:A1").Select
End Sub
View 3 Replies
View Related
Mar 5, 2008
Is there a code available that can be used to get the user's computer ID number (Not Computer Name)? I'm using a password generator to randomly generate a password and I would like to use this unique password with the user's Computer ID.
View 9 Replies
View Related
Mar 10, 2006
I have a problem running an excel macro on different laptops because the IP needs to be known (my program links to databases that are installed on a "server" laptop). The IP can be sourced by using the "Start, Run, cmd, ipconfig" but my users can have problems with process.
Does anyone know of a vb function that will display the ip of the computer that the code is run on?
View 9 Replies
View Related
Jun 28, 2007
a macro to get the computer ID of the computer where the excel file is opened?
View 9 Replies
View Related
