W
wrbmab
Can I create a macro in one of my spreadsheets and send it to another user so
they could use it on their adta in their computer?
they could use it on their adta in their computer?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
Yes you can. The macro code is stored within the workbook itself...
J
Jacob Skaria
Yes you can. The macro code is stored within the workbook itself...
W
wrbmab
Jacob, thanks for the info. I asked the wrong question. We receive a data
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.
W
wrbmab
Jacob, thanks for the info. I asked the wrong question. We receive a data
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.
O
Otto Moehrbach
If I understand you correctly, yes. A macro is simply text. You can send
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto
O
Otto Moehrbach
If I understand you correctly, yes. A macro is simply text. You can send
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto
G
Gord Dibben
Place the macro in a module of a new workbook.
Save As>File Type>MS Excel Add-in
Place the add-in in a folder accessible to all users on your network.
Instruct them on how to load the add-in.
Gord Dibben MS Excel MVP
Save As>File Type>MS Excel Add-in
Place the add-in in a folder accessible to all users on your network.
Instruct them on how to load the add-in.
Gord Dibben MS Excel MVP
G
Gord Dibben
Place the macro in a module of a new workbook.
Save As>File Type>MS Excel Add-in
Place the add-in in a folder accessible to all users on your network.
Instruct them on how to load the add-in.
Gord Dibben MS Excel MVP
Save As>File Type>MS Excel Add-in
Place the add-in in a folder accessible to all users on your network.
Instruct them on how to load the add-in.
Gord Dibben MS Excel MVP