Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PhilBreau

    slide control

    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...
  2. PhilBreau

    Excel import data from web

    I'm using Excel
  3. PhilBreau

    Excel import data from web

    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...
  4. PhilBreau

    Find and repeat row data text from Excel

    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...
  5. PhilBreau

    Find and repeat row data text from Excel

    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...
  6. PhilBreau

    Find and repeat row data text from Excel

    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...
  7. PhilBreau

    Find and replace text in a file from Excel

    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
  8. PhilBreau

    Find and replace text in a file from Excel

    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
  9. PhilBreau

    Find and replace text in a file from Excel

    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...
  10. PhilBreau

    Find and replace text in a file from Excel

    ...Calibri;}{\f1\froman\fprq2\fcharset0 Times New Roman;}} {\colortbl ;\red31\green73\blue125;\red0\green0\blue255;} {\*\generator Msftedit 5.41.21.2510;}\viewkind4\uc1\pard\cf1\f0\fs22 Hi all,\par \par The part is being shipped to FIRSTNAME LASTNAME as requested. UPS tracking number...
  11. PhilBreau

    Find and replace text in HTM

    ...Calibri;}{\f1\froman\fprq2\fcharset0 Times New Roman;}} {\colortbl ;\red31\green73\blue125;\red0\green0\blue255;} {\*\generator Msftedit 5.41.21.2510;}\viewkind4\uc1\pard\cf1\f0\fs22 Hi all,\par \par The part is being shipped to FIRSTNAME LASTNAME as requested. UPS tracking number...
  12. PhilBreau

    Excel jumping to specific cells

    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...
  13. PhilBreau

    Mail merge - using same label sheet

    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.
  14. PhilBreau

    Mail merge - using same label sheet

    Thank you, I will try your idea.
  15. PhilBreau

    Mail merge - using same label sheet

    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...
  16. PhilBreau

    Mail merge - using same label sheet

    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...
  17. PhilBreau

    Excel Hyperlink to Visio Shape

    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...
  18. PhilBreau

    Excel hyperlink opens picture in Internet Explorer

    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...
  19. PhilBreau

    Calls not going to voicemail

    Thank you. This works
  20. PhilBreau

    Calls not going to voicemail

    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...

Part and Inventory Search

Back
Top