Search results for query: *

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...

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...

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 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...

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 have several rules set up to "MOVE TO" specific subfolders in my Inbox. Instead of simply moving them, it is sending a copy to the specified folder. Any ideas are appreciated.

I have a table of records and want to display the number of records in the table in the same form that enters data into the tbale. I would like this number to increase, obviously, every time I key a new record. Your help is appreciated

I am using the OutputTo in a macro and the file already exists so after the OutputTo I am trying to send "Y" to tell it to overwrite the old file and it doesn't work. Any ideas?

I have created a dB, stored on our corporate server. The other supervisors need to opne the dB also. If I open it first, they can't. If they open it first, I can open it, but not exclusively. This is acceptable, we just all want to have it opened at the same time. Ideas are appreciated.

Excel 2000 - If I grab a group of sheets, can I protect them all without having to protect each one?

Using the code below, at the line that shows &quot;Copy&quot; I want to copy the 16 digit account# at row 3 character 19 through 34 and then paste them later in the macro at the line that shows &quot;Paste&quot;. Any help is appreciated. ' This section of code contains the recorded events...

I want to export a text file via FTP from Access 2000. Any ideas? I see this is possible with Access XP but how about Access 2000? Sam

I want to export a text file via FTP from Access 97. Any ideas? I see this is possible with Access XP but how about Access 97? Sam

I use many many macros and periodically I need to increase the HostSettleTime. This is difficult to do with over 60 macros. Can I incoprporate the host settle time into a header file and have each macro access the header file so I can change this time in one file only and have it affect every...

I need to scrape a host report to an external format. I go for about any format in fact. I used the following to send the screen scrape to a printer, any idea how I can append it to a file instead of sending it to a printer? The code I use to print is - Dim rc% Dim MaxColumn% Dim row% Dim...