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 bkrike 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: *

  • Users: AliJay
  • Content: Threads
  • Order by date
  1. AliJay

    Identifying a random Excel cell.

    Hi Guys, I wonder if someone could help me with what should be a VERY simple solution but is beyond me! My problem is similar to some other questions posted here but none quite match. Using Excel I want to be able to select a random cell using the mouse. I then want to run a macro which...
  2. AliJay

    Adjusting System Volume using an Excel Macro

    Hi all, Is there a way using a macro in Excel that I can change my computer's audio volume output? I suppose I am looking for a system volume property that I can change. Any help would be very much appreciated. PS I use XP and Excel 2003 Cheers AJ
  3. AliJay

    Turning Computer off at a set time?

    Hi, I run Windows XP. Is there a way of timing the computer to shut down at a certain time (say 9PM) when I am away from the computer. I use my computer to monitor data and want the computer to automatically turn off when it is done. I am thinking it could be a scheduled event but cannot see...
  4. AliJay

    Error notice when hyperlink selected in Excel

    Hi Guys, I have just "upgraded" from MS Office XP Ver. 2002 to MS Office 2003 on a machine that uses XP. In one Excel spreadsheet there is a hyperlink to a .wav file on my hard drive. In the 2003 version when the hyperlink is activated a Microsoft Excel "warning" pops up saying "Hyperlinks can...
  5. AliJay

    CPU/RAM usage question

    Hi Guys, I use my IBM ThinkPad (1.8GHz Intel Pentium 4, 1.0GB RAM running MS XP SP2) to monitor constantly changing parameters using Excel, which runs a macro every 2 minutes to update. The monitoring lasts for several hours per day. My question is that when I start running the machine (1st...
  6. AliJay

    Audible Alert in Excel macro (other than "Beep")

    Hi guys, Is there a way that an audible alert in Excel can be anything other than the "beep" function in a macro? Is there a way of opening another audio file or maybe assigning a "Beep2" to another audio file and using that as well. I have two other events to which I have asigned the "Beep"...
  7. AliJay

    Exporting Web based ".gif" image to Excel

    Hi, I have searched the archives and can find nothing on exporting a ".gif" image to Excel using a web query. I am doing some research and want to check (using Excel)every hour some solar data from the page http://www.n3kl.org/sun/noaa.html At the top of that page there are two ".gif" images...
  8. AliJay

    Macro to Export HTML to Excel

    Hi Guys, I am a VERY amateur programmer in need of some help. I need to write a macro that enters HTML code into a cell in a worksheet in Excel. The HTML code never changes so the macro just needs to write the HTML to the Excel cell which will produce the table required. If I simply copy and...
  9. AliJay

    Coverting a string to an integer

    Hi all, First post so please bear with me. I’m using Excel and writing a macro. A value is generated as a a string which has a value “id12456” and I want to convert it to an integer which is equal to 12456. How do I get rid of the “id” bit in front of the numbers? I know it’ll be simple but...

Part and Inventory Search

Back
Top