Excel 2010 Web-Dav Connection To SharePoint Errors?

Apr 20, 2012

I am in the process of assisting some users in switching from Win XP/Office 2003 -> Win 7/Office 2010 and have hit a roadblock. I have a user that has an excel macro that opens an ADO connection to a SharePoint and grabs a record of the excel files on the SharePoint. The macro works perfectly on XP/2003 and XP/2010 but fails on 7/2010.

They are using this connection line: Code: davDir.Open "", "URL=http://SharePoint/Directory/URL", _
adModeRead, adFailIfNotExists, adDelayFetchStream
Set davFiles = davDir.GetChildren() Once they have the record they iterate through each Excel file on the SharePoint to open and parse them.

On Windows 7/2010 I get these errors when it gets to the davDir.Open line:When they error trap it throws this error:Quote: Object or data matching the name, range, or selection criteria was not found within the scope of this operation. Without error trapping it throws this error:Quote: Run-time error '-2147217895 (80040e19):Automation error I can connect to the SharePoint fine via IE or File/Open in Excel 2010. I have tried every variation of the URL I can and I just keep getting the same error.

View 1 Replies


ADVERTISEMENT

BSOD When Exiting Ms Excel 2010

Nov 13, 2011

Windows 7 Home Premium 64 bit (original OS)The laptop is about 2 years now. I've tried re-installing office and it worked but then it blue screened again yesterday during an event we were having. I just also had a blue screen a while ago when restarting the system

View 7 Replies View Related

[CRASH] Excel 2010 64 Bit File Will Not Open

Mar 27, 2012

The last system change I made to Excel was to be able to open files as an Administrator. I managed to do that but I don't know how to reverse this. So why am I concerned? Ever since I did this I have not been able to open the specific file involved with the open-as-admin. After several attempts, I did get an error indicating that the file caused serious errors the last time is was opened.

View 2 Replies View Related

Excel 2010 - How To Add Dropdown Menus To Ribbon

Apr 27, 2012

How to add drop down menus to the ribbon which I can attach macros to as per Windows XP?

View 4 Replies View Related

Excel 2010 Not Opening From Windows Explorer?

Nov 29, 2011

i'm unable to open excel from windows explorer. I double click/right click and open any excel file from windows explorer and excel opens up but no documents show. I minimize and maximize and still no excel document. I open up excel and go to file and open the file from there then it opens. Also, when in windows explorer, when you select the excel document, the windows preview shows "this file cannot be previewed because of an error in the microsoft excel previewer".

View 1 Replies View Related

Excel 2010 Not Responding And Always Restarting After Printing Job

Dec 26, 2011

My Excel files restarting always, from time to time after my printing job. I don't know if my Printer(HP Deskjet F4280) not compatible with Windows 7 or to my Computer.

Description:
A problem caused this program to stop interacting with Windows.
Problem signature: Problem Event Name: AppHangB1
Application Name: EXCEL.EXE
Application Version: 14.0.4734.1000
Application Timestamp: 4b58fbb3
[URL] ...........

View 1 Replies View Related

Convert Excel File 1997 To 2010?

Jan 11, 2012

I cannot open my file from Excel 1997 even though I tried to used your suggested converter what is the appropriate thing to use for me to read my file completely ?

View 4 Replies View Related

[FIREFOX] Excel 2010 - Multiple Windows On Task Bar

Sep 19, 2011

Using Firefox All open excel 2010 workbooks are placed into the single excel window on the task bar

Is there a way to open up another, or multiple, excel windows on the task bar, like in XP.

View 1 Replies View Related

How To Open Two Excel Files At Same Time In Office 2010

Oct 26, 2011

How can I open 2 excel files side by side in Office 2010?

View 1 Replies View Related

Excel 2010 Script Error Popup When Getting Data From Web

Apr 14, 2012

I sometimes get a script error when getting data from web when using Excel 2010.

This seems to depend on the ISP I'm using as I can take the laptop into some Wifi enabled Cafe's and EXCEL gets the data without the error popup.

Since I like to run some of these as background queries (updating Stock prices for instance) is there any way to skip or supress the popup. I've just about tried every possible option both in OFFICE and IE.

View 1 Replies View Related

Document In Excel 2010 Only Printing One Column Per Page

Oct 17, 2012

I am trying to print a document in Excel Starter 2010. The document contains the columns A to J and rows 1 to 466. When I try to print the document, only one column prints per page. I have tried selecting all the columns and changing the print selection but this just shrinks the column size, and prints it smaller. How do I change it so that I can print all columns A to J on the one page?

View 2 Replies View Related

Excel 2010 Crashes (BSOD) When Opening A File?

Dec 28, 2011

I just changed out my President's XP-Pro to Windows 7 Pro 64 bit.We store all of our Word & Excel docs on a 6.5 Netware server.Yes it's old and out of date - but it cost money to change it. so.....I had no problems ever with XP but with Windows 7 when you open a Excel file it ive the old BSOD.It may not do it every time, sometimes I have to open, close a couple of times and then it happens.I have no other problems in connecting to the Netware server.BTW - I'm using the Novell Cient 2 SP2 for windows 7

View 1 Replies View Related

Hyperlinks Between Publisher 20077 And Excel 2010 In Windows 7?

Apr 14, 2012

I can't get the hyperlinks to work between Publisher 2007 and Excel 2010 on my new computer with Windows 7. Also sometimes publisher closes down unexpectedly. Had not problem on old XP with Publisher 2007 and Excel 2003. Is this a compatibility issue?

View 1 Replies View Related

Office 2010 Runs Product Configuration When Opening Word And Excel

Oct 20, 2011

Just started using a new workstation with Office 2010 installed by OEM. Everything worked fine for a few days, and then every time i attempt to open a Word file or Excel file i get the MS Office dialog box that states "please wait while windows configures Microsoft Office 2010". The dialog box stays visible for 30-45 seconds and then the program opens and works fine.

Ran a repair, four times, didn't fix it.

All of my research leads me to a solution of uninstalling and re-installing. I'm not buying that if everything worked fine for several days, that a bad install will make the program stop functioning properly.

I also noticed, while visiting help within outlook, that the product was still a trial version and not currently activated. I have entered the activation code numerous times with no luck.

View 5 Replies View Related

Excel 2010 Emailed Spreadsheet Doesn't Save/overwrite The Original

Apr 24, 2012

I was recently upgraded to Windows 7 and Office 2010. Under my old version of Windows XP & Office XP/07, when I received an emailed spreadsheet & made adjustments to it, I was able to save it directly over the old emailed file. Now when I make any changes I am asked to save a copy of the file & to save it elsewhere on my computer & cannot save it directly over the original emailed spreadsheet. how to get this old feature back? I'm sure it's just a matter of ticking some option off.

View 7 Replies View Related

Can't Receive IMAP Outlook 2010 Mails , Errors X8004102A , X80041050?

Mar 23, 2012

I just downloaded Outlook hotmail connector from the official download website, and installed it to try, and explored it , it was working fine!After that I deleted the account and reconstructed it using pop3 conf., but didn't like the idea of no status update reflect to the webmail , inally decided to use the IMAP Configuration to have the features of the connector which I tried First,I deleted the pop3 account to return back to the connector configuration, the config. done successfully, but when outlook start it fail to pass the receive process , and produce the following errors:x8004102A , x80041050 after restarting the outlook and trying again send/receive, the receive process comes to no end. until errors appear or cancelling it.I just noticed that it restored the contacts, drafts and the folder structure on of my account from the first ever imap account which I created ( and deleted ) at the beginning .By the way I deleted the first imap account fromoutlook and from the C:UsersXuserAppDataLocalMicrosoftOutlook ,,,,

View 6 Replies View Related

How To Edit/delete "Comments" In Excel 2010 Starter

Dec 23, 2012

I'm working with a 1997-2003 Compatibility View spreadsheet in Excel Starter and I use Comments (the little windows to pop-up when you hover the mouse over a cell) throughout.

I don't see how to edit or delete them, when I right-click, it only gives me "show/hide" them.

View 5 Replies View Related

Constant Connection Reset Errors?

Nov 20, 2012

Basically, no matter what browser I'm using (I get the error in IE, Firefox, and Chrome), it usually takes me 5-6 tries to load any given webpage, and even then most of the time the formatting's screwed up, pictures don't show up, etc. I'm using a new(ish) HP laptop that's maybe about 20 feet from the router. The router itself is hooked up to the desktop computer, which never has this problem. My wifi signal is strong, and the indicator in the tray never drops below "excellent" signal strength even when I'm repeatedly clicking refresh. Power cycling the router doesn't work. I've cleaned out caches and histories, even uninstalled and reinstalled browsers with all necessary updates, and still nothing. I called the cable company that provides my internet and they're convinced it's not on their end. It doesn't matter if anyone else in the house is using the desktop with its net connection at the same time I'm trying to use mine. Theirs works, mine doesn't.

But here's the really weird thing: I had this same problem with my previous laptop.In both cases, I can take the laptop other places (school, coffee shop, etc) and never once experience this issue.It seems to have cycles where it'll be fine for a little while (maybe hours, maybe days), and then for a few hours or days at a time I just want to give up and go read a book or something.In IE, I typically get a standard "this page cannot be displayed" type error. In Firefox and Chrome, I tend to get more specific "the connection was reset" errors, often immediately upon hitting refresh. Sometimes the page will try to load, and "Sending request" or a similar message will appear in the status bar before everything craps out. Just as often, the page will appear to be very slowly loading, then parts of it will load but most of it will be an Error 105 message (In Chrome: "Error 105 net::ERR_NAME_NOT_RESOLVED): Unable to resolve the server's DNS address.") Doesn't matter what page it is. Google, Facebook, my school's library portal, reddit, Amazon, doesn't make a difference.

The only other thing I can possibly think of is that it's the router itself that's bad. It's a generic deal that doesn't even have a name; the manual I had to scour Google for refers to it only as "11g Wireless Security Router." But that still doesn't really tell me why the desktop connection works like it should (unless that connection is completely bypassing the router; I'm rather clueless about these things).

View 3 Replies View Related

Remote Desktop Connection Errors?

Jul 25, 2012

I am trying to setup a RDC with a static IP for my PC so I can access it from work. I started messing around with my laptop and PC trying to Remote Access them from one to another locally before doing set up my router to do port forwarding. I noticed that none of my laptops in my house can connect to my PC for Remote Access but I can connect to any laptop from my pc. I don't know what's going on. I've changed the IP on my PC 4 times and still nothing. Hard reset on my router, but nothing.

View 2 Replies View Related

Internet Connection Errors Since Upgrade To Windows 7

Apr 17, 2012

Over the weekend I upgraded my desktop from Vista home to Premium to Windows Home premium. Since then I cannot maintain my connection to the Internet via the router system in my building, although that had never been a problem before. It also is not a problem when I plug in my laptop.So I start connected and then after a couple of minutes of use become disconnected from the Internet. I go to troubleshooting and it resets the connection, for another two minutes.The two error messages I receive are Local Area Connection does not have a valid IP configuration and the default gateway is not available.

View 1 Replies View Related

Accessing SharePoint Via Outlook 7?

Feb 15, 2011

When using XP and Outlook 7 we were able to create a new email, click the attach button and in the File Name section type http://intranet. This would give us access to the intranet page and the various folders and documents that needed to be emailed to customers.

When using Windows 7 Ultimate or Professional following the above steps will only put a link to the intranet site in as the attachment.

How do I go about replicating the XP way of accessing files on the intranet?

View 3 Replies View Related

Batch File To Log In To SharePoint?

Jul 25, 2012

I am looking for a batch file to log in to SharePoint web site which has credentialsNot sure on how to pas the credentials using Batch file

View 3 Replies View Related

Sharepoint Login Problem After Upgrade

Apr 1, 2009

I upgraded from 7057 to 7068 version of Windows 7.

After the upgrade, my Sharepoint Designer 2007 is unable to open remote website on front page enabled IIS Server.

Also, I am unable to ftp to the site.

This was an upgrade, so all the installed programs were available after the upgrade. All other programs seem to be working fine.

Is there some sort of problem with Windows security...?

View 4 Replies View Related

Network Location For Hosted SharePoint / WebDAV Issue

May 7, 2009

I'm using Win 7, full RC, 32 bit. This problem happens on any machine and happened in Vista 32 bit as well.

I host our SharePoint server externally at Apptix and I am unable to map a network location to show up in Explorer. I'm not technical enough to know if this is a WebDAV issue or what. I have done tons of web searches when we had this problem initially with Vista 2 years ago. The solution was to download KB907306 and it worked in Vista.

Ok, I can accept that Vista and SharePoint development may have been out of synch at some point, but why the (insert multiple explicatives) hasn't Microsoft fixed this in Win 7? I'm not the only person in the world who hosts SharePoint and wants to view folders in Explorer. Is my hosting company the only one configured like this?

That being said (whew, I feel better), I tried to install KB907306 in Win 7 and I can now attach the location. I can see it on the left side of Explorer (folder view?) and in the main section. I can expand the left side to see the sub folders (I am prompted for my credentials), BUT, the contents of the folders never update the main window. I never see the files I want to see.

Oh, I also had the nightmare Outlook 2007 / hosted Exchange server config issue. I got around that one. Both our Exchange and SP servers are hosted by Apptix.

View 2 Replies View Related

Creating A Task In Outlook 2010 From A Word 2010 Document?

Mar 27, 2012

Win 7 Prof 32 bit
Office 2010

I've been trying to create a Task in Outlook from a Word Document that I have created on this computer. The idea is that a shortcut to the document is created as an Outlook Task. Click on the shortcut, and voila - there is the document.The "Create Microsoft Office Task" icon DOES send the document to Outlook as a Shortcut in a Task, however, when I open the task, Outlook says:"Outlook blocked access to the following potentially unsafe attachments: Shortcut to 'document name'."It's NOT an unsafe attachment; Outlook WILL OPEN this document if I send it as an email attachment. Outlook will open .docx files types.

View 4 Replies View Related

Classic Menus For Office 2010 Doesn't Work On Office 2010 Starter

Oct 21, 2012

Classic Menus for Office 2010 doesn't work on Office 2010 Starter.

View 1 Replies View Related

DNS Not Responding / Connection Specific DNS Suffix Under 'Tunnel Adapter Local Area Connection'

Aug 19, 2012

I started getting a "DNS not responding"? on my desktop. All my wireless devices work fine, and when I turn off my laptop's WiFi card and plug it into the same router it works as well.I've done some Googleing on the issue and none of what I found has helped.When I do an ipconfig on each maching, the thing I notice is that on the working laptop I have an entry for the "Connection specific DNS suffix under the "Tunnel adapter Local Area Connection", where on the desktop that's not working the suffix is blank.

View 4 Replies View Related

Internet Connection Over An Electrical Powerline Instead Of A Wireless Connection?

Mar 23, 2011

Internet connection over an electrical Powerline instead of a wireless connection?is it easy to setup, reliable, fast,..?More in particular a D-Link device:DHP-307AV PowerLine Homeplug AV Kit

View 6 Replies View Related

Make VPN Connection Over Multiple Internet Connection?

Oct 29, 2011

is it possible to make a VPN connection over multiple internet connection ? if this is possible then you can make multiple connection transparent to other applications running on ur pc.

View 5 Replies View Related

Nokia E66 Connection Internet Connection Problems

Dec 1, 2009

I am using a nokia E66 to connect to the internet at home. My pc at home is running windows 7 home premium 64 bit. I am currently using nokia pc suite 7.1.40.1. All the software installed without any problems. The problem that I am having is that after I connect to the internet, I can only roughly download / upload about 5MB of data and the connection will time out. I do not get any error messages that is did timeout. The only way I know this is that I stop seeing data being transferred in Network properties.

I then open my e-mail client to see If I can connect with a POP account and then I get an error saying it could not connect to the e-mail account. I then have to disconnect and reconnect and try again. This does not seem to affect web browsing though, only when I am downloading files. Like Steam will start update and stop, windows updates will start download and stop and so on.

I initially thought it was a problem with the network operator, but when I boot back in xp (my pc is set up to dual boot between xp and 7) every thing works fine. No download time outs. Is it the nokia software that is not supporting 7 100% yet or am I missing something else?

View 5 Replies View Related

Excel Spreadsheet Sorting It Out?

Nov 19, 2012

how I can convert the memberlist table from this particular website: [URL]into a excel spreadsheet with the following sorting headlines horizontally:

Company name Address Zipcode and City Phone E-mail Website

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved