Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as File Problem
I have a macro the save the file under the description typed in the Worksheet
"Test" cell "C1"(see below). The description I typed in the cell"C1" is "Top". The macro is working without problems. However, when I want to open the file I got the following message: CANNOT OPEN C:\New Files\Top.sldprt THE SYSTEM COULD NOT RECOGNIZE THIS FILE I believe is because I am using "ActiveWorkbook" which is being used for excel files and the file I want to save as is SoildWorks. Could you please help me with this matter. Thanks in advance. Maperalia '**** Start Macro**** Sub SaveAs() Dim WO As String Dim Progname As String Dim swApp As Object Dim ActivePart As Object WO = Worksheets("Test").Range("C1") Progname = "C:\New Files\" & WO & ".sldprt" ActiveWorkbook.SaveCopyAs Progname End Sub '**** End Macro**** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file save problem in excel | Excel Discussion (Misc queries) | |||
fix for open/save file problem | Excel Programming | |||
file save problem | Excel Programming | |||
Save sht as text file - problem | Excel Programming | |||
Textbox & Save file problem | Excel Programming |