Dear All,
I need MS Access to perform the following:
1. To export MS Access data into Excel file
2. While exporting it has to create an additional column in Excel file (SQL based)
3. This column should include the link to the website (which always stays the same) and reference to the excel cell (B2, C2, D2, E2 etc.)
4. The additional column should have special formatting, i.e. text written in red and in Italic.
Is here a way to do this with VBA?
Thanks a lot for your help.
I need MS Access to perform the following:
1. To export MS Access data into Excel file
2. While exporting it has to create an additional column in Excel file (SQL based)
3. This column should include the link to the website (which always stays the same) and reference to the excel cell (B2, C2, D2, E2 etc.)
4. The additional column should have special formatting, i.e. text written in red and in Italic.
Is here a way to do this with VBA?
Thanks a lot for your help.