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
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...
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 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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.