LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Need Code to SaveAs under different Menu.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Result code for SaveAs JWirt Excel Programming 4 April 15th 07 07:34 AM
SaveAs Code Ronbo Excel Programming 2 January 13th 06 03:49 PM
Save and Saveas Greyed out on tool bar and file menu Shareena Howley Setting up and Configuration of Excel 1 July 5th 05 01:02 PM
SAveAs executes combobox code Alan Lyall Excel Programming 3 June 9th 04 12:52 AM
overwrite Excel SaveAs function from File menu susie Excel Programming 1 July 31st 03 04:47 AM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"