ComicsPriceGuide.com Forums - CPG - Questions and Answers - Can we export boxes to excell? - Messages https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 ComicsPriceGuide.com Forums - CPG - Questions and Answers - Can we export boxes to excell? - Messages en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Sun, 07 May 2023 12:25:04 GMT Sun, 07 May 2023 12:25:04 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from ruk appreciate that you have seen this issue years ago]]> Sun, 07 May 2023 12:25:04 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from Jayc13 Saving out to excel and delineate tabs is a pain. Export PDF and save as has been working for me. 😕]]> Sun, 07 May 2023 11:58:02 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from ruk I do my analysis thru boxes-and wd love to manipulate the data in a box-but need excel for that
I can do it by Publisher but it is a much longer process------------
I am too old to figure the work around you guys suggest but I appreciate your effort.]]> Sat, 06 May 2023 15:08:51 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from ChipS
Here is the work around.

1) save the box or collection as a PDF file.

OPTION 1

2) If you have the latest version of Microsoft word - Start the MS Word Program. Open the PDF as a file in MS Word. Word will convert the PDF to an MS word file.


OPTION 2
2) Copy the text from from the PDF to a MS Word file. Put placeholder text for the Notes column if it is blank.


3) Convert the text to a Table. This takes some work an is not perfect. (May be easier in latest version).

4) Copy the MS Word table in MS excel.


Easy? - no - Can be done? yes.]]> Sun, 13 Feb 2022 13:45:49 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from claydwilli

Ron, is this a possible feature update at some point? It would be a really useful thing to have]]> Tue, 18 Aug 2020 11:24:41 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from kds_comics pukie2122 wrote:
Thank you Ron.


Here is the work around.

1) save the box or collection as a PDF file.

OPTION 1

2) If you have the latest version of Microsoft word - Start the MS Word Program. Open the PDF as a file in MS Word. Word will convert the PDF to an MS word file.


OPTION 2
2) Copy the text from from the PDF to a MS Word file. Put placeholder text for the Notes column if it is blank.


3) Convert the text to a Table. This takes some work an is not perfect. (May be easier in latest version).

4) Copy the MS Word table in MS excel.


Easy? - no - Can be done? yes.]]> Mon, 17 Aug 2020 14:17:21 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from Spidey63 Mon, 17 Aug 2020 11:40:34 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from Ronbatman Ron]]> Mon, 17 Aug 2020 11:37:29 GMT https://comicspriceguide.com/forum/messages.aspx?TopicID=15492 Message from Spidey63
I know we can export to excel by publisher, then sort from there.

But is it possible to export boxes to excel?

Because of the way I grouped the books together in the boxes.]]> Mon, 17 Aug 2020 09:51:26 GMT