Search results for query: *

I wrote a script to control my receiver. I don't I can turn up the volume by creating a dialogue with a button. I have to keep clicking the button to change the volume. Is there a way I can create a slide control? proc main integer Event dialogbox 0 193 54 210 164 2 "Onkyo Control...

I'm using Excel

I'm trying to extract data from Google Finance. Web page I'm using as source: https://www.google.ca/finance?q=TSE:RCI.B When I inspect the element on two occasions, the information is different. How do I capture 56.61? case 1: <span id="ref_674743_l">56.61</span> case 2...

Thank you for reply, SkipVought I think I understand the loop, but how do I repeat the block of tags? Somehow I need Excel to write the HTML tags and repeat for each row. This is one row of the output: <tr> <td>70000001</td> <td>ABCDEFG</td> <td>ROUTER</td> </tr> The desired result is...

There are other variables in the source template I'm not mentioning although the code shows it. I'm focusing on the table components. This is a macroI use for a mail merge document which captures the start and end rows for shipping labels I print. If I can somehow blend the codes and repeat...

Hi all, I posted something similar in the past. Thank you Andrzejek (Andy) for your help. This is a little different. I have a signature file I constantly modify. If my cursor is anywhere on a specific row, I want to find and replace text to the template variables NAME, ASSETTAG...

strongm, Thanks for your reply. I do use mail merge. I wanted to create a signature file I can insert when replying to all. For what I need, I think Andy's solution works better for me than a mail merge. I couldn't quite figure out a mail merge for that. Phil Breau

Hi Andy, This is perfect. Thank you so much. Here's a little something for the tip jar. $$$$$$$$$$ BTW, I have a work station Phil Breau

Hi Andy, This works great. I tried it and I only get the first and last name, but not the tracking number. I changed the order and I can get the tracking number, but not the first or last name. I think it's because of the else logic. How do I find and replace all variables? Line...

Hi All, I posted this in the excel forum, but was advised to post here I have a signature file I use in outlook as a template. I want to search for several words and replace them with cells of specific columns on the current row of the cursor, while I have the excel spreadsheet open. I use...

I have a signature file I use in outlook as a template. I want to search for several words and replace them with cells of specific columns from on the current row of the cursor. I use generic words in the template as variables. I want to search and replace these variables and create a new...

Hi all, I have a bar code reader and need to scan serial numbers and other information from shipments. What I want to do is scan a number of bar codes from a box and then navigate to the next record. Right now, when the barcode reader scans a code, the information is typed followed by a...

I figured it out. Thanks Macropod for the blank entries idea. That did the trick. I also deleted the text that repeats on each label in the word document and put it into excel repeatedly. I used this as one of the merge fields. Works like a charm.

Thank you, I will try your idea.

Thanks for the replies. I get the idea of creating blank entries in the source. The problem is the word document has text in all cells of the label template with the merge fields. So if I've used the first five labels, I want to start printing on the last label of the second row - ie the 6th...

Hi all, I have a label sheet That only gets partially used. The layout of the sheet is 3 labels wide by 7 tall. I merge from an Excel spreadsheet to Word. Is there a way of printing on a specific label or range of labels. For example, i`m using a label sheet with the first 7 labels used. I can...

I am trying to hyperlink from Excel to open a Visio drawing with subaddress. The problem is the forward slash of the subaddress keeps changing to a backslash. This is what I want: \\fileserver1\citpublic\Enterprise Infrastructure Services\HO\Voice network\CS1000 Voice...

I have a hyperlink to a .jpg. The hyperlink opens the picture in Internet Explorer. I Googled and tried all the solutions. Hyperlink still opens in Internet explorer. I want the hyperlink to open the picture in Windows default - Windows Photo Viewer. Using Windows 7 Professional, Microsoft...

Thank you. This works

Hi all, New to Nortel. I tried looking through other posts, but couldn't find my fix. I'm trying to set extension 5883 to go to voicemail after 4 rings. I would also like to get documentation on what all the abbreviations mean. Any good websites? Thank you TN 104 0 02 18 VIRTUAL TYPE...