Macros in Excel

[Guest]

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?

 

[Gord Dibben]

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

 

[Guest]

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

 

[Gord Dibben]

Post the code please.

Are you running from a button, shortcut or directly from Tools>Macro>Macros?

Is your Personal.xls workbook open? Does the macro show up in
Tools>Macro>Macros?


Gord

 

[Guest]

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]

CTRL + B is the built-in shortcut for Bold

Perhaps you have a conflict there?

Maybe the file is being saved, but not where you think it is.

Have you done a file search for it?

Other than these meager suggestions from myself, perhaps someone else has an
idea.


Gord