Recent content by samato

Here is the scenario. MC Office Professional Plus 2013 Shared xlsx file on network drive Some cells have data connections to get data from other files These "Other Files" are on the Sharepoint server and the "Formula" in the Shared file cell looks like this...

Thank you both, it worked great Tony. I hadn't realized I had to escape the < and> symbols. Once I did that, worked great. Thanks again!

Sorry if this has been answered, I have looked through the threads and didn't rally find what I needed. I need to structure a find and replace statement that will find the following... <UnscrambledDriverLicenseNumber>DS156DS676564</UnscrambledDriverLicenseNumber> and replace it with...

Not sure why that matters but it points to a word document on Sharepoint

The hyperlink was added by someone by right clicking on the cell and selecting "Hyperlink..." So Sheet1 has a single column A and it contains Project ID's; let's say 14-PRO-154 is in Cell A2. I want to look up this value in Sheet2 ColumnA and have it return the value in Column B (which is the...

I have an Excel Worksheet in which Cell B2 the target. I wish to lookup the value that is in A2, in a table in a separate worksheet (List), have it return the value in the cell 2 columns over AND I want the Hyperlink that is in that cell to be a Hyperlink in the cell returned to. Did I explain...

I am pasteing the clipboard image, which is a simple "print screen", into an OLE field in an Access form. The field is significantly smaller than the actual image size. I really only need and want to see the top RIGHT of the image. Is there a way to change the justification of the image to...

I have two worksheets within the workbook. The first sheet is receiving data from an Access macro and the lines are apparently being inserted. The second sheet refers to the cells in the first sheet which I want to remain static but as rows are added to sheet one the formulas are being...

Correct, rows are being added, not just appended. I have tried using absolute row references.

I am trying to creat an Excel document that DOES NOT increment the cells referenced in a formula each time a row or coumn is added on the other sheet that the formula references. Ideas?

My daughter has not been checking her e-mail account and it now has 1484 emails on the POP3 server. I would like to telnet into the account and delete them all, but not one by one. I have tried a script I found but I can not seem to get it to work propoerly as I believe it was written for...

Thank you very much, it worked great!

I have a simple table in Word and one formula calculate the total from another table and the next formula calculates the difference between the total of one from another. The problem is I CAN NOT get people to understand they have to press F9 to update the fields. I want a macro that updates...

I have a simple table in Word and one formula calculate the total from another table and the next formula calculates the difference between the total of one from another. The problem is I can not get people to understand they have to press F9 to update the fields. Is there an easier way, can a...

I am working on the EXACT same issue right now. I have figured out how to handle this issue if done in Publisher. So, my suggestion would be to rework the documentin Publisher and apply the following fix in the registry. I did it and it worked. I am still searching for a Word fix...