Need Code to SaveAs under different Menu.

P

pt_lily

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top