Excel 2010 :: Workbook Not Closing Correctly When Accessed Via Link On Sharepoint Site

Feb 18, 2013

I was asked to create a userform for the use of our whole team which would enable them to select a name from a dropdown list and then it would display their business contact details in the rest of the form.

I'm running Office 2010 and Windows XP server/enterprise edition (not quite sure which). After some research I've managed to use VBA code to open the userform while hiding the workbook, then when the close button is clicked it closes the user form and it's associated workbook using the code below.

Code:
' ThisWorkbook module
Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
End Sub
'UserForm module
Private Sub CommandButton1_Click()
Unload UserForm1
ThisWorkbook.Close (False)
End Sub

This works great when the excel file is accessed directly. However when the excel file is accessed via the link on my teams Sharepoint site it doesn't. When the Userform is closed the underlying workbook and data is then displayed which then has to be closed separately.

View 2 Replies


ADVERTISEMENT

Excel 2007 :: Generate Single Sheet Workbook And Save To Sharepoint Site

Jan 4, 2012

Automating Excel from Access, I'm attempting to generate a single sheet workbook and save to a Sharepoint site. This process works fine on my machine (XL2007, XP), but on a coworkers computer (XL2003, XP), the code throws a 1004 error on the save as line. However, the really odd thing is that stepping through the code doesn't throw an error on the coworkers machine.

Here's the sub being ran; the line it errors out on is the first branch in the .saveas block.

Code:
Private Const csSharePointSaveAs = "\sharepoint-us.mycompany.comsitesfinance adminlah blahlah-blahCustomer Publication Tracking.xls"

Private Sub PublishXLtoMOSS()
Dim objXL As Excel.Application 'Object
Dim wb As Excel.workbook 'Object
Dim ws As Excel.Worksheet 'Object
Dim rs As DAO.Recordset
Dim i As Long

'Set objXL = CreateObject("Excel.Application")

[Code] ...........

View 1 Replies View Related

Excel 2010 :: Macro To Upload SharePoint Project List Then Copy To Existing Workbook?

Jul 11, 2014

I need to be able to export a project list to Excel and overwrite the contents in an existing Summary Report with the exported list. Is this possible? I am using SharePoint 2013 and Excel 2010.

View 4 Replies View Related

Launch Link In Order To Copy String From Site Back To Excel

Nov 17, 2013

I have a list of web address in column A. All of the web address belong to the same site and are different products at the store. I want to be able to some how launch the sites and have Excel copy the text string which follows the word "PRICE:" on the site back into Excel into the corresponding cell of column B.

View 3 Replies View Related

Excel 2010 :: Paste Link Chart From One Sheet Of Workbook To Another Sheet Of The Same Workbook

Jul 20, 2014

I've created a chart in sheet 1 in a workbook. I want to copy and paste that chart into another sheet (lets take sheet 2) of the same workbook. I am using Excel 2010 version.

Whenever, I try to copy a graph and want to do "Paste Special as Link picture". The problem I am facing as "Paste Link" option is inactive.

I am attaching the Excel for your reference.

View 2 Replies View Related

Excel 2010 :: Won't Correctly Display Charts / Graphs

Apr 27, 2013

I am using Excel 2010 to create a simple chart. When I enter the information, highlight it and select a chart, the chart area appears blank. It doesn't matter what kind of chart I choose- it still appears blank. I've tried going into the Advanced options and indicating for All objects to be shown and that didn't work.

View 1 Replies View Related

Excel 2010 :: Unable To Recognize Cell That Contain Colon Correctly

Oct 4, 2011

i have encountered a problem which happens when you write data that contain : in an excel sheet (i use excel 2010)

for instance if i enter to one of the cell 45:58 excel sees it as 01/01/1900 21:48:00 when i try to get the information by using a function i will get the wrong data for example typing in the different cell LEFT(Cell,5) will result 1.908

(i receiving the data from an outside source in this way and i need to make analysis)

i have noticed that the first 2 digits (21 in the example) are related to the number i have choosen in a 24 hour cycle for instance

24:58 will result 01/01/1900 00:58:00
26:58 will result 01/01/1900 02:58:00
48:58 will result 02/01/1900 00:58:00

View 7 Replies View Related

Excel 2010 :: Hiding Worksheets When Closing File?

Apr 28, 2012

I am using MS Excel 2010.

What I want to Hide two worksheets and leave one worksheet open when I close out the file.

ws TOC will remain open when closing out the file
ws Rqmts will hide when closing out the file
ws Planning will hide when closing out the file

View 1 Replies View Related

Closing Workbook & Excel

Jun 26, 2009

How do I SAVE and CLOSE Workbook and it's instance of Excel.

I have other instances of excel open that I do not want closed.

I thought that I had this before, but I can't find it if I did. I do keep a list of all the requests where I ask for help and it's not in this list.

View 6 Replies View Related

Excel 2010 :: Crash - Ready Calculate Flashing Taskbar When Closing / Opening Userform

Jan 8, 2014

Excel will hang up as if it's gone into a continuous loop (Although no looping macros are active) when you open or close a user form. The task bar in Excel will flash Ready Calculate. Visual basic reports no code is running but excel either crashes or becomes very unresponsive. I have to exit and reopen excel in order to fix the problem . It also doesn't happen at any one specific point it can vary. I have various VLOOKUPs around the workbook and userforms display the correct information. I use the INDEX formula in the control source of textboxes. I also use the offset formula to make sure DTPICKER displays correctly.

I am using 'Option Explicit' at the start of all my code. I have tried a 3rd party code cleaner. No visual Basic references are MISSING

[URL]

View 9 Replies View Related

Excel 2010 :: Check If Cell Not Blank Upon Saving Or Closing And Color Code To Show Blanks

Aug 30, 2012

Looking forward VBA coding for:

If input is entered into column C (range C2:C100), then row cells for columns D, E ,F, H or I must NOT be blank upon save.
Could be that one or more of these row cells are left blank by mistake.

An error msg pops up upon attempting to save, stops the save and colors each cell yellow that needs info entered into.

Using Excel 2010.

View 9 Replies View Related

How To Link Two ComboBoxes Correctly

Sep 27, 2012

Linking two comboboxes. Actually My department consists of 4 divisions and each division contains 3 sections, that is beside Department manager staff and planning group.

In the attached workbook:

- Combobox1 contains All divisions, Department manager staff and planning group)
- Combobox2 contains all sections of the selected division in Combobox1.

What I want to do is the following:

In Combox1, I want to hide all records not related to the selected division.
In Combox1, I want to hide all records not related to the selected section.

Remarks:

I depend for filtering on the org. code for each division and section.

Fifth and Sixth digits of the first Division's Org. Code are 21

Fifth and Sixth digits of the second Division's Org. Code are 22

Fifth and Sixth digits of the third Division's Org. Code are 23

Fifth and Sixth digits of the third Division's Org. Code are 24

First section's org. code for each division ends with 11

Second Section's org. code for each division ends with 21

Third Section's org. code for each division ends with 31

I have created the following VBA codes to reach the said purposes, the first three ptions in Combobox1 work just fine, but the other options sometimes work fine and other times don't!

Moreover, Combobox 2 is not working at all:

Code:
Private Sub ComboBox1_Change()
On Error Resume Next
Application.ScreenUpdating = False
Select Case ComboBox1
Case Is = [AC4].Value

[Code] ........

View 1 Replies View Related

How To Upload A File To Sharepoint 2010

Dec 5, 2012

I need to upload the excel file (Book1.xlsx) which is placed in my desktop to the sharepoint 2010.

View 1 Replies View Related

Constraining Number Of Days A Workbook Can Be Accessed

Jan 24, 2013

Is there any way to have a input box pop up after a Prescribed number of days or on a particular date and from that point on prompting the user to enter a password that I created (hard coded into the code)In order for the workbook to open If the password is not entered or is not correct then the workbook will close.After the pasword is enterd then the workbook would open from that point on(the input box would be disabled) Also this macro would have to be password protected in order to prevent the user from accessing the code.

View 8 Replies View Related

Excel 2010 :: Insert Picture Without A Link

Feb 5, 2013

I'm using a macro to insert a photo in to a Excel 2010 workbook. If the photo moves location it will no longer display the photo in the document as I belive the photo is being referenced instead of embedded.

If you then use the "Change Picture" icon the photo embeds but how do I get my macro to embed the photo.

Sub InsertPhoto(PictNo)

Dim SH As Worksheet
Dim Rng As Range
Dim MyPic As Picture
Dim sPath As String
Dim PicH As Single

[Code] ......

View 1 Replies View Related

Excel 2010 :: Link A Cell To Textbox?

May 13, 2013

I am using Excel 2010. I am creating a flowchart which will require formulas. Unfortunately the flowchart connectors work best with text boxes rather than the cells. To make this method work, data will be entered into the text-boxes and will be calculated into other text boxes. Basically I need the data I enter into a text box to automatically fill itself into a cell in the background. I know there may be other ways to do this whilst not using text boxes at all, but I will not be using them.

I can fill a text-box from a cell by using F2 on the textbox and then typing =A1 etc, but I am having a hard time going the other way - getting a cell to fill from the value in the text box.

View 1 Replies View Related

Worksheet Open Event: Macro Run Every Time A Sheet In A Workbook Is Accessed

Jan 5, 2010

Is there a way to have a macro run every time a sheet in a workbook is accessed? Something similar to the workbook open event, but for worksheets.

View 2 Replies View Related

Closing Workbook When Closing Userform

Sep 14, 2006

I have a userform which opens when the workbook opens. Ideally Id like to have the userform open without the workbook coming up and have the workbook close when you close the userform. If thats not doable then is there a way to just close the workbook when the userform is closed?

View 3 Replies View Related

Excel 2010 :: Difficulty Breaking Link Possibly Caused By Name Function

Sep 11, 2013

I have researched a problem I am experiencing in Excel 2010 and have had problems in the past with previous versions. It seems that occasionally I run across a link that just refuses to break. During my research I have found some reports that this may be linked to the "Name" function. !!!Bing!!! the light comes on. When I copied my template to my new folder and tried to cut and paste data into it I got a message saying something like "A formula or sheet you want to move or copy contains the name "...", which already exists on the destination worksheet." and I opted to replace the existing name with the new one.

Apparently I created an external link at that point and one that cannot now be broken unless I delete my named range and start over the naming process. I mention this here because I see lots of people having this problem and the stock answer is to goto the Edit Links menu and attempt to break the link. Try as they and I might, this doesn't work. I also saw a post about it being a phantom validation problem and that too panned out although I can see how the validation could be linked externally and create this problem.

Does this accurately describes the issue and is there a remedy besides re-creating the "Names"?

View 1 Replies View Related

Excel 2007 :: Add Attachment To Spreadsheet That Can Be Accessed By Others?

Jul 23, 2013

I'm using Excel 2007, and when I add attachements to a spreadsheet cell (e.g. a saved email) nobody else can open the file when viewing the spreadsheet. Is there a way around this?

Currently I'm inserting it by going Object > Create from File > Browse > Select File > Display as Icon. But if the spreadsheet is emailed to anyone else or put on a staff website nobody can open the attachements.

View 8 Replies View Related

Excel 2010 :: File Sharing - Link 4 Spreadsheets Where Information Will Be Updated By One Person

Apr 21, 2013

I have a Excel Spread Sheet which has been created, there will be 4 people in 4 different locations who will have access to this spreadsheet and will need to update/amend it through "Dropbox", my question/problem is, how can I link the 4 spreadsheets where information will be updated by one person, but will update all 4 sheets at the same time.

Is this possible and how do I go about it?

View 4 Replies View Related

Hyperlink Error: "Unable To Open [link]. The Internet Site Reports That The Item You Requested Could Not Be Found. (HTTP/1.0 404)"

Feb 23, 2010

I'm trying to build a hyperlink using text formulas in Excel but I get the following error message: "Unable to open [link]. The internet site reports that the item you requested could not be found. (HTTP/1.0 404)". The strange thing is that if I copy-paste the link in the web browser, the page opens normally (which proves the link is correct).

View 4 Replies View Related

Link Formula To Unopened Excel Workbook

Oct 14, 2012

Im looking to insert a formula in vba code that inserts the formula from a closed workbook to the active cell. At the moment i have this as an example of what i need:

VB:
ActiveCell.FormulaR1C1 = "='[SRS 5FFBEP.xlsm]7%'!RC"

However the file part in square brackets [SRS 5FFBEP.xlsm] and tab 7% i would like to replace with a link to a cell reference that contains the file path as this needs to change and update so i would end up something like this:

VB:
ActiveCell.FormulaR1C1 = "=('" & Workbooks(Worksheets("SRS Files").Range("d29")).Worksheets("SRS Import").Range("c10") & "'!RC)

Note that cell Worksheets("SRS Files").Range("d29") contains the full file path (in text format) and Worksheets("SRS Import").Range("c10") is the link to the tab that reads the 7% (in text format).

As it stands the first set of code works fine however i need it to be able to change as previously stated. So what i need is to replace the file name and tab with cell references

View 1 Replies View Related

Excel Workbook - Finding Hidden Link

Jan 9, 2014

I have an excel workbook that a colleague of mine is working with. each time she opens it, she gets a message telling her that a .xls file could not be found, and a web-address specifying the file path. We went through the workbook together and looked at all of the formulas and i cannot find anywhere that this address is referenced. I also looked for any code, but there was nothing showing on any of the worksheets in the entire workbook. I broke all the links to other workbooks, used find and replace to search for the path, and to search for all the formulas. I also copied the tabs to a new workbook, but to no avail.

View 2 Replies View Related

Excel 2010 :: Close Second Workbook From Workbook BeforeClose?

May 27, 2014

I cannot make this work in XL2010.

I am opening a second workbook in ReadOnly in the Workbook Open and Closing it in the Workbook BeforeClose.

I don't EVER want to save changes on either workbook.

I need to leave excel open as the macro created a 3rd workbook which the user will need.

[Code]....

View 6 Replies View Related

Check In/ Out Excel Doc On Sharepoint

May 25, 2011

I have a doc on sharepoint called adamc.xlsx

When I open the doc I would like the workbook open event to check the document out for editing on the workbook close event i would like it to be checked back in...

Been playing around with Workbooks.CancheckOut but I've completely lost the plot.....

View 9 Replies View Related

Export Excel To Sharepoint

Dec 3, 2012

1) I have a excel on a sharepoint, i want to link it to the other sharepoint. Can this possible.

2) I want to open a excel which is in sharepoint, and export it to network place created in my computer. then save

View 2 Replies View Related

Connecting Between VBA Excel And Web Site

Dec 7, 2009

I have a some problem with connecting between VBA Excel and web site.

I wrote a macro to insert the data from excel but there is one problem with displaying the correct view.

I use this site to get the price of the bonds:
[url]

it is the site of russian exchange

First of all I write the ISIN code, for example RU000A0E6X12, in the "Quote Search" field and then press Enter for getting the data. After it I can choose the History information or Online from the last field in the left margin. I want to chose "History" and after it the dates from and till are appearing automatically. The automatization of it is my task. And I have only one problem in the end.

The program:

View 9 Replies View Related

Excel 2010 :: Link Data In Different Spreadsheet And Data Will Be Automatically Updated

Nov 3, 2013

I am working on Excel 2010. I want to find a way to link data from one spreadsheet to another one and whenever I update the first spreadsheet, the second one will be automatically updated?

View 2 Replies View Related

Excel 2007 :: Search For A File In Sharepoint Using VBA

Apr 18, 2014

I want to search for a file in Sharepoint using Excel 2007 VBA.

Path to the Sharepoint location where the files are at is [URL] ....

File name is customer_list_xxxxxx.xlsx The x's are a date which changes every day or week. So a new file will be uploaded to the sharepoint path.

Example customer_list_041414.xls

I've tried so many different code options for this, but no luck.

View 1 Replies View Related







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