Insert picture or image in all comments in Excel Sometimes, you may want to insert same picture or images to all comments in active worksheet or in the whole workbook. Kutools for Excel’s Format Comment utility can help you get it done easily. The other two are third-party applications that need to be installed separately. Open the pertinent Excel file, right-click on the image that needs to be extracted, and choose either copy or cut. You can also click on the image once to select it and then press Ctrl-C for copy or Ctrl-X for cut.
Hi,
I want to read a PC's MAC address and copy it to a worksheet. I have a code that works (see attached). I work on WindowsXP with Excel2002.
The problem is that I had to put a MsgBox on line 19. If I remove the MsgBox command the sh.Exec on line 4 seems to be executed too slowly before opening MAC.txt on line 21. The code is executed but Sheet1 remains empty. That is why I put the MsgBox break.
Does anyone know an elegant way to get rid of this MsgBox? I do not want to bother a user every single time with the MsgBox.
I have tried pause commands or loops which check the existence of the MAC.txt file, but without success.
If someone knows a better way to identify the MAC address alone, i.e. without the 'Physical....', this would be even better
Help appreciated.
g
- MAC.zip (8.5 KB, 9 views)
No matter what you do on a computer, from writing an email to backing up data, you use certain common functions on the mouse and keyboard. Some of these are so basic you probably don't even think about it, like when you need to click the mouse or press the spacebar. One very common function on the iMac and other Apple computers is copying and pasting. It applies to pictures, files, folders, text and many other things you see on your screen. Because of its common usage, it's a straightforward process you can quickly implement whenever you need to.
Using the Keyboard
Step 1
Select the object or objects you wish to copy and paste. If this is a single item, like a file or a picture inside a document you're viewing, just click it to select it. For text, put the cursor over the first portion of the text, click and hold, then drag to the end of the text you want to copy. Alternatively, put the cursor at the beginning of the text, hold the 'Shift' key on your keyboard and then use your arrow keys to highlight the text you want.
Step 2
Press and hold the 'Command' key. Depending on your keyboard, this key may have the Apple logo on it rather than the word 'Command.'
Step 3
Press the 'C' key while still holding down the 'Command' key, then let go of both. This copies the text.
Step 4
Move your cursor to the location you wish to paste the object. Move it to another place in the same document, or move to a new program, such as Safari or TextEdit.
Step 5
Press the 'V' key while still holding the 'Command' key, then let go of both. This pastes the object.
Using the Mouse
Step 1
Select what you want to copy. Click a single object, like a file, or highlight text if you want to copy that. To highlight text, place the cursor at the beginning of the text, then click and hold while you drag the cursor to the end of the text you need. Alternatively, hold the 'Shift' key down and navigate with the arrow keys to highlight text.
Step 2
Bring up the editing options for the highlighted object. One way to do this is to click the 'Edit' menu in the menu bar at the top of your screen. Another option is to press and hold the 'Control' key and click the object, which brings up options for that object at the same location as your mouse cursor.
Step 3
Step 4
Navigate to the place you wish to paste the object. This can be within the same document or even in a different program.
Step 5
Move your mouse cursor to the location you wish to paste the object, and again bring up the options available by clicking the 'Edit' menu or by using the 'Control' key and clicking your mouse.
Video of the Day
Brought to you by Techwalla
- David Paul Morris/Getty Images News/Getty Images