I have an Excel spreadsheet that saves in two different formats when you
click save. One is as a webpage the other is just as Excel. How do I remove
the saving as a webpage? Thanks.

Look for a "Sub Auto_Close()" macro in the modules.

It should have the code lines there that you want to remove.
--
Best wishes,

Jim


"Lumpjaw" wrote:

I have an Excel spreadsheet that saves in two different formats when you
click save. One is as a webpage the other is just as Excel. How do I remove
the saving as a webpage? Thanks.

check out the beforesave event of this workbook.

press Alt+F11
double click on ThisWorkbook and in the code window make sure Workbook is
selected in the left dropdown and then in the right dropdown look for
BeforeSave (or any other in the list that is in bold type) and see what code
shows. You should see the code for saving in both types there and you can
remove the one you don't need ( or just put an ' in front of the line of code
to comment it out )

David

"Jim Jackson" wrote:

Look for a "Sub Auto_Close()" macro in the modules.

It should have the code lines there that you want to remove.
--
Best wishes,

Jim


"Lumpjaw" wrote:

I have an Excel spreadsheet that saves in two different formats when you
click save. One is as a webpage the other is just as Excel. How do I remove
the saving as a webpage? Thanks.

I knew there was something weird about my suggestion! :(
--
Best wishes,

Jim


"dkinn" wrote:

check out the beforesave event of this workbook.

press Alt+F11
double click on ThisWorkbook and in the code window make sure Workbook is
selected in the left dropdown and then in the right dropdown look for
BeforeSave (or any other in the list that is in bold type) and see what code
shows. You should see the code for saving in both types there and you can
remove the one you don't need ( or just put an ' in front of the line of code
to comment it out )

David

"Jim Jackson" wrote:

Look for a "Sub Auto_Close()" macro in the modules.

It should have the code lines there that you want to remove.
--
Best wishes,

Jim


"Lumpjaw" wrote:

I have an Excel spreadsheet that saves in two different formats when you
click save. One is as a webpage the other is just as Excel. How do I remove
the saving as a webpage? Thanks.

Thanks David for the suggestion, unfortunatly in this case there is no code
for the workbook in any case. The way I did this was like this.

I saved my spreadsheet as a regular Excel doc, than I saved it as a single
web page. Now when I open the file and save, it is save in both formats in
two locations. Any other suggestions? thank.

-lumpjaw

"dkinn" wrote:

check out the beforesave event of this workbook.

press Alt+F11
double click on ThisWorkbook and in the code window make sure Workbook is
selected in the left dropdown and then in the right dropdown look for
BeforeSave (or any other in the list that is in bold type) and see what code
shows. You should see the code for saving in both types there and you can
remove the one you don't need ( or just put an ' in front of the line of code
to comment it out )

David

"Jim Jackson" wrote:

Look for a "Sub Auto_Close()" macro in the modules.

It should have the code lines there that you want to remove.
--
Best wishes,

Jim


"Lumpjaw" wrote:

I have an Excel spreadsheet that saves in two different formats when you
click save. One is as a webpage the other is just as Excel. How do I remove
the saving as a webpage? Thanks.

I tried to re-create your situation with no success. Could there be links in
the web copy, linked back to the xls copy?
--
Best wishes,

Jim


"Lumpjaw" wrote:

Thanks David for the suggestion, unfortunatly in this case there is no code
for the workbook in any case. The way I did this was like this.

I saved my spreadsheet as a regular Excel doc, than I saved it as a single
web page. Now when I open the file and save, it is save in both formats in
two locations. Any other suggestions? thank.

-lumpjaw

"dkinn" wrote:

check out the beforesave event of this workbook.

press Alt+F11
double click on ThisWorkbook and in the code window make sure Workbook is
selected in the left dropdown and then in the right dropdown look for
BeforeSave (or any other in the list that is in bold type) and see what code
shows. You should see the code for saving in both types there and you can
remove the one you don't need ( or just put an ' in front of the line of code
to comment it out )

David

"Jim Jackson" wrote:

Look for a "Sub Auto_Close()" macro in the modules.

It should have the code lines there that you want to remove.
--
Best wishes,

Jim


"Lumpjaw" wrote:

I have an Excel spreadsheet that saves in two different formats when you
click save. One is as a webpage the other is just as Excel. How do I remove
the saving as a webpage? Thanks.

Jim,

I don't believe so it should not matter anyhow because it is the excel doc
that updates the web copy. The single webpage save is saved when ever I save
the main excel document, 2 different copies. Try this to recreate the
problem...

Save an excel doc on the desktop, then save it as a single webpage on the
desktop, then try to turn off the saving as a webpage which updates each
time, this is my problem. Thanks,

"Jim Jackson" wrote:

I tried to re-create your situation with no success. Could there be links in
the web copy, linked back to the xls copy?
--
Best wishes,

Jim


"Lumpjaw" wrote:

Thanks David for the suggestion, unfortunatly in this case there is no code
for the workbook in any case. The way I did this was like this.

I saved my spreadsheet as a regular Excel doc, than I saved it as a single
web page. Now when I open the file and save, it is save in both formats in
two locations. Any other suggestions? thank.

-lumpjaw

"dkinn" wrote:

check out the beforesave event of this workbook.

press Alt+F11
double click on ThisWorkbook and in the code window make sure Workbook is
selected in the left dropdown and then in the right dropdown look for
BeforeSave (or any other in the list that is in bold type) and see what code
shows. You should see the code for saving in both types there and you can
remove the one you don't need ( or just put an ' in front of the line of code
to comment it out )

David

"Jim Jackson" wrote:

Look for a "Sub Auto_Close()" macro in the modules.

It should have the code lines there that you want to remove.
--
Best wishes,

Jim


"Lumpjaw" wrote:

I have an Excel spreadsheet that saves in two different formats when you
click save. One is as a webpage the other is just as Excel. How do I remove
the saving as a webpage? Thanks.