+ Reply to Thread
Results 1 to 37 of 37

Capturing individual JPGs of 1000 or so different cells - can it be done with automation?

  1. #1
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Capturing individual JPGs of 1000 or so different cells - can it be done with automation?

    I would very much like to have an individual jpg of the musicians for each album on my music. The data is very easily exported from the music software to Excel (simple copy & paste), and then I can do a little formatting on the cells - see attached samples.

    ACDC - Best of Bon.JPG




    Arena, Tina - Don't Ask.JPG

    What I would like to do is to run a macro that will image capture each of the cells (column F) and save the captures with the Album Artist and album name (which is in the Excel sheet - exported from the music software). Ideally each image capture would saved in the Filepath for each album, but if that is not possible then I would just manually distribute them.

    The 3rd screenshot attached is the whole line, showing the filepath.

    ACDC whole line.JPG

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    You really need to attach a sample file as per the banner, not images of the file for people to look at. You also need to say what the names of the files to save are. Also what file type do you wish to save the images as. It is a bit of a pain as the below articles explain


    https://software-solutions-online.co...table-as-jpeg/
    https://www.thespreadsheetguru.com/b...ure-file-excel

  3. #3
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Sample sheet attached. The JPG would be saved in the folder name shown in Col C, and the name would be from Col E. The image to capture would be Col D (for each line of course)
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Perhaps something like the below tweaking the above link
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    The code in your second link actually works very well, once I took out the last line
    Please Login or Register  to view this content.
    However, when I try to save it directly to the folder like this:
    Please Login or Register  to view this content.
    where
    Please Login or Register  to view this content.

    instead of using this:

    Please Login or Register  to view this content.
    it completes, but there is no jpg in the folder.
    Last edited by FenceFurniture; 09-20-2021 at 06:38 AM.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,382

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Administrative Note:

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Thanks for your help thus far davsth. I have to leave it for the moment, due to our different timezones.

  8. #8
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Quote Originally Posted by davsth View Post
    Perhaps something like the below tweaking the above link
    ...
    I did have one last crack before dinner and this code does work, however, the problem is that after the year 1994 I have an Em space then Don't Ask:
    1994 Don't Ask

    and it doesn't like the Em space (which is a bit odd, given that it came from Excel, and is quite okay in my other macros)
    Last edited by AliGW; 09-20-2021 at 06:58 AM. Reason: PLEASE don't quote unnecessarily!

  9. #9
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Well what do you want to do with the Em space? include a sample with it included. Perhaps the code for the filepath is just inside a trim function

    Please Login or Register  to view this content.
    Or something along those lines?

  10. #10
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    There was a fundamental error in my code last night, and the Em space isn't a problem at all.

    Your code works perfectly now davsth, and thank you so much for your assistance.

  11. #11
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    A new error has crept in. Here is my complete code
    Please Login or Register  to view this content.
    Every now and then it trips on this line:
    Please Login or Register  to view this content.
    (in bold above)
    saying that Microsoft Excel cannot paste the data,
    but if I simply press f5 it continues on for a few lines until it trips up on:
    Please Login or Register  to view this content.
    (in bold above)
    and it says
    Method "Copy" of object "Shape" failed
    and again if I press f5 it often continues on.

    However, some of the images are of the graph itself:
    Musicians.jpg

  12. #12
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I suggest a workbook that exhibits the error is attached, so someone can see it happening. I assume it happens partway down the sheet so that it is not that you are starting on the wrong sheet.

    It could be the below
    https://recoverit.wondershare.com/of...ste-error.html

    However you are getting to the point that my vba skills are flaky and someone with more expertise will probably have to give you assistance. At least my answer will put you near the top of the list!

  13. #13
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Quote Originally Posted by davsth View Post
    I suggest a workbook that exhibits the error is attached, so someone can see it happening.
    Hmm, I don't think that is really viable because they would have to create a whole bunch of folders for saving the jpgs into. No, I'm not starting on the wrong sheet (there is only one )

    For the moment – unless it becomes onerous – I'll stick with just pressing F5 for it to continue on. Then, at the end of the process, I can do a search on the root folder for Musician.jpg, display them as extra large icons and find out which ones are a jpg of the chart background and re-do them.

    I will of course have a read of the link you posted. Thank you for your help.

  14. #14
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I would change the code to save all the files to the same folder, to see if the error occurs. This is then not onerous. I changed path to save to U:\ my local drive (its commented out in the first post I made.

    If no problems, the problem is with the folder names? Otherwise anyone else can try and replicate the error

  15. #15
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Good idea! Out of that range of 280 albums there were 35 that just displayed as charts, but by sorting them by ascending file size I can more or less group them together, copy the paths, write a little routine to re-do them, but I'll have to get to that tomorrow.

  16. #16
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Is it always the same 35 or is it random?

  17. #17
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I don't know why, but the site seems to think that my response is HTML code and is blocking it. Here is a jpg image of it.
    Attached Images Attached Images

  18. #18
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I think as re running it causes it to work, suggests that it is random. It would have errored if some of the folder paths had been typed wrongly or if there had been trailing spaces.

    your post was blocked probably as it was sensitive to <or > symbols, bizarrely putting spaces around them often lets you paste.

    AS for the code intermittently not working, im afraid that is outside my area of expertise, someone else will probably know

  19. #19
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I thought I might fool around with some error handling, but man does it slow things down! However, at least it doesn't keep crashing literally every 2 seconds. It seems to create some unnecessary looping too, so I may need to review it. I included some counters as well, and when I get an error I'm telling it to write "Error" in column F. Currently it is set to exit sub after 2000 iterations (and there are only 1350 jpgs to create), and it reached 2000 after about 45 minutes or so (!).

    So out of 475 jpgs that were created in those 2000 iterations, there were 1527 errors counted. Obviously my code is making it error on the same occurrence a number of times.

    Here's the rub though:
    out of 190 I have checked so far there are 20 that have "Error" in column F, and ALL of their jpgs are perfect!
    NONE of the albums with dodgy jpgs are marked "Error"

    This is the code now (there is some housekeeping before and after these lines):
    Please Login or Register  to view this content.

  20. #20
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Can't edit that last post - shows as blank.

    There were 474 jpgs created, 2001 iterations, 1527 errors.
    2001 - 1527 = 474

  21. #21
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    have you tried stopping screenupdating at the top of the code, then switching it back on at the bottom . does this speed it up at all?

    Please Login or Register  to view this content.
    Similarly does
    Please Login or Register  to view this content.
    speed it up at all?

  22. #22
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I had that before but left it on for some reason, but I don't think that's the slowness. However, I'll find out in just a minute as I'm about to kick off another run.

    Of the 474 jpgs created there were 42 dodgy ones, so it's still running at 9% error rate. None of those 42 were marked error. This run will be just to fix those 42, then I'll do a bigger run. It's easier to look through the folder for the dodgy ones this way.

    EDIT: Yep, screenupdating off is absolutely essential for this one (10 seconds to get to 2000 iterations, as opposed to 45 minutes...)
    Last edited by FenceFurniture; 09-22-2021 at 04:35 AM.

  23. #23
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Your vba is better than mine, but there is some vba code filelen that may help you

    FileLen("C:\Temp\test file.xls") which returns the size of the file in bytes. if after the export, you check the filesize, could you repeat the step if it is < a certain size. Even if a few files were ok this would not matter in the scheme of things


    FileLen(sfx) perhaps being below 23000 perhaps repeat the step

  24. #24
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I'm not so sure about the coding being better....

    Trying to think through how filelen can help. Smallest legit file (with two lines) is about 7Kb, largest illegit file seems to be around 28Kb, so everything in between could be good....or dodgy.

    For the moment I'm just going through them 10-20 lines at a time. It's painfully slow with 100,000 iterations yielding only two jpgs sometimes (and one of them can be dodgy). I'm going to put an iteration counter on each album and dump it in Col G. Maybe that will reveal summink.

  25. #25
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Ok, that iteration count does seem to be revealing something. The last run of 100,000 iterations (that's the current limit) produced 26 good jpgs with only 1 iteration needed, and 1 dodgy one that needed.... 94,591 iterations to produce rubbish.

    The very weird part of that is that on iteration 94,591 it seemed to be happy with the rubbish it produced.

    And what were the other ~5,500 iterations doing??? 94,591 + 26 = 94,617 so 5,383 iterations were working on nothing? This is not making any sense whatsoever.

  26. #26
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I have referred the post to another area to see if anyone with more knowledge can help

    If you repeat the above with the same 27 do you get the same result?
    Is it the same file attempt that is problematic?
    Or will it be another file that is the issue?

    If it works with that export no problem, the problem is something in the code, perhaps not having enough time to complete actions, or memory issues?

    Alternatively would running the code and just making a list of the errors (rather than looping to keep trying ), be a quicker solution as the problematic file takes a huge number more iterations and still does not get a solution

  27. #27
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Ok thanks.

    No, it's a different result every time. Last night I just let it rip and it was doing a successful capture every 10-14 occurrence. Today I have modified the code so it just runs in batches of 8. Sometimes it will do all 8 successfully, sometimes 2, sometimes 4.

    I am using code to make it document how many iterations it goes through for each file.
    The successful ones have just one attempt. Sometimes it thinks it's been successful with one iteration but it has actually spat out one of the dodgy graph background jpgs.
    EVERY time that happens, all the rest of the next files in the batch of 8 have 30 iterations (the new limit I have set) and don't spit anything out.

    So, to be clear, once an incorrect graph background jpg has been created, even with only one attempt, the rest of the batch is rubbish - no jpgs created at all with 30 attempts each. (which I will now reduce to 3).
    I wish this next observation was reliable, but it is only perhaps 70% reliable: if, after finishing a batch, I go and delete the dodgy jpg, and rerun, the whole batch of 8 goes perfectly. This seems to be the only time they go perfectly, but they don't always go perfectly.

    I will accumulate some and take a screenie to post.

  28. #28
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    OK, a couple of images.

    This first one shows the last successful capture on the left, followed by the very next one, which is dodgy.
    Capture.JPG


    This is the excel report back, showing
    the successful one had one attempt (1991 Trio Volume One)
    the dodgy one had one attempt (1996  Sudden Burst Of Energy)
    and the three that followed didn't get anything created despite 30 attempts, and also getting an "Error" flag which means they got a 1004 Can't Paste Error in the VB code.
    Note that the dodgy one didn't get an error flag, but that errors ALWAYS follows a dodgy jpg.

    Capture1.JPG


    Apart from the fact that this is taking forever, even if I could get the code to stop after it creates a dodgy jpg, it would save considerable time (going back checking folders etc). The problem is that the code seems to think it's ok. I can stop it on the next one, but that doesn't save anything.
    Last edited by FenceFurniture; 09-23-2021 at 04:04 AM.

  29. #29
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Why not post a small file which errors with the code you have now. perhaps change it so all the exports are to the same folder (c:\) perhaps. then others can try and replicate the error. Your code and files have moved on a lot since they were last posted

  30. #30
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Ok, here goes. The problem is that quite a number of folders have to be created within the root folder (because the file names are all the same). I have pulled out some old code that I used to create folders, but unfortunately is crashing on the first line of:
    Please Login or Register  to view this content.
    with "User-defined type not defined"
    It may be a library reference error - it was a helluva long time ago, and I had assistance to get it working.
    Someone more knowledgeable than me will probably know what to do.

    So the first thing to do, is to go to sheet "NEW FOLDERS" and press the blue oval "Make New Folders". If it works it will create all the folders from row 2 to 50 on C drive.

    Then, go to the "Musos" sheet and press the blue oval "MUSO" which should create the jpgs in those folders. The first thing the code does is to expand the rows to autofit so that the full amount of data can be seen.


    If it turns out that the folders have to be created manually (sorry about that) then note that this:
    C:\1. MUSIC\5. Fusion & Jazz\Sanborn, David\2002 The Essentials (BO)\
    only has to be
    C:\1. MUSIC\2002 The Essentials (BO)\

    In other words, the 2nd and 3rd level down can be deleted because all the album names are different. Note however that those folder names will need to be the same in the sheet "Musos" column C.
    Attached Files Attached Files
    Last edited by FenceFurniture; 09-23-2021 at 05:48 AM.

  31. #31
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    I have seen this before in an older thread.
    The code seems to run faster than excel can run the command, results will have random files missing.

    Possibly run a second loop to see if the file exists?

  32. #32
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Thanks for your input Dave. I don't know how to run a loop to see if the file exists, however, I don't think that is the cause.

    You may well be right about being too fast. (err, the code, not me...)
    There is a "Wait" instruction I think, so I'll have a search for that to see if it helps.

  33. #33
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Well I'll be damned....the Wait instruction works. Two successive runs of 18 iterations, and then 50!

    Before the line that causes the 1004 Error, I added:
    Please Login or Register  to view this content.
    1 Second is the minimum wait time. I could use a WasteTime sub to bring it down to perhaps 50 milliseconds, but I'm happy to just let it run it's course.

    Thank you Dave, and particularly davsth for sticking with it and referring it on!

  34. #34
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    The folders can be create by vba but i think you have to create the parent first.

    Please Login or Register  to view this content.
    but parent folders need to exist before subfolders

    However is you save them all into the same folder and get the error, and then we solve the error, you can worry about paths latter.

    If I make all of column C U:\ it runs all the files (changed to include all of them line50 without an error!)

    I wonder about
    Please Login or Register  to view this content.
    to delay the code by a second just before it errors, if the problem mentioned is the cause. The 1 is a second so I might need tweaking to another number
    Last edited by davsth; 09-23-2021 at 07:00 AM.

  35. #35
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    lol you got there before me!

  36. #36
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    You may wonder why I have gone to all this trouble (which was nothing compared to the spectacular amount of research to get all the musicians listed with their instruments, all formatted the same, all cross-referenced between all the albums, so that I can tell who plays on what albums).

    I have a new DAP (Digital Audio Player) and the previous sentence probably indicates that I like to know who is playing on an album, particularly when it comes to Jazz and Fusion because they all move around so much. On my Desktop, I use Media Center to play music and all that Metadata is created from MC, and I can display it in a multitude of ways (which tells me that Vinnie Colauita plays drums on 70 different albums spread across 41 different Artists). However, when it comes to being mobile, the DAP can't display that data, but it can display more than one "Album Art" image if it is in the folder. Hence a jpg of the Musicians needs to go into the folder.

  37. #37
    Registered User
    Join Date
    01-12-2021
    Location
    Sydney, Oz
    MS-Off Ver
    Home and Student 2016
    Posts
    46

    Re: Capturing individual JPGs of 1000 or so different cells - can it be done with automati

    Ok, the code is now working nicely, and I've trimmed all the excess out of it. I'll include a sample spreadsheet for anyone who wants to look at it down the track.

    I changed the Wait to Sleep which can work in milliseconds, and to do that I needed to put at the top of the module:
    Please Login or Register  to view this content.
    I had used that years ago for something else that needed to be paused.

    So the code to run the jpg creation now looks like this, with a 300 millisecond pause (at 250 I still get the odd 1004 crash)
    Please Login or Register  to view this content.
    I imagine that the 300ms delay is directly related to the type of disc drive that the jpgs are being written too. In my case it's a med-high speed Samsung SSD which I think has a max write speed of about 400MB/s. One of those new fangled 5GB/s drives might only need around 50ms.

    Or maybe the delay is required for some other part of the process....


    NOTE: For anyone who wants to run the two macros in the book, press the blue oval "Make new Folders" first and that will create the required folders inside a root folder "1. Music" on your C drive.
    Then press blue oval "MUSO" and it will run through and create the jpgs in those folders from the information in column D.
    Attached Files Attached Files
    Last edited by FenceFurniture; 09-24-2021 at 12:17 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Strange Currency Display 1000,0,00 € instead of 1000,00 €
    By Alan Bartlwy in forum Excel General
    Replies: 7
    Last Post: 09-27-2019, 10:21 AM
  2. [SOLVED] Capturing Individual High and Low Values of cells on multiple lines
    By jaurdonjo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-02-2017, 10:32 AM
  3. Outputting individual cells to individual text files
    By db9429 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2013, 03:39 PM
  4. Individual Cells to Individual Slides
    By mlexcelhelpforum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2011, 06:51 AM
  5. Replies: 2
    Last Post: 10-20-2008, 12:53 AM
  6. Replies: 2
    Last Post: 05-07-2007, 09:01 AM
  7. [SOLVED] Office Automation - Capturing Custom Menu Clicks
    By luai7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1