Forum Discussion
Solved
VAT calculation
Hi, I want to calculate VAT (generally 20%) from a gross amount. I want to be able to format it to 2 dec places so that if the pence is .100 to .104 the pence stays as .10 but if the pence is .105 t...
Your method works, but you can simplify it by using:
```sql
CCur(Round([Gross Amount] * [VAT Percentage] / (100 + [VAT Percentage]), 2))
```
This VAT Calculator method keeps it as currency and exports correctly to Excel.
Hi George, thanks for your help again, it is certainly appreciated.
I could just not believe that someone had not posted a solution before to this problem as surely a lot of businesses would be required to use the same calculation.
Storming I strongly suspect that most of the time, people who have confronted this problem have just worked out a solution as you were able to do.
Hi George, just wondering if you could help me with another problem.
I am trying to open a Word document containing the user manual at different bookmarks depending on which form the user is on.
I have the following code:-
Private Sub Command35_Click()
Dim strPath As String
strPath = "C:\Users\norma\Desktop\Phili CCC business management system user manual.docx"
Dim objWord As Object
Dim docWord As Object
Set objWord = CreateObject("Word.Application")
objWord.Visible = True
Set docWord = objWord.Documents.Open(FileName:=strPath, ReadOnly:=True)
docWord.Bookmarks("MainMenu").Select
objWord.Activate
WindowState = wdWindowStateMaximised
End SubThe Word document opens fine but I can not get it to be maximised.
The other problem is that the Word document opens at the bookmark but the bookmark is at the bottom of the maximised screen showing half of the previous page above it. See attachment.
Any idea how to resolve that please so that the bookmark starts at the top of the page?
Storming Unfortunately, automating Word is not in my skill set. I suggest you re-post this question in the Word forum where Word experts can see it. Sorry.
