Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open file with code
Seems as though if I open a workbook using Workbooks.Open(Filename:=xxx) and
the file is in use I don't get the "file in use" dialog. I want to know if I'm opening a read only copy. Any workaround? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
open file with code
I open files as follows:
varDir = CurDir() On Error GoTo Opened Set wSource = Worksheets("----") Workbooks.Open (varDir & "\----.xls"), _ Notify = False, ReadOnly = False Application.DisplayAlerts = False Application.ScreenUpdating = False Heading Exit Sub Opened: Application.DisplayAlerts = False Application.ScreenUpdating = False Your code here, I use a sub name here, to go to the next stage. So if the next stepis maybe the insertion of headings, which is done with Sub Headings(), I would put Headings here. -- HTH Kassie Replace xxx with hotmail "Steve" wrote: Seems as though if I open a workbook using Workbooks.Open(Filename:=xxx) and the file is in use I don't get the "file in use" dialog. I want to know if I'm opening a read only copy. Any workaround? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
How to Open a file with the help of a code in Excel | New Users to Excel | |||
Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Code to Open Excel File Please Help | Excel Discussion (Misc queries) |