Keyboard Shortcut: Ctrl+b
'
ChDir "\\Darinet\coorsinet"
ActiveWorkbook.SaveAs Filename:="\\Darinet\coorsinet\bookings.xls", _
FileFormat:=xlExcel9795, Password:="doors", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub

"Gord Dibben" wrote:

Post the code please.

Are you running from a button, shortcut or directly from ToolsMacroMacros?

Is your Personal.xls workbook open? Does the macro show up in
ToolsMacroMacros?


Gord

On Thu, 24 Mar 2005 12:33:02 -0800, "Par3"
wrote:

The macro was located in excel - personal so it could be used in any workbook
Nothing happened when I ran it.

"Gord Dibben" wrote:

Par3

Where is the macro located? In which workbook?

What happens when you run it? Nothing? Error message?

Post your code and answer a few of the above.


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 09:59:03 -0800, "Par3"
wrote:

I receive a document in a htm format. I then export the data I need to an
excel spreadsheet. I want to creat a macro to save this excel doc to a
shared location. For some reason it will not recognize the macro. I have
used macros with other excel doc with not problem. Is it because the spread
sheet was exported in or anybody have any ideas?