Oct 29 2018 01:25 PM
Hi all,
I created a macro for a date picker calendar type thing and saved the file as a macro enabled S/s with the .xlsm format.
Does this spreadsheet have to be open each time I want to use the date picker to input dates in cells in any Excel spreadsheet? We are a team of seven and work on shared spreadsheets. Will this affect the macro and will they also need to have the macro spreadsheet open individually?
Thanks
Oct 29 2018 01:54 PM
Oct 29 2018 08:43 PM - edited Oct 29 2018 08:45 PM
SolutionHi Joy,
If you save the macro in the VBA project of a specific workbook, then you have to open this workbook to access the macro.
But you can save the macro in the Personal Macro Workbook, in order to make it available to all open workbooks. Please check out this link.
With regards to sharing the workbook with other people, please note that the using macro is one of the limitations of the shared workbook, please check out this other link for more info.
Hope that helps
Oct 30 2018 03:29 AM
Thanks Haytham!
Oct 30 2018 11:34 AM
One other thing Haytham. Can you send me some links on how to transfer data on an Excel form into a spreadsheet or on a word document to a spreadsheet.
I have a form that users complete with certain fields having the same name as column headings in my spreadsheet. I want to be able to transfer all that captured data in the Excel form into a spreadsheet preferably at the click of a button. I am guessing a macro will be ideal or is this more of a pivot table table.
Oct 30 2018 07:24 PM
Oct 31 2018 06:38 AM
Hi Haytham,
question on this again. If the spreadsheets we use are saved on a network, how will this macro work? Will I have to save it to the laptop of each team member so when they open these network files it will run or is there a way of saving the macro on the network location itself?
Oct 31 2018 09:39 AM
Hi Joy,
Please note that the solution in the links is based on the Get & Transform (aka Power Query) not in a macro.
The Power Query is the best solution when you want to combine/append multiple tables have the same fields in one table.
If the spreadsheets are saved in a network drive, you need to move them into one folder to be able to use the solution that explained in the second link.
In fact, I provided you with these links because it's hard to explain this process in a reply here.
Regards,
Haytham
Oct 29 2018 08:43 PM - edited Oct 29 2018 08:45 PM
SolutionHi Joy,
If you save the macro in the VBA project of a specific workbook, then you have to open this workbook to access the macro.
But you can save the macro in the Personal Macro Workbook, in order to make it available to all open workbooks. Please check out this link.
With regards to sharing the workbook with other people, please note that the using macro is one of the limitations of the shared workbook, please check out this other link for more info.
Hope that helps