LA_Chaudhry
New Member
- Joined
- Nov 13, 2019
- Messages
- 4
I am busy making an eCommerce website, I have made a csv database with all the information that I need.
The issue I am facing now, I have thousands of rtf files for each items product description that I would like to add into excel.
The contents of each rtf file should be copied into a single cell into excel ie. 1 rtf file contents = 1 cell in excel with formatting.
I have tried pasting the link of the rtf file from the server into excel but the website just displays the link.
Is there any VBA code or macro I could run to solve this issue? Or is there another way I could link my rtf file into WooCommerce to display the contents of the rtf file on my website?
I have tried the following code (The first response by Andrew Poulsom): https://www.mrexcel.com/forum/excel-questions/47227-code-open-rtf-file-word.html
Which works including the formatting but distributes the contents into different cells and works for only 1 file at a time.
I don't want to open,copy and paste every rtf file into excel and have researched for quite a while on how to do this.
Any help will be appreciated ^_^
The issue I am facing now, I have thousands of rtf files for each items product description that I would like to add into excel.
The contents of each rtf file should be copied into a single cell into excel ie. 1 rtf file contents = 1 cell in excel with formatting.
I have tried pasting the link of the rtf file from the server into excel but the website just displays the link.
Is there any VBA code or macro I could run to solve this issue? Or is there another way I could link my rtf file into WooCommerce to display the contents of the rtf file on my website?
I have tried the following code (The first response by Andrew Poulsom): https://www.mrexcel.com/forum/excel-questions/47227-code-open-rtf-file-word.html
Which works including the formatting but distributes the contents into different cells and works for only 1 file at a time.
I don't want to open,copy and paste every rtf file into excel and have researched for quite a while on how to do this.
Any help will be appreciated ^_^