fuzzygeek
Energy Ebbing
- Local time
- Today, 11:08
- Joined
- Mar 28, 2003
- Messages
- 989
Try to zoom to 75% There is a problem with this code. The first time this is run, it runs fine. Unless you close access and reopen it
the second time it runs, the zoom property says that it is error 9 -
subscript out of range. There must be a reset to the Windows property that I am unaware of.
wbXL is an Excel workbook being created from ACCESS
'strWindowsName = wbXL.Name
'varN = 75
'Windows(strWindowsName).Zoom = varN
the second time it runs, the zoom property says that it is error 9 -
subscript out of range. There must be a reset to the Windows property that I am unaware of.
wbXL is an Excel workbook being created from ACCESS
'strWindowsName = wbXL.Name
'varN = 75
'Windows(strWindowsName).Zoom = varN
