liamg67
05-25-2021, 02:56 AM
HI
I have written some reports for work using VBA. For some reason the report causes crashes on other versions of Excel -
Crashes on Excel 2016 and earlier version yet runs on my Office 365.
The second issue affecting my machine is that after scripts run sometimes it does not allow me to delete lines including VBA row.delete and in the worksheet after script has run. This also then affects the ability to do same in other workbooks if they are open.
The reports take a handful of reports some from Connection using tables and other from copy and paste from other Excel files that are saved to a directory daily.
I am not sure what is causing this error and have tried Google searches.
Has anyone any knowledge of this and if it a corruption or a coding issue.
Used to have a Sort error come up when I opened files which I have solved using sort.fields clear command.
When the sort error came up I was able to clear the error but had to resave file as a new name.
Possibly this is related.
Any advice welcome and appreciated.
I have written some reports for work using VBA. For some reason the report causes crashes on other versions of Excel -
Crashes on Excel 2016 and earlier version yet runs on my Office 365.
The second issue affecting my machine is that after scripts run sometimes it does not allow me to delete lines including VBA row.delete and in the worksheet after script has run. This also then affects the ability to do same in other workbooks if they are open.
The reports take a handful of reports some from Connection using tables and other from copy and paste from other Excel files that are saved to a directory daily.
I am not sure what is causing this error and have tried Google searches.
Has anyone any knowledge of this and if it a corruption or a coding issue.
Used to have a Sort error come up when I opened files which I have solved using sort.fields clear command.
When the sort error came up I was able to clear the error but had to resave file as a new name.
Possibly this is related.
Any advice welcome and appreciated.