Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I currently have the following SaveAs code on my workbook and it is working
fine. The problem that I have is this: The workbook is linking to a program that we use called GoldMine. When you perform a regular SaveAs the file won't link back to the program. Now, when GoldMine is installed on the user's computer it gives them an additional menu selection in their excel titled GoldMine. Instead of performing a File, SaveAs; you can perform a GoldMine, SaveAsLinkedFile and it will then link the file back to the program. Is there a way to incorporate this into the below code? I like how the below code is working (naming the file according to certain fields and to the named location), but I would like it to be able to do this with the GoldMine, SaveAsLinkedFile option instead so that my files will be able to link. Can this be done? Sub SaveWithVariableFromCell() Dim SaveName As String SaveName = ActiveSheet.Range("F7").Text ActiveWorkbook.SaveAs Filename:="G:\goldmine\Template\Seth\Orders\" & _ SaveName & ".xls" End Sub Thanks for any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Result code for SaveAs | Excel Programming | |||
SaveAs Code | Excel Programming | |||
Save and Saveas Greyed out on tool bar and file menu | Setting up and Configuration of Excel | |||
SAveAs executes combobox code | Excel Programming | |||
overwrite Excel SaveAs function from File menu | Excel Programming |