Search results for query: *

I appreciate all the suggestions and now that I know there is a way to push a report to LiveLink, I fill comfortable to approach our LiveLink Admin with these suggestions and I will post our solution. It is good to know there is a group of professionals out there willing to help, Thanks. John

Thanks Greg. I am new to LiveLink is there any documentation in LiveLink on how to use this PULL function? Thanks, John

Is there anyway to automatically upload a file into LiveLink? I create a Excel workbook everyday and want to upload the file into LiveLink, I used the GLOBAL Icon to point to a file which works great as long as you have access rights to the server where the file is located but if you do not you...

Thank you Little Smudge!! With SHARED selected this work great. JJO

Scott; Thank you! Thank You! Thank You! Did I say Thank You? This is exactly what I needed. Also I am adding some information on the "Camera Button" for those like myself that do not have this button. John Excel's Camera tool (i.e., a toolbar button with an image of a camera) is...

I do not know what the camera button is. Could you explain it or tell me where I can find some information on it?

I have this worksheet (WS) that has many queries and formulas and it automatically starts everyday at 6AM. I need to email the users a copy of this WS but not all the queries, only the results of the query. I thought if there was a way to copy (not manually copy and paste) the original WS and a...

Yes. On each update I automatically run the query and update the area. The query can return 2-9 rows. John

By opens I mean start Excel and open the same spreadsheet the next day. I use the same spreadsheet everyday. After a couple of days the #REF! shows up. This area that I am referencing is the area where MS Query returns its results.

I am using MS Query to get external data and return it to cells A94 through B100(column A is the return name column B is the return value) My formula in cell A1 starts off like this: = IF(A94="Rutkowski",B94, IF(A95="Rutkowski",B95, IF(A96="Rutkowski",B96...

When I set up a link in MS Access to connect to a Oracle DB table I am not able to see the table I need but I can see all the system tables. What do I need to change to prevent the system tables showing?

How can I set a prompt tp automaticaly display the last week day Monday, Tuesday, Wednesday, Thursday, Friday? Not Saturday or Sunday. I need to create reports and the date selection must be yesterday. If today is Monday yesterday was Saturday or Sunday I need it to be Friday.