Results 1 to 9 of 9

VBA Code to save new file without LINKS

Threaded View

CharleneM VBA Code to save new file... 04-19-2013, 04:37 PM
scott.s.fower Re: VBA Code to save new file... 04-19-2013, 05:40 PM
CharleneM Re: VBA Code to save new file... 04-19-2013, 11:26 PM
scott.s.fower I think it may hve to do with... 04-20-2013, 12:31 PM
CharleneM Re: VBA Code to save new file... 04-20-2013, 12:46 PM
scott.s.fower Re: VBA Code to save new file... 04-22-2013, 01:28 PM
CharleneM Re: VBA Code to save new file... 04-22-2013, 05:50 PM
scott.s.fower Re: VBA Code to save new file... 04-22-2013, 08:13 PM
CharleneM Re: VBA Code to save new file... 04-22-2013, 08:23 PM
  1. #4
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597
    I think it may hve to do with the save as part, maybe just save as .xlsx instead of " FileFormat:=xlOpenXMLWorkbook" (not sure what the syntax would be off the top of my head as im replying from my phone right now, i cant look it up efficiently) you could try "FileFormat:=*.xlsx"
    Last edited by scott.s.fower; 04-20-2013 at 12:34 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1