Copy the following function in a VBA module. The function will then be available in your sheets. It converts the current day/time into the format you're looking for (no parameters are passed to the function)
"You could probably record a macro to change the format of the cells in the column where the formula is, or create a macro that copies all of the contents of the data sheet to another sheet with only the values. Why do have an issue with the formulae…"
Hi,I am using the ExtendFormulaeToUsedRows formula and want to replace the Formulae with Values. I have selected "YES" on the add in setup. However when I run out the report, all the formulae is still there. It looks as if only the 1st column of my add in replaced the formulae with values. All other subsequent columns still have the formulae in.How do I get it to replace all the formulae with values, for the whole formula range of my add in?See More
What could be happening is windows virtualisation. With windows vista onwards, windows included a security policy that moves non trusted files to a folder called virtual store folder during installation. These files become active only…"
Hi,We are running Sage 300 v2017 with Sage Intelligence. On a normal workstation it works fine, but on the Terminal Server, we intermittently get a message:"Please wait while Windows configures the Sage 300 Intelligence Reporting 2017 Workstation" with a green bar that runs.The only way to resolve this is to rerun the Sage300 workstation. Then the message will go away for a few days, only to appear again.Any assistance in resolving this permanently will be greatly appreciated.…See More