File Crashes When Opened

Jul 14, 2006

I run a macro which runs saves the active file to a different location to ensure that I retain the original like so -


If ActiveWorkbook. Name = "KEY_DATA_CFT77" + ".xls" Then
ActiveWorkbook.SaveAs Filename:= _
"H:HOME imcEXCELKEY_DATA_2006KEY_DATA_2006_01KEY_DATA_CFT77_01.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
End If .................................

View 9 Replies


ADVERTISEMENT

Automatically Open File In Specific File Path When Another Sheet Is Opened

Mar 20, 2014

I want to open a specific sheet and refresh only said sheet when i open another sheet for example x.xls

So opening x.xls will automatically open y.xls

I've tried this in the workbook code area but it doesn't do anything.

[Code] .....

View 1 Replies View Related

Crashes When Linking To Other Sheet Or File

Jan 13, 2010

my excel has developed the nasty habit of crashing when i try to link to another sheet or file.

i tried to copy the sheets to another file, and that worked.... for a while. i just cannot think to see what i do that causes this....

i am running excel 2003 (cheapskate company) and windows xp

View 6 Replies View Related

2007 Crashes When Saving A Specific File

Jul 1, 2009

Hi all, I've reinstalled office 2007 because excel 2007 was crashing very often when inserting new rows or when saving the file. I tried with other files and apparently work fine. The specific file can be opened but I don't know if is corrupted, I tried repairing it with open and repair from the file open menu but didn't work (it is still happening the same). I've been working on the file during few days and wouldn't like to start from scrath again, can anyone help me with this?

View 8 Replies View Related

Get Open File Crashes Upon Cancel Being Clicked

Mar 21, 2014

I have a userform where the user clicks a command button to select a gif/jpeg using the getopenfile function, the file path a is then loaded in to a text box and loaded in an image. I noticed that when the user cancelled before selecting a file it caused a crash. I have added some code to prevent this but now it crashed when an image is selected.

[Code] .....

View 3 Replies View Related

File Cannot Be Accessed - Process Crashes- Programmatically Trap The Condition

Apr 19, 2007

Workbook A has VBA code. The VBA code opens a collection of 2000 workbooks. The workbooks are processed one at a time, with Workbook A opening Workbook B, do something, close Workbook B, get next workbook. Sometimes Workbook B has some kind of access issue that results in:

"[File Name] cannot be accessed. The file may
be read-only, or you may be trying to
access a read-only location. Or, the
server the document is stored on may
not be responding.
RETRY ... CANCEL"

If RETRY is clicked, the process returns the same message. If CANCEL is clicked, the process is crashed, Excel is closed, and all data processed is lost. What is the VBA syntax to programmatically trap this condition so it can be processed in an orderly manner?

View 2 Replies View Related

Crashes On UserForm Show By Next Button (Path/File Error)

Aug 7, 2008

When loading my workbook, my userform loads perfect, but when I go to hit the "next" button. It crashes with the error:

"Path/File access error."

The next button code, quite simple: ....

View 9 Replies View Related

Log Of Who Has Opened File

Jan 7, 2009

Is there a way to create an outside log of who has opened an excel file and when?
I am looking to add some accountability to a project.

View 3 Replies View Related

Use Opened File In Formula?

Aug 18, 2014

Is it possible to insert the filename automatically in formula after the input from the user?

I want to ask the user to input a filename and afterwards, call that filename in an Index-Match

I have the below formula with the sample filename:

ActiveCell.FormulaR1C1 = _
"=INDEX('[filename1.xlsx]DATA'!C9,MATCH(RC[1],'[filename1.xlsx]DATA'!C32,0))"
Range("A2").Select

View 1 Replies View Related

Csv File Different When Opened Manually And Via VBA

Jan 21, 2009

Opening it manually the dates in column C are all consistently date numbers. i.e. using the =ISNUMBER() function to test them, they all return True
However when I include the VBA instruction:

View 7 Replies View Related

Massage Box When File Opened

Jan 6, 2012

I would like to have a message box pop up when a file is opened requiring a user to enter information (Name), that would then put this name into a cell for later use when they are printing.

View 6 Replies View Related

Disable The Vba In A File Being Opened Using Vba

May 20, 2007

I have excel vba code to open .xls files on my server. Files to open are chosen by the user via a UserForm within my app, it shows them all their files in their directory on my server. How can I open their files (.xls) that they select but DISABLE the VBA from being able to run/execute, if they have any attched to the file?

I now have all code in place to open the file no problem, I just need to know how to disable the VBA part from being "turned on" when the file opens.

View 9 Replies View Related

Working On File Opened With GetOpenFile (VBA)

Jan 23, 2013

the small code i'm writing just needs to do the following:

1. open an .xslx file selected by the user
2. copy 2 worksheets from that file to the current one
3. close the selected file without saving it.

This is my code:

VB:
Sub GetData()
MsgBox ("Please select a file"), vbOKOnly
Master = Application.GetOpenFilename(FileFilter:="Excel Files (*.xlsx), *.xlsx", Title:="Please select a file")

[Code]....

Opening the file works, but the last 3 lines don't because i don't understand how to declare "Master": however i dim it (workbook, object, variant...) i get an error on the GetOpenFilename line. If i don't declare it, i get an error while trying to copy the worksheets.

View 1 Replies View Related

Closing A File Opened Via GetOpenFilename

Oct 6, 2009

The Macro asks the user to point at the location of a report, it then copies information out of that report and pastes it into a master sheet. The part I am having trouble with is closing the file that data has been copied from.

I have tried different things to close it such as

View 2 Replies View Related

Group All Opened File In 1 Tab Instead If Many Tabs

Jan 23, 2010

can group all opened file in 1 excel tab instead if many tabs?
open thru window the file u want...
http://i12.photobucket.com/albums/a209/tancfc/11444.jpg
http://i12.photobucket.com/albums/a209/tancfc/fhfh.jpg

right click on task bar > properties > under Taskbar Appearance, select Group Similar taskbar buttons > is not my answer

View 4 Replies View Related

2nd Excel File Trying To Open When 1st Is Opened

Apr 26, 2012

While opening one Excel file I get an error message saying that a 2nd file could not be opened because it cannot be found. I do not want this 2nd file to open. WHere do I find the "command" that is telling this 2nd file to open.

View 3 Replies View Related

Open Userform When File Is Opened

Dec 15, 2008

I have a Userform in Excel.

My requirement, is whenever I open the Excel file, it should open the userform and should not show the excel file at all. And the form is closed, the excel file should be saved and closed.

Also, I need the minimize button on the form and in the taskbar, it should not display the Excel file, it should display only the Userform.

View 9 Replies View Related

Corrupt File: Filename.xls Cannot Be Opened

Apr 18, 2006

I was working on a tax file yesturday, just a long long list of receipts. and the file is password protected. However, I went to open it today, and I get a message that says: "Filename.xls cannot be opened. the file may be read only, or you may be trying to access a read only location. Or, the server the file is located on may not be responding."

It's on my USB Drive. I've tried copying it to my HD so I can play with a copy, but no dice. When I try that, I get another error message, : Cannot copy Filename.xls. The file or directory is corrupted and unreadable. I've tried the various fixed suggested in the excel help files to no avail. I did a search on the forum, but didn't find anything that seemed to apply or help me. The computer I'm trying to open it on has Office 2003, the one I most recently worked on the file on has office XP. Not sure if this was a source of the problem. Doesn't seem like it should be. Hasn't been in the past. I'm not even getting to the dialogue box asking for my password yet.

View 2 Replies View Related

Reject User If File Is Being Opened By Other

Oct 20, 2006

how to alert and force second user to quit (i.e. even cannot open the file as "read-only) if the excel file is being opened by other?

View 3 Replies View Related

Auto Run Macro When File Is Opened

Jun 12, 2007

I am using the following code and putting it into a module.

Private Sub Workbook_Open()
MsgBox "Hi, thanks for opening me", vbInformation, "Ozgrid.com"
End Sub

when i open the file and click on allow macros it does not run.

View 2 Replies View Related

Highlight Last Opened File In List

Jul 26, 2007

For a project I need to develop excel spreadsheet that will contain two columns. First column will contain list of sale items. Other column will contain hyperlink to the items image as pdf file stored on hard drive somewhere. My requirement is to highlight row containing sale item, whoes pdf file is modified/updated since the last time user has opened the spreadsheet.

View 8 Replies View Related

Refer To File Opened By User

Aug 5, 2008

I am trying to refer to an open file in VBA script.

The script below is asking the user to open a file from which data is copied. I am trying to refer back to this open file but as the file name and path are not mentioned in the script, I am not able to.

myMsg = "Please Select Euromcontact Master DISTOPS File"
Response = MsgBox(myMsg, vbExclamation + vbOKOnly, myTitle)
sFileName = Application. GetOpenFilename
Workbooks.Open Filename:=sFileName
Sheets("CL value").Select
Sheets( Array("CL value", "CL Units", "CLC Value")).Select
Range("N12:N37,S12:Z37").Select
Selection.Copy
Windows("Euromcontact Value File TEMPLATE.xls").Activate
Sheets("CLvalueDIS").Select
Sheets(Array("CLvalueDIS", "CLUnitsDIS", "CLCvalueDIS")).Select
Range("R12").Select
Selection.PasteSpecial Paste:=xlValues
Sheets("CLvalueDIS").Select
Sheets(Array("CLvalueDIS", "CLUnitsDIS", "CLCvalueDIS")).Select
Range("R12:R37").Select
Selection.Copy
Range("N12").Select
Selection.PasteSpecial Paste:=xlValues
Range("R12:R37").Clear
Application.CutCopyMode = False

View 9 Replies View Related

How To Review Who Has Opened A File With Password And Made Changes

Apr 17, 2013

I have a master file which users are able to open via read only or go in via password to edit.

I'm not too bothered on the read only users more on person's entering the file via password, making any changes and then saving those changes.

Is there a way to trace what changes they made and would their name be saved as the new "author" of the file?

View 4 Replies View Related

Excel 2010 :: Locking File If Already Opened?

Aug 5, 2013

I am runnig Excel 2010. I was wondering how I lock an Excel file (make it 'Read Only') if someone already has it open?

View 1 Replies View Related

Copy/paste From File Opened By Macro

Oct 16, 2008

I have a macro which opens two different hyperlinks in excel. Opened workbooks have are named like 1.asp and 2.asp. Both contains only one spreedsheet. I need to copy these spreedsheets to the Workbook, from which they are opened.

View 4 Replies View Related

Update A User Name & Usrname() When File Is Opened

Feb 18, 2009

I have a cell that displays the user name and would like the cell to update whenever the file is opened and display the user. Below shows what the VBA module code. The cell has this formula "=Usrname()".

Function Usrname() As String
Usrname = Environ("username")
End Function

View 9 Replies View Related

Counting The Number Times A File Is Opened

Oct 14, 2009

I have a workbook setup as Read only for reporting purposes. I would like to capture the number of times and if possible, the users that are opening the file....is there a way?

View 9 Replies View Related

Track Date And Time A File Is Opened

Aug 5, 2007

I found some vba codes in this forum which record the date and time in column A when a file is opened.

Can the codes be modified such that when someone opens the file the second time on the same day, the date and time are recorded in column B?

Attached file for your reference.

View 9 Replies View Related

Blank Workbook Opening When File Opened

May 31, 2008

When I open a saved excel file I am having a problem with one workbook opening(a blank one), then the box saying that the program contains macros, and then the second actual workbook opening. I do not know what I changed somewhere alone the line, how to make just the one workbook I want (the second one) to open?

View 2 Replies View Related

When Use VBA To Open File - Notify User When Excel Opened By Other

Jun 14, 2014

I use the vba to open excel file. like workbooks.open filename:=abc.xlsm but I found that if the file is opened by other. Excel still open the file but it will not notify user that it is opened as read only.

Would you add more line to notify user if the file is opened by other?

View 2 Replies View Related







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