- #Microsoft excel 2007 for windows 7 full#
- #Microsoft excel 2007 for windows 7 code#
- #Microsoft excel 2007 for windows 7 windows 7#
I get the save as dialog box, I just do not get theĭefaulted file name.
#Microsoft excel 2007 for windows 7 windows 7#
I'm running Excel 2007 but have Windows 7 operating system.
#Microsoft excel 2007 for windows 7 code#
WbOut is an Excel Workbook and ex is the Excel Application.Īs I mentioned earlier, this code works great on a co-workers computer that is running Excel 2007, but has an XP operating system. It is compiled and the executable is run from within Cobra as a custom menu option. This code is from a Visual Studio 2008 application written in vb. I ran a quick test with Excel 2003 on Vista and 7 and there also the names disappear when the above conditions I presume this bug is not caused by Excel 2007 since the behaviour is consistent on XP but not on Vista nor on Windows 7, so for me this is a Vista/7 bug. SName = "File name (xls) (filter is xlsm & xlsb).xls"ĭebug.Print "4) " & Application.GetSaveAsFilename(sName, sFilter, 1, "Test")ģ.Run the code and watch the file’s name in the dialogue. SName = "File name (xlsb) (filter is xlsm & xlsb).xlsb"ĭebug.Print "3) " & Application.GetSaveAsFilename(sName, sFilter, 1, "Test") SName = "File name (xlsm) (filter is xlsm & xlsb).xlsm"ĭebug.Print "2) " & Application.GetSaveAsFilename(sName, sFilter, 1, "Test") SName = "File name (no ext) (filter is xlsm & xlsb)"ĭebug.Print "1) " & Application.GetSaveAsFilename(sName, sFilter, 1, "Test") SFilter = "Excel Macro Enabled filter,*.xlsm *.xlsb *.xls,All Files,*.*" To replicate this behaviour do the following:ġ.In a virgin workbook open the code pane for ThisWorkbook
#Microsoft excel 2007 for windows 7 full#
We are going to have to accomodate both operating systems.Īfter continuing to do research, I believe my issue is a bug in Windows 7, as I found Dutch Gemini's Weblog that mentioned the same issue I was having and I was able to work around it. We are migrating everyone eventually to Windows 7, but until we can migrate everyone over My operating system is Windows 7), I get the Excel Save As Window but there is no default name already assigned.ĭoes anyone have any ideas as to why this would work using the XP operating system, but not the Windows 7 operating system, and how can I get it to work in both. However, when I execute the same application (I'm running Excel 2007 but This code works good for another indivdual in my office who is running Excel 2007 but who's operating system is XP, he gets the Excel Save as window with the default file name.
The code I am using is:ĭim fullName As String = ac.GetSaveAsFilename(fName,, , "Save File Location") I have a Visual Studio 2008 application where I am saving an file as an Excel document.