Excel 2013 :: Add-Ins (specifically Explode) And Network Drives

May 27, 2014

My office just upgraded from office 2007 to 2013. I went through my normal routine, adding back in settings and Add-ins. Everything seemed fine. I rely heavily on Aaron Blood's Explode Add-in. It seemed to work. If I open a local spreadsheet it works (same with ledger shade and some other personal add-ins). However, when I open a file on the network, the explode and ledger shade add-ins do not appear. My personal add-ins do, but I have set myself as a trusted root source. I am sure I have a security problem somewhere.

I went into the trust center/trusted locations and set my network drive (and it's subfolders) to be a trusted location. That did not seem to fix it.

I also tried copying a file that does not work on the network to my local drive to see if the add-ins would work - once on my local drive they do work. Also if I open a blank or local file, then open a network file, the add-ins are still there and working.

View 1 Replies


ADVERTISEMENT

Create List Of Drives (local And Network Mapped) On Computer

Nov 5, 2012

how to create a list of the drives on my computer using VBA. Maybe I missed something.

View 2 Replies View Related

Excel 2013 :: VBA Function To Get Username Of Open File On Network?

Aug 21, 2013

getting the username of an unshared file on network. When I click on file I'll get this message "...already open by " its blank.

I have found 1 code but it is not working on office 2013. VBA function to get username of open file on network?

View 4 Replies View Related

Formula To Explode A Cell

Feb 19, 2007

I have one cell that contains a person's full name. Example:

Barton,Drake Matthew

I would like to break this into 3 columns. How can I do this? (Without the comma after the last name if possible.)

View 3 Replies View Related

Sharing Excel File Over Network

Oct 22, 2003

Sharing excel file over network for use by multiple persons. File has suddenly stopped opening giving message "File cannot be found" etc.... I back the file up daily to my hard drive so didn't lose much.

This is the second time this has happened. File size is only 300Kb.

Excel seems to be creating temp files to the same folder, then gave a message saying changes could not be saved to the excel file.

Ran the corruption program from this site, it could not open the file.

View 2 Replies View Related

Place Excel Workbooks Into Network Folder

Dec 12, 2012

I want to ask about the network folder. The current systems that i develop contains about 15 excel workbooks and every workbooks link with each other. If i place all the workbooks into the network folder, does all the formula, link and vba will be changed to network too?

Such as the formula: ='G:systems[workA.xlsm]A1.

Does it will change the path of the formula? or i have to change all the formula, hyperlink and vba manually? second, how should i place the workbooks in network folder in a right way? do i need to change any setting at excel file?

View 7 Replies View Related

Excel Links To Wrong Network Location

Dec 14, 2012

I have a couple of functions in a excel addin file which is located on a network, i have been having this issue on a few spread sheets now and decided to test it on a completely new blank sheet.

The function i am using to test is called "extent" and it is called fine when loaded on one machine, loads fine on another machine, saved it. Load it up on another and the link is completely wrong. It is completely random between machines.

The link it loaded is an old one i have used before that is not in use, but it was not associated with this spreadsheet file in anyway. Is there anyway to force excel not to update these links automatically as the manual option is greyed out.

I can not fathom out why excel puts in this network location.

I have attached some screenshots, the correct network location is PODDrop BoxesPOD_AdminAddins

excel-link1.png
excel-link.JPG

View 1 Replies View Related

Saving Excel Sheet On Network Location

Mar 21, 2014

I am currently having a slightly annoying issue that only happens 50% of the time, that when trying to re-save a excel sheet on a network location. The network location is a folder on another computer. The same happens when I try and save it as a pdf, but only happens half of the time.

The message which pops up says something along the line of 'Saving as: 'File-ServerDocumentsexcelsheetexample.xls' ' and a sort of green loading bar appears. It does this for about 15 seconds then goes off.

I've checked our anti virus (which is eset) and I've set it to not real time scan network locations.

I have attached a example of the saving message: ExcelWarningExample.jpg

View 2 Replies View Related

Excel 2010 :: Using Macro To Open Network File

Jan 5, 2014

I am an extreme novice to using macros.

I used the 'record macro' feature to create the following: I created a rectangle box on sheet1 of NEW TEST.xlsm to link to the macros incidated below. Niether macro moves on after reaching the Workbooks.Open statement.

I am at a loss. Is there something in Excel that needs to be set? Is there something else that I need to do version of Excel is 14.0.6129.5000 (32 bit) MS Office Professional Plus 2010

What I am trying to accomplish is this: From 'NEW TEST.xlsm', open an excel file on the network, add a new sheet to this network file, calling it 'Pivot'. Then create a pivot table in this new sheet from the data in sheet data1 of this same network file. Then move control of macro / processing back to the NEW TEST file. Eventually I will do more, but for starters, I cannot even get the macro to add / name a new sheet in the network file.

[SIZE=3][COLOR=#000000][FONT=Arial]PS I have attached the NEW TEST.xlsm fikle as we as the data file. NOTE: the data file has been reduced to one day's worth of data, to to the upload file size.Also, my Excel Trustred locations has "Allow trusted locations on my network" checked, and the network location to the data file in trusted user locations.

VB:

Sub Open_Add_Sheet()
Dim filename, filelocation As String
Dim wb As Workbook
filename = "11 Nov, 2013 GDO AHS Agent Productivity Report.xls"
filelocation = "R:acharukAHS ReportsGDOGDO CSR ACTIVITY Report2013" & filename
Set wb = Workbooks.Open(filelocation) '
' Open_Add_Sheet Macro

[Code]....

View 9 Replies View Related

Macro To Map Drives

Nov 7, 2008

I have a issue at work where I can Map Drives but then when i reboot/log out the drives do not re-map. I have checked "Reconnect On Logon" but that does not work. I have called up IT and they just beat around the bush.

I am wondering, if there is a way for me to create a Macro to Map drives?
Also, for the macro to check if the drives are already mapped, if so then map it, if not then to skip mapping this drive.

I am hoping this can be made as convenient as:

X = C:Documents and SettingsPratikDesktopTest1

B = C:Documents and SettingsPratikDesktopData2

Where the X / B specify the drive letters.

View 14 Replies View Related

Internal Hyperlinks In Excel File Stored On Network Drive

Oct 16, 2013

I am having trouble creating a hyperlink to a place in the current document for a file stored on a network drive. My workbook has a lot of sheets (50 or so), so I created a 'Navigation' sheet that contains hyperlinks to all the worksheets located therein, and pasted a link back to the Navigation sheet in cell A1 on every tab.

Setting up these Navigation sheets has never a problem until I started posting the file on a network drive. As soon as I did that, I noticed that the internal hyperlinks on all sheets in the workbook would stop working after I closed the file in Excel. Note that this network drive is not set as a drive letter on my computer, and is only accessible by entering the server ip address in Windows Explorer.

An example address the hyper is trying (and failing) to open is: "file:///\ IP ADDRESS sub-folders activefile.xlsm"

I've tried a few options, using the HYPERLINK formula, using the HYPERLINK feature in the Insert ribbon, etc, but all to no avail.

View 8 Replies View Related

Excel 2010 :: Find Out Permissions On Set Of Folders On Company Network?

Apr 30, 2014

I have been tasked with trying to find out the permissions on a set of folders on a company network. I know write vba code to manipulate a excel spreadsheet without any problems, but it is when i'm using objects that it starts to go beyond my capability. whilst searching i found this code:

Code:
Sub test1()
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Const FullAccessMask = 2032127, ModifyAccessMask = 1245631, WriteAccessMask = 118009
Const ROAccessMask = 1179817

[code].....

It does a perfect job but puts the data into an html file. i managed to get it to input the data into the spreadsheet as well but i would like to clean this code up so that it is not producing another file (namely the text file or the html file) and just put the results into the excel file I have entered the module into.

I did start to remove the references to any file name, but that is where i run into trouble and it wouldn't run any more due to object not found.

I'm on Win 7 using Office 2010

View 1 Replies View Related

Searching For File On All Drives

Jun 15, 2007

The Code below searches for a file and displays how many files by that name it found.

Sub Test()
With Application.FileSearch
.NewSearch
.LookIn = "C:"
.SearchSubFolders = True

.Filename = "Temp.txt"

If .Execute > 0 Then
MsgBox ("Success: " & .FoundFiles.Count)
Else
MsgBox ("Fail")
End If
End With
End Sub

However, Flashdrives are a common use among those that will use the code, such that I need the code to not only search the hard drive C: but all hard drives and flash drives. Using .Lookin = My Computer did not find the files stored on my Flash Drive.
It finds it using .Lookin = "K:" but I can not rely on my flash drive always being K:. It does not find it using .Lookin = "PumaFlash" (Name of flash drive)

I'm looking for one of two things: Code that will Search all hard drives and flash drives (optical drives can be included) at once Code that will Find path for all hard drives and Flash drives and then search them separately

View 2 Replies View Related

Excel 2010 :: Opening Shared Workbook On Network Drive - Set Permissions?

Aug 20, 2013

I currently have a password secured excel file on my departs Q drive, which everyone can access unfortunately only 1 person can edit at a time. I tried to turn it into a workbook so we could all edit it at the same time but now some of the other users can't access the file at our other buildings throughout the county. This is for excel 2010. And I did select the share workbook, and allow multiple users to edit box. everything else is unchanged.

View 3 Replies View Related

Excel 2010 :: Saving File To Network Drive - Amend Date

Jan 29, 2014

I am currently creating a simple macro to save out files to a specific folder on one of our network drives. Since we will be doing this often I would like to amend the date the the file name saved for sorting/organizational purposes.

Unfortunately I have been running into a few issues, this is what I have tried so far but keep getting a SaveAs error:

Code:
ActiveWorkbook.SaveAs Filename:="vosinsharedClient Implementation TeamDC Tools" &
"Copy DC Conversion WB_2014 " & Format(Date, "yyyymmdd") & ".xlsx", FileFormat:=xlNormal

I have also tried:

Code:
ActiveWorkbook.SaveAs Filename:="vosinsharedClient Implementation Team
DC ToolsCopy DC Conversion WB.2014_" & _
Format(Now(), "YYYYMMDDhhmmss") & ".xlsx", FileFormat:=56

But still no avail. I believe it may have something to do with the file format but I am not sure. I am running Excel 2010.

View 1 Replies View Related

Row Height Specifically For Page Breaks

Nov 20, 2008

I have a spreadsheet that I use for work that I have set the row height specifically for page breaks. I use the top 3 rows on each page as a header with that page info.

If I update it at home, then email it to work, the row height has changed. No real problem, I just go in and adjust the row height. Then if I email it back to home from work, it does the same thing.

It's just this particular sheet that does it. All of the other sheets that I use always keep their row height properties intact when emailing.

View 10 Replies View Related

Naming Chart Sheets Specifically

Jan 3, 2009

I want my charts to be located in a new sheet each. I also need their names to start with "GR-Chart[number here]". So they should be GR-Chart1, GR-Chart2, GR-Chart3,......

ActiveChart.Location Where:=xlLocationAsNewSheet, Name:= "GR-Chart" & [this part I got wrong]

Do I use i? or .Count?

View 9 Replies View Related

Excel 2013 :: Mail Merging From Excel Database To Outlook

Apr 15, 2014

Using EXcel 2013, Windows 8

I have an Excel worksheet with one column being e-mail addresses. Other columns are Christian names, etc

Ideally can I create a full Mail merge with Outlook using whatever data I want. But probably just e-mail address and Christian name?

Otherwise be able to send one e-mail to all the e-mail addresses, without a major re-type.

View 2 Replies View Related

Convert Numbers To Specifically Formatted Text?

Feb 6, 2014

To input high volumes of dates I change the number format of cells to "00/00/00" so I can key mm/dd/yy without having to hit the slash key. In order to convert these values into an actual date, I've been using the =TEXT function because it allows me to format the text as "00-00-00" which preserves the numbers but inserts a hyphen between each set. From there I use text to columns to break each pair into its own column, and use the =DATE function to combine all 3 into a date.

Is there a way to automate this conversion process in VBA? Alternatively, I'd be open to a different method to input dates in the mm/dd/yy format without having to press the slash key.

View 2 Replies View Related

VLOOKUP #N/A Error Between Workbooks On Separate Drives

Nov 20, 2007

I have 5 worksheets in file Z on drive J which are full of VLOOKUP formulas pulling data from several files on drive K. Each worksheet pulls data from it's own file on drive K...ie, worksheet AB pulls all of it's data from file AB_2008, etc. On worksheet CD there are two rows which populate with #N/A when I open file Z, but if I open file CD_2008, the #N/A's automatically populate with the correct values. Any ideas??? I am not a programer but I have pretty fair excel skills...but this one has stumped me.

Here's my formula:

=VLOOKUP($A19,'K:sopworkbookssop_2008[sop_2008_rt.xls]11-RT-PPR'!$A:$BQ,C$34,FALSE)

View 9 Replies View Related

Can You Delete Specifically Formatted Text From A Cell

Jan 28, 2009

Is it possible to delete the work 'Strike' purely based on it's formatting I.E: as having a strike through set against it?

Im thinking it's not! I know you can use 'Find and Replace' for single cells with single words in, but not out of a sentence?

View 9 Replies View Related

How To Use A 'date Field', Specifically In A Chosen Column

Mar 19, 2009

Need to know how to use a 'date field', specifically in a chosen column, (lets say column C) that will transfer an entire row of information to another tab - next in line.
Example 03/19/09 to the 'tab/worksheet' labeled 03?

View 9 Replies View Related

Code That Allows Me To Print A Word Document On One Of My Drives With The Click Of A Button

Nov 9, 2009

I currently have this code that allows me to print a word document on one of my drives with the click of a button in excel. I need to modify it because one of the files I want to print as well is a pdf file. how to modify it so I can do that?

Set appWrd = CreateObject("Word.Application")
Set docOpen = appWrd.Documents.Open("F:groupsdeptservCDTISA.doc")
docOpen.PrintOut
docOpen.Close
appWrd.Quit

View 9 Replies View Related

Excel 2013 :: Average Readings Per Day

Jul 2, 2014

Working in Excel 2013......... I take 3 readings per day, I would like to see the daily average per day

In cases where the data is blank or "0", just average the 2 readings.

Sample Data

Date Speed

6/1/20142560
6/1/20142550
6/1/20142558
6/2/20142554
6/2/20142537
6/2/20142532

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

View 4 Replies View Related

Excel 2013 :: No Column Headers?

Nov 28, 2013

My and a work college needed to combine our separate excel worksheets into a single document.

Office 2013 didn't have a function to "import sheet from file" so we used open office to import my .xlsx worksheets.

After we finished importing we exported the final workbook as .xls (so I could open it).

After opening the workbook on my pc (excel 2013) i notice some of the sheets no longer have column headers, but the row headings still exists. (No ABCD, only 1234)

Also I am unable to use features such as "Freeze Pane"

I suspect this was caused by importing and exporting through open office?

View 4 Replies View Related

Excel 2013 :: Save Workbook To PDF And Name By The Value In A3?

Dec 18, 2013

Tried a macro with no luck, I want to save workbook to PDF and have it named by the value in A3. I want the Dialog box to pop up so I pick the folder?

View 6 Replies View Related

Excel 2013 :: Add In Buttons On The Ribbon?

Jun 24, 2014

I installed excel 2013, but I don't find the (VBA) buttons on the ribbon, since.

Is there a need to install an add in / or activate an add in?

The macro's are on the ribbon on the tab VIEW.

I expect to find the buttons on that place also.

View 3 Replies View Related

Excel 2013 :: How To Activate Developer Tab

Aug 21, 2014

How to activate Developer Tab in Excel 2013.

View 1 Replies View Related

Excel 2013 :: VBA - Save As (Get Filename)

May 6, 2013

I'd like to record a macro that allows me to take the current file "file.csv" and save it as "file.xlsx"

I can't get the variable right (just messing around in VBA to have it get the file name and save it as a different format (csv to xlsx)

I've tried:

Function GetFullName() As String GetFullName = ThisWorkbook.FullName End Function

View 7 Replies View Related

Excel 2013 :: VBA Connection To Access?

May 18, 2013

I currently have a workbook that has VBA functions that calculates values by looping through large amounts of data in a few large excel sheets. I want to transfer the data from these sheets into Access and then bring data into the VBA code via an array from the data in Access rather than the array being populated from the data in excel as it currently is. How to create the connection. The access DB will be situated in a public directory on a server. How to create the connection string and then how I call the data from Access? I have just downloaded Office 2013.

View 9 Replies View Related







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