|
|
#1
08-11-2019, 08:35 PM
|
|||
|
|||
Closing & Opening Files
I am using the following code to create a duplicate of an active file and then close the active file. But I am struggling to open the file I just created. Will appreciate some hand holding.
Code:
Sub Copy()
Dim strFilename As String
strFilename = ActiveWorkbook.Path & "" & "GJCT Roster Week " & Range("sWeekNo") + 1 & " WS " & Range("sWeekStart") + 7 & ".xlsm"
ActiveWorkbook.SaveAs Filename:=strFilename, FileFormat:=52
ActiveWorkbook.Close
End Sub
Last edited by Pecoflyer; 08-11-2019 at 11:57 PM. Reason: Replaced quote tags with code tags 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Emails disappear after closing and re-opening outlook | Rhen | Outlook | 1 | 01-07-2019 01:16 AM |
 Track Changes Automatically Accepting Changes after Closing and Re-Opening Document
|
cnethercott | Word | 1 | 01-16-2017 03:21 AM |
| Closing Word files | Humptydingo | Word | 5 | 09-07-2013 10:17 AM |
| Update powerpoint on a server without closing an opening | dntel123 | PowerPoint | 0 | 08-18-2011 02:41 AM |
|
WORD opening and closing is slow
|
chum | Word | 2 | 07-05-2010 07:06 AM |
Windows 10 
Office 2016
Threaded Mode