Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook question...
I am having an issue with figuring out how to close a workbook. I know
how to close a workbook when the filename is constant/known but not when it is dynamic. The scenario is that my Main macro reads in a text file causing a temporary workbook to be created. It then copies data from the temp wb into the main wb. Problem is i cannot close the temp wb because its name constantly changes (book1, book2, etc. ). The soulution i am looking for is to be able to specify the name of the temp wb at creation, or capture its name for closing once the data has been copied to the main wb successfully. I suspect the Freefile variable is the cause of the temp wb changing from Book1 to Book2 and so on. Is there a way to set the temp wb name somewhere? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook question...
Hi Waxaholic,
Try something like: '============= Public Sub Tester001() Dim WB As Workbook Const sStr As String = "C:\YourFile.txt" '<<==== CHANGE Set WB = Workbooks.Open(sStr) 'Your processing code WB.Close SaveChanges:=False End Sub '<<============= --- Regards, Norman "Waxaholic" wrote in message oups.com... I am having an issue with figuring out how to close a workbook. I know how to close a workbook when the filename is constant/known but not when it is dynamic. The scenario is that my Main macro reads in a text file causing a temporary workbook to be created. It then copies data from the temp wb into the main wb. Problem is i cannot close the temp wb because its name constantly changes (book1, book2, etc. ). The soulution i am looking for is to be able to specify the name of the temp wb at creation, or capture its name for closing once the data has been copied to the main wb successfully. I suspect the Freefile variable is the cause of the temp wb changing from Book1 to Book2 and so on. Is there a way to set the temp wb name somewhere? Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook question...
I tried this but it is requiring a fixed name of the source text file
which changes periodically. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook question...
I figured this out. I just created a new sheet in the current workbook
and used it as a scrath pad, then deleted it. Waxaholic wrote: I tried this but it is requiring a fixed name of the source text file which changes periodically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook Question | Excel Discussion (Misc queries) | |||
Workbook question... | Excel Discussion (Misc queries) | |||
workbook question | Excel Discussion (Misc queries) | |||
Workbook Name question | Excel Programming | |||
Question for Experts: Opening workbook with workbook references | Excel Programming |