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 Chriss Miller 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: MrStohler
  • Content: Threads
  • Order by date
  1. MrStohler

    Beginner Q: How to separate data from Excel into related tables and maintain relationship?

    I would appreciate it if someone here could provide input regarding my steps to separate imported Excel data into 3 related tables and advice on how to implement it. Here's more detail - the Excel data is in 2 separate worksheets. Each sheet has a line of data for each day there is a record. I...
  2. MrStohler

    How to vary format of single cell by data type?

    I have a table that summarizes & compares data from several years by week (each year is given 52 weeks for this ongoing effort). Each yearly table has over 100 items that are tabulated by week. All of the data is numerical but some of it is in decimal form and some is in time form - [h]:mm:ss...
  3. MrStohler

    Copy file with quote symbol (") in name

    I'd like to know if there is any way to copy a file that has the quote symbol: " in it's file name. EXAMPLE: 02 "Progress is our mission…".mp3 My wife gave me a MP3 CD book but portable CD player does not support MP3 format... No problem I thought. I'll just transfer the file to my MP3...
  4. MrStohler

    Clean Install of XP Hangs at welcome screen. ?

    I'm attempting to install XP SP2 on an older laptop (it is slightly better than the min sys rqmts for XP: Dell P3 500MHz, 128Mb ram). I understand W98SE would perform better but this will be use for internet 98% of the time and I need to really restrict what other users could do. After the...
  5. MrStohler

    Prompt user to find file & return path as text????

    I looking for a macro that I can insert into an Excel file to lookup a file path and return the path as text. Ideally, when the user activates the macro with a button click it would prompt the user, with a dialog box (similar to the "Open" file or "Save as" dialog boxes) to lookup the file...
  6. MrStohler

    Excel retrieve data from LARGE text file

    I am attempting to write a macro that would retrieve data from text file that could be large (500+ pages of text). The text file is the output of an engineering software package. Currently we manually gather the data to perform calculations that the software package does not handle. What I...
  7. MrStohler

    Excel: Convert 1 column of data to several

    Problem: I have several Excel files, each has one column of data (approx 1500 rows) with evenly spaced blank lines after each data entry (either 2 or 3 depending on who generated the data, but it is consistent within each file). Goal: Organize the data into columns, alternating data rows with...
  8. MrStohler

    Start Thunderbird w/ calendar open?

    Is anyone aware of how Theunderbird could be started with the calendar (Mozilla Calendar) extension automatically opened OR how to open the calandar without Thunderbird Thanks
  9. MrStohler

    Best Email Client for multiple accounts??

    I just re-formatted my old P3-500MHz, re-installed W98SE and have not installed an email client yet. Does anyone have a recommendation for an email client that would serve multiple accounts? A calendar would be nice but it is not a requirement. I would also like to be able to reply to email...
  10. MrStohler

    Outlook 2K attachments save as read only- How to change?

    I am using Outlook 2000 as an email client at home and work (I just changed from OE 6.0 at home to Outlook for calendar purposes). When I save attachemnts, Outlook always seems to save the attachments as read-only. How do I change this? It is irksome to go to Windows Explorer and change...
  11. MrStohler

    LAN slooooow internet connection- What do I check?

    Web pages load very slowly over my LAN at home (cable modem feeds a Microsoft MN-500 Base Station hard wired to desktop and wireless to Linksys notebook adapter in a laptop). While pages are loading the mouse movement is very jerky (both computers). I was having troubles with lock-ups and...
  12. MrStohler

    Excel: Vary Input Range for Drop Down Menu with radio buttons

    Is there a way to change the Input Range of a Combo box based on a radio button selection? If this goes well, the spreadsheet user will make a choice from several radio buttons. For each selection, I would like to reference a different data array. Is there a way to "hide" the Combo...
  13. MrStohler

    Equations show as empty box in Word 2000, why?

    When I edit an equation or insert an equation into a Word document (Word 2000) using Microsoft Equation 3.0 I am no longer able to see the equation after closing the Equation toolbar. All that is visible is a box that shows the boundaries of the equation object. But the equation does show in...

Part and Inventory Search

Back
Top