jryckman
Senior Member
Registered: 24-January-2007
Posts: 172
|
|
has anyone used the new excel reporter on the tsi content site (the .xltm file. When we try to reference it to the database we get all kinds of vb errors with the macros. When we save the file as an .xlsm extension it locks up when it tries to open. Is there something we have to do with the file. We are on microsoft professional 2007 and cadduct version 2.38.186. Could it be a version issue between cadduct and professional 2007?
|
|
| 19-March-2010 17:16:44 |
|
jimbon
Estimator
 From: Hawthorne, NJ
Registered: 17-March-2006
Posts: 59
|
|
jryckman,
One issue in MS Office 2007 could be that you do not have your "Trust Center" settings set properly. Try this:
1) Open Excel from the start menu so it starts with a blank workbook
2) Click the Office Button at the top left, then click the EXCEL OPTIONS button on the lower right of the menu
3) In the list on the left of the Excel Options window, select the Trust Center
4) Click the TRUST CENTER SETTINGS button on the right
5) In the Trust Center, select Trusted Locations on the left
6) If you are working on a network, check the "Allow Trusted Locations on my network" checkbox at the bottom of the Trust Center window
7) Click the button ADD NEW LOCATION on the right
8) Click BROWSE and select the folder where you keep your TSI Est-Duct Reporter workbook. Click OK, which brings you back to the window where you clicked BROWSE, and select the checkbox "Subfolders of this location are also trusted" and click OK.
9) Repeat Step 8 for any location that contains or could contain one of these TSI EST-Duct Reporter workbooks.
10) Click OK at the bottom of the Trust Center window
11) Click OK at the bottom of your Excel Options window
12) Open MS Office Access and do the same for Access that you did for Excel.
If this doesn't quite work, try this additional change:
13 a) In the Trust Center window in MS Access, select the Macro Settings on the left (which should be the second option under Trusted Locations)
13 b) On the right of the Macro Settings form, select the "Enable all macros" radio button.
13 c) Click OK, and click OK again.
Let me know if that took care of your issue, or if you're still having more problems, or if you'd already done all this. Good Luck!
_______________________________________
Ver. 2.38.186 (U)(17) - AutoCAD MEP 2008 - Windows 7 x64
www.goodsearch.com
|
|
| 24-March-2010 15:33:06 |
|
astclair
CAD Administrator
From: Cincinnati, OH
Registered: 20-June-2007
Posts: 33
|
|
I have the same issue. I've had to go back to using our previous version.
_______________________________________
Andy
|
|
| 02-April-2010 12:51:16 |
|
jryckman
Senior Member
Registered: 24-January-2007
Posts: 172
|
|
I found out the new version works but you have to overwrite the .iex files in your report folder on the central database to make the template work.
|
|
| 05-April-2010 16:43:52 |
|
jryckman
Senior Member
Registered: 24-January-2007
Posts: 172
|
|
I was able to get it to work on one of our machines....but then tried it on a second system and am getting the same errors. I even copied the exact same EST folder to the other computer. Attached is a screenshot of the what comes up when I try to open the excel reporter.
|
|
| 06-April-2010 18:36:04 |
|
eknight
Senior Member
From: Portland, OR
Registered: 10-August-2009
Posts: 31
|
|
I am noticing that every time I open the reporter it gives me different values. This seems to cycle itself every 4 times the reporter is opened. And it does not matter if I export another estimate.txt file between opening files or not. This is consistant when using run base bid in both standard and beta modes. I am using the latest reporter from the 2010 full install.
_______________________________________
Sager NP9280 - Intel Core i7 Quad Extreme 3.33 Ghz - 6GB Ram - NVIDIA GeForce GTX 280M 1GB
ACAD MEP Suite 2010 & 2011
2.40.039 Lock 19
|
|
| 24-July-2010 19:11:46 |
|
eknight
Senior Member
From: Portland, OR
Registered: 10-August-2009
Posts: 31
|
|
Update: I have received updated files from TSI and it now works correctly.
_______________________________________
Sager NP9280 - Intel Core i7 Quad Extreme 3.33 Ghz - 6GB Ram - NVIDIA GeForce GTX 280M 1GB
ACAD MEP Suite 2010 & 2011
2.40.039 Lock 19
|
|
| 30-July-2010 01:36:07 |
|
Jump to
|
Powered by PunBB
© Copyright 2002-2007 Rickard Andersson
|
|
