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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Link Visio object to specifc place in Word document
I am writing a process description in Word and drafting an associated process chart in Visio. I would like to link from the Visio shapes representing activities to the related activity description in the Word document. In Visio I can set up a link to the Word dokument and there is a "sub...- rookiesql
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
EXCEL cell reference problem
Hi! I have a big excel sheet with a lot of data that use to present various statistics. Each record is a row and the are sorted after creation date which is one of several columns. Now I wanted to do the following: search one of the columns for specific contents (for example date (not creation...- rookiesql
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Getting result in local time from UTC
Hi! I am retreiving data from a MS SQL 2000 DB to my EXCEL spreadsheet and this goes well using a SQL query from inside EXCEL. However, I have discovered that the returned data for timestamps is in UTC format while my time zone is CET. I scanned the web for info and found that there is an...- rookiesql
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Retrive time in local time not UTC
I am retreiving data from a MS SQL 2000 DB to my EXCEL spreadsheet and this goes well using a SQL query from inside EXCEL. However, I have discovered that the returned data for timestamps is in UTC format while my time zone is CET. I scanned the web for info and found that there is an expression... -
Changing what data is viewed in multiple EXCEL charts
My problem is the following: I have a big matix of data with the folowing structure: Jan Feb Mar ... data1 ... ... ... ... data2 ... ... ... ... data3 ... ... ... ... .... From this matrix I have generated a big number of charts with different data vs. the months, i.e...- rookiesql
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Linking/importing EXCEL charts into POWERPOINT
I have generated a lot of charts, which resides inside a MS EXCEL file. These charts are updated regularly and I need to present the results. Questions: 1. Can I import these charts into my PPT file in a more automatic fashion that what I use now, i.e. select the chart in EXCEL, Copy and paste...- rookiesql
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
SELECT statement in SELECT statement?
Hi! I am trying to extract data from a Problem DB in SQL. The Problems in the database pass through different states as they are treated. The states are named and there is an associated time stamp for each state. In my query I want to SELECT the Problem id and then the time stamp for 3 different...
