Macros in Excel
 

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?

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?

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?

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?

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?

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

On Tue, 29 Mar 2005 10:03:03 -0800, "Par3"
wrote:

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?