Replies

SOLVED.

I found the answer.

The syntax is VBA.Math.Round()

I do not understand why, but when I try running the macro containing the QuitAccess command, I get the error message as stated in my original post, however, if i put the line
“C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE” “U:CI.accdb” /X macRunETL
in a bat file and run the bat file, the macro executes and Access quits.

:confused:

I guess the end result is that I don’t have an automation issue.

Problem Solved.

I used Paragon Rescue Kit Free edition.

http://www.paragon-software.com/home/rk-express/

This tool told me that my Win 7 partition was now being assigned to the E drive.

Using the tool to change the drive back to C did the trick.

Thanks Sudo15 for pointing me in that direction.

I received the following after running this command: sfc /scannow /offbootdir=C: /offwindir=C:Windows

Windows Resource Protection could not perform the requested operation.

I have the Win 7 Ultimate install DVD. I am sure that I would have updated to SP1 some time after it came out.

I tried -REARM and received the following:

Error 0x800703E6 occurred in connecting to server mycomputername.

We are just starting to move some custom Access/Excel applications to SharePoint.

At the moment, our idea is to convert the Access tables to SharePoint lists, and let the users filter the lists however they want. A select group of people may still use Access to make changes to the SharePoint data via linking. We haven’t decided (yet) on how we will deal with actual Access reports, or if we’ll even keep them.

I picked up Office and SharePoint 2010 User’s Guide: Integrating SharePoint with Excel, Outlook, Access and Word from Amazon. It may give you some guidance.

Amazon also has a 2007 version if you are using SharePoint 2007.

I also used 1&1 for several years and was very happy with it as a basic host and email provider.

They have some very cheap packages and the web site builder is fine if you don’t want to do any fancy coding.

I had to switch when I started doing some ASP stuff on several domains that I host with one account. 1&1’s implementation of ASP made it possible for a visitor to one site end up on pages of another site.

The code in the Using Check Out and Check In section works with Excel 2007. Yay!

One tip if you are using a variable to hold the file name: For Check Out I had to use the full path to the SharePoint file; For Check In only use the file name as shown in the title bar when the file is open.

This is probably explained in the Note at the end of the section, but I didn’t catch it.

Thanks for the link.

I’ll have to try it when I go in on Monday.

Here is the a modified version of the file. {The original file contained some sensitive information.}

As I was preparing this file on my home computer, I tested the macro (which runs on the sheet’s activate event) on both Excel 2003 and Excel 2007 and it worked like I expected.

My conclusion is that there is some Excel setting on my work computer that is different than my home computer.

Thanks,

I received the same error number when one of my macros tried to paste into a locked cell on a protected sheet.

Firefox supports elements. However, is it possible that you might be blocking it with an add-on? To get an unobstructed view, try starting the browser in Firefox’s Safe Mode. More info: Safe Mode. If that doesn’t work, can you post a link to the problem page?

You are so smart.

I ran Firefox in Safe Mode and everything worked.

Thanks very much.

Your code did the trick.

Thanks.

I found some code samples, but they were not in VB so I’m not sure which library to add. Just using Object makes it it difficult to discover the relevant properties and methods.

This code displays the count of the top level of the ZIP file. However, it does not traverse all of the folders in the archive, so that may understate the contents. (Or, since it displays the count for either a folder or a file, it might overstate the count. More work obviously is needed on this…)

Code:

Sub EnumerateZip()
Dim sh As Object, fld As Object
Set sh = CreateObject("Shell.Application")
Set fld = sh.namespace("c:testingOpen_in_Fx.zip")
MsgBox "Items: " & fld.items.Count
'Stop 'View Locals window
Set fld = Nothing
Set sh = Nothing
End Sub

Oh, I think I found something that might help up on MSDN: Folder Object.

Hopefully you can find some pre-baked code that handles this easily.

The basic answer no.

Formatting only changes the way a number is displayed, not the stored number.

If you wanted to change the presentation to whole dollars rather than 50 cents, you could format the cell to show zero decimal places. This would cause 847.63 to be displayed as 848.

Problem Solved.

Apparently the AVG 7.5 firewall was the culprit.

I temporarily turned off the firewall and the workstation joined the domain within 5 seconds.

After re-booting, the domain and AVG were working fine.