Question about Computers & Internet

1 Answer

Excel Macro to find out non-keyboard ascii characters

I need a macro code to find out all the non-keyboard characters( symbols, greek letters,etc) not found in keyboard

Posted by on

  • ddavis4 May 13, 2009

    I have single quotes in a data file that my database cannot handle and needs to be removed before loading. There are also other characters as well that I need to detect - Kanji, etc.

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 101 Answers

Not a macro but if you need a particular code for a symbol. Try Start button and then run
type charmap
You will find all the symbols here and in the bottom right hand corner it shows the keystrokes for selected symbol.

Posted on Mar 20, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

2 Answers

I want to know about macros


you can find more information about macro and usage of macro from
Automate computer tasks easily with macro software

Oct 29, 2010 | Computers & Internet

2 Answers

How to type n with this symbol(~) on top of it...????


You can use ascii code which consists on using the alt key on your keyboard and a combination of numbers, for the ñ you need to use:

ALT+164

that works everywhere, word, chats, websites, email, etc. Here is a link where you can learn more about ascii codes:
http://www.asciitable.com/

I hope this helps you and don't forget to rate or leave a testimonial. Thanks for using Fixya!

Mar 13, 2010 | 01 Communique I'm InTouch 3.4 (28-027128)...

1 Answer

How to make degree sign in computer using numbers?


A better way to enter special symbols in Windows applications (such as Word), is to take advantage of the symbols in the fonts provided by Windows. For example, in Word, use the following steps:
  1. Click on "Insert" (in the menu at the top of the page)
  2. From the drop-down menu, select "Symbol". A chart of special symbols will appear
  3. From the chart, you can select a symbol to insert into your document by highlighting the symbol, and clicking on the word "Insert" at the bottom of the chart.
How do I generate extended ASCII characters from the keyboard?
A: DOS will allow you to enter extended ASCII characters into many programs. Here's how you do it:
  1. Make sure NumLock is enabled on your keyboard.
  2. Press and hold the ALT key.
  3. While holding down the ALT key, enter the 3-digit decimal code for the extended ASCII character you want to generate.
  4. Release the ALT key.

Feb 18, 2010 | Broderbund Learn MS Windows XP and Excel...

1 Answer

How to shoot macro and close up images


To activate macro mode on s5000 you need to press the 4-way controller on the back of the camera to the left (it's labelled with a "flower" symbol).
Make sure you turn macro mode off once you've finished with it as it will cause autofocus to slow down with non-macro focusing.
Good luck,
Raf

Nov 13, 2009 | Fuji FinePix S5000 Digital Camera

1 Answer

Macros


After you record your macro do the following.
Open the excel file contains the macro. Go to tools and go to macro and click on macros. Select the macro you wish to add the close operation. Click on Step into... This will open up the visual basic editor. In the code window, at the bottom row you will see End Sub. Right before that row, type workbooks.close
Save the macro by clicking the save button. And you can run your macro to see if it works. I tried, it does :) Good Luck :)

Aug 18, 2008 | Microsoft Excel for PC

1 Answer

Macro


Hi motilal

Follow these steps to create multiple macros

Click the Microsoft Office Button , and then click Excel Options.
In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

Note The Ribbon is a component of the Microsoft Office Fluent user interface.
To set the security level temporarily to enable all macros, do the following: On the Developer tab, in the Code group, click Macro Security.


In the Macros Settings category, under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.

Note To help prevent potentially dangerous code from running, we recommend that you return to any of the settings that disable all macros after you finish working with macros.
Open the workbook that contains the module that you want to copy and the workbook that you want to copy the module to.
On the Developer tab, in the Code group, click Visual Basic.
On the View menu, click Project Explorer .
Drag the module that you want to copy to the destination workbook.

Regards,
TheAssembler

May 06, 2008 | Microsoft Excel for PC

1 Answer

Character Encoding After Sync.


HI, U DO'NOT USE THE GREEK CHARACTERS IN UR PC SUITE. REINSTALL THE PC SUITE WITH GREEK LANGUE VERSION.

Mar 02, 2008 | Nokia 6288 Cellular Phone

1 Answer

Macro on excel


Macros are a timesaving feature that allow you to record a sequence of actions that you do in excel, and replay them back later.

You give each macro a name, and you can invoke them later, and Excel will "do" whatever it is you did when you recorded the macro.

To record a new macro:
1) Open Excel
2) Go to Tools->Macros->Record New Macro...
3) Type in a name for your macro and hit OK

(A new toolbar will popup with a "stop" button on it. Excel is now recording everything you do)

4) Do something, like, for example, select some cells and make them bold.
5) Click the "stop" button.


Now your macro has been recorded! You can play it back later by:

1) Open Excel
2) Go to Tools->Macros->Macros...
3) Select your macro from the list
4) Click "Run"

The actions you performed earlier will now be executed.



-------


Macros are written in Visual Basic for Applications, or "VBA". It is a programming language which uses the Excel Object Model to perform various actions. You can edit and create custom macros by writing the code manually in VBA. To do this:

1) Open Excel
2) Go to tools->macros->macros...
3) Select an already existing macro
4) Click "Edit"

(The visual basic editor will open, showing you the code for your macro)

At this point you are writing a program in Visual Basic. To learn how to edit macros, you need to learn visual basic, as well as the specific quirks related to excel macros in visual basic.

Recording a macro, and then using it as a template while you edit it is a common trick for making macros manually more quickly.

If you are not familiar with VB, I would not suggest attempting to edit your macros in any but the most simplest of ways. If you're brave, you can try to learn about editing macros in VBA here:

http://www.anthony-vba.kefra.com/

Jan 28, 2008 | Computers & Internet

1 Answer

Macro to be used in Excel


Instead of me teaching u. i would suggest u learn it by following the simple steps.

1. Click Tools > Macros > record
2. do some common operation like copying data, creating graphs, etc.
3. press alt+F11 to go to vb editor, to see ur macro recorded
4. study it ... u will learn easily

or

try the book 'Microsoft Excel Visual Basic Macros Examples' at http://www.add-ins.com/vbexamplestopics.htm


bye

have a nice day

Jan 26, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

1,948 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

100340 Answers

David Payne
David Payne

Level 3 Expert

14160 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...