I am accessing our company's remote database through web based Excel (Framework). With Internet Explorer open, I want to get vba to activate IE and save the file with a new name. I can do it manually but can't figure out how to do it programatically.
The Excel running in IE appears to be just like the Excel 2000 on my PC but is running within IE and is read only. I can see the web version of Excel in the Visual Basic Project Explorer but the file name doesn't end in .xls (it has no extension shown).
I envision having IE open in the background, then in Excel pressing a control button which would activate a macro that would save the Web based Excel with a new name. Any help to accomplish this would be appreciated.
The Excel running in IE appears to be just like the Excel 2000 on my PC but is running within IE and is read only. I can see the web version of Excel in the Visual Basic Project Explorer but the file name doesn't end in .xls (it has no extension shown).
I envision having IE open in the background, then in Excel pressing a control button which would activate a macro that would save the Web based Excel with a new name. Any help to accomplish this would be appreciated.