Here is the code for a macro that deletes one picture and inserts a new one. I have many pictures to update but you will get the idea from the code.
Sub Macro2()
Worksheets("Sickness Absence").Activate
Range("N12").Select
ActiveSheet.ChartObjects("Chart 2").Activate...
Hi,
I am trying to write a macro that will take a set of excel charts and then copy them as pictures into another spreadsheet. The graphs will be updated every month and the most recent version should replace the old version. The problem is that pictures seem to be numbered dynamically in...
Hi,
I am trying to write a macro that will take a set of excel charts and then copy them as pictures into another spreadsheet. The graphs will be updated every month and the most recent version should replace the old version. The problem is that pictures seem to be numbered dynamically in...
Hi,
Maybe somebody can help me. I have a simple application that is installed on a network drive that can be accessed by three users who have the full version of Access 97 installed. Two of these users have no problem accesing the database and it's objects. The third user cannot access any of...
Can anyone tell me why using Access 97 runtime I cannot use the shortcut menu when previewing a report? I have a requirement for the users of my application to selectively print from large reports.
Hello,
I have a combo box that contains a pick list of strings. When a value is 'picked' I want to copy the string to a text box. The user can make multiple selections from the combo box. I want these multiple selections stored in the text box for later processing. I hoped that something like...
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.