L
Leslie Isaacs
Hello All
I have an Access97 mdb in which I have a macro that includes an 'Output to'
command to export a query in excel format. It would be very useful if the
excel file could have the 'track changes' option automatically set to True.
In addition, I need to ensure that the excel file, when it is subsequently
edited by anyone, restricts the type of data that can be entered in certain
columns - e.g. column B can only have integers, column E can only be "ABC"
or "DEF" or "GHI", column G can only be True or False.
The file is in fact an 'Input Proforma' for users to send in monthly data.
Included on the proforma is some 'standing' data (which will be subject to
change by the user) plus some empty columns for that month's data.
I'm guessing that this can all be done with some VBA coding (?), but my VBA
skills are not up to it.
Hope someone can help.
Many thanks
Leslie Isaacs
I have an Access97 mdb in which I have a macro that includes an 'Output to'
command to export a query in excel format. It would be very useful if the
excel file could have the 'track changes' option automatically set to True.
In addition, I need to ensure that the excel file, when it is subsequently
edited by anyone, restricts the type of data that can be entered in certain
columns - e.g. column B can only have integers, column E can only be "ABC"
or "DEF" or "GHI", column G can only be True or False.
The file is in fact an 'Input Proforma' for users to send in monthly data.
Included on the proforma is some 'standing' data (which will be subject to
change by the user) plus some empty columns for that month's data.
I'm guessing that this can all be done with some VBA coding (?), but my VBA
skills are not up to it.
Hope someone can help.
Many thanks
Leslie Isaacs