Wait, Takedown had a helicopter? (Filename: TSPC Car 4)
πŸ‘︎ 58
πŸ’¬︎
πŸ‘€︎ u/ThatChilenoJBro10
πŸ“…︎ Jan 10 2022
🚨︎ report
Using the new (Android Build Tools 7.0) Variant API to configure variant-specific output APK filename

I've been playing around with the new Variant API in Android Build Tools 7.0.4 and have got things like variant-specific applicationIds and abi-specific versionCodes working. But I can't see how to customize the name of the output APK. Should I be using Artifacts for that? If so, how?

πŸ‘︎ 27
πŸ’¬︎
πŸ‘€︎ u/mrcrdr
πŸ“…︎ Jan 19 2022
🚨︎ report
Whats your preferred way of reading all Filenames in a Directory into a list [ ] ?

I've got a directory with a load of filenames in it. I want to read all Filenames that end with ".WAV" into that list[ ].

There's probably more than one way to do that, what's your preferred way?

(my app will be on Windows and Mac)

πŸ‘︎ 6
πŸ’¬︎
πŸ‘€︎ u/Ian_SAfc
πŸ“…︎ Jan 25 2022
🚨︎ report
Titles using the filenames instead of the real movie name

My content gets matched correctly but the titles always use the filenames instead of the clean Movie title...It was not doing this before. Can't seem to find the setting to fix this :)

πŸ‘︎ 75
πŸ’¬︎
πŸ‘€︎ u/Bozzzzzzzzo
πŸ“…︎ Dec 24 2021
🚨︎ report
Just realized that a lot of my movie files have the native filenames in the metadata, which is screwing up the naming convention in Plex. Is there anyway to delete the metadata titles en masse?
πŸ‘︎ 13
πŸ’¬︎
πŸ“…︎ Jan 19 2022
🚨︎ report
Samba: How to determine the original filename represented by a mangled filename?

I have a huge folder of >1000 files. On any computer accessing the share, a few filenames are mangled (e.g. 2BQQOF~I.JPG). I know that this is done because the filename contains characters which won't be suitable for most clients, such as Windows.

What I want to know is how to figure out which file this is. Basically, I want to be able to ask Samba "What is the original filename of the file that you mangled to appear as 2BQQOF~I.JPG?"

I do NOT want to disable mangling, which is mostly what I get when I try searching for this on Google. I want to know which file it is so that I can rename it from the Linux side to a valid name.

Simply searching for filenames with non-ASCII characters will NOT work since many filenames have foreign characters and some have emojis in their filenames (both of which are valid in UTF-8-based file systems!). I've already checked the common set of invalid characters and none of them appear to be in any of the filenames.

πŸ‘︎ 50
πŸ’¬︎
πŸ‘€︎ u/fmillion
πŸ“…︎ Dec 28 2021
🚨︎ report
What's the numbers in RARBG subtitle filenames?

Oftentimes when I download a show/movie off of RARBG it has subtitles with numbers in the filename, sometimes even 2 subs for same language but with different numbers like "2_English.srt" and "3_English.srt". What do those numbers mean?

πŸ‘︎ 18
πŸ’¬︎
πŸ‘€︎ u/BLucky_RD
πŸ“…︎ Jan 08 2022
🚨︎ report
Security Breach Audio Files With All The Correct Filenames

Here is the link for the files
There are some files that don't have a name so I put them in a separate folder

πŸ‘︎ 12
πŸ’¬︎
πŸ“…︎ Jan 01 2022
🚨︎ report
Processing: Save image with random colors in filename

Hello my friends. I'm kinda new to processing.

I wrote this code where i have random colors. I can print them and i get something like this: (133, 149, 93)

Now if i want to save this image i want to have (133, 149, 93) in the filename as well.

I tried using save("image - " + colors + ".jpg") because i defined my random colors under colors.

The program works but don't save and i get the following:

processing.app.SketchException: TypeError: cannot concatenate 'str' and 'int' objects

at jycessing.mode.run.SketchRunner.convertPythonSketchError(Unknown Source)

at jycessing.mode.run.SketchRunner.lambda$startSketch$3(Unknown Source)

at java.lang.Thread.run([Thread.java:748](https://Thread.java:748))

I have the colors as colors = color(random(0, 256),random(0,256),random(0,256))

What should i change?

Sorry for bad explaining. Thank you for your help!

πŸ‘︎ 3
πŸ’¬︎
πŸ‘€︎ u/1seven6
πŸ“…︎ Jan 08 2022
🚨︎ report
Which terminal emulator/shell shows thumbnail preview when you hover of the filename?

This was just a couple days ago. I was trying out something in a virtual machine, and I deleted the VM, so not able to go back and check it. I'm not sure if it was kitty, urxvt, alacritty, or another terminal emulator. I'm also not sure if it was the bash or zsh shell.

When I ran the ls command in a folder, I could then hover my mouse over the files listed, and it showed a small thumbnail preview of that image. Does anyone know which terminal/shell can do that?

πŸ‘︎ 5
πŸ’¬︎
πŸ‘€︎ u/Aviyan
πŸ“…︎ Jan 24 2022
🚨︎ report
arduino doesn't create file when filename is a variable

I have a project where I want to create a new text file with the data as filename on an SD card.

When I use a fixed filename the code works fine. When I use the filename from a variable no file is being created. If I do Serial.print(variable) the text string shows up.

What could be the issue?

char filename[16] = {0};
File dataFile;             
tmElements_t tm;
String date = "";

void setup()
    getFileName()
    createFileName()

void getFileName() {
    tmElements_t tm; 
    if (RTC.read(tm)) { 
        date = String(tmYearToCalendar(tm.Year)) + "-" + String(tm.Month) + "-" + String(tm.Day) + ".txt";
        date.toCharArray(filename, 16);
        Serial.println("filename: " + String(filename)); 
    } 
}
void createFileName() { 
//Check if file exists? if (SD.exists(String(date))) { 
Serial.println("exists"); 
Serial.println("appending to existing file"); 
} 
else { 
    Serial.println("doesn't exist"); 
    Serial.println("Creating new file."); 
    Serial.println(date); 
    dataFile = SD.open(String(filename), FILE_WRITE); 
// if the file opened ok, write to it: if (dataFile) { 
    Serial.println("File opened ok"); 
// print the headings for our data 
    dataFile.println("Date,Time,Temperature1 ΒΊC,Temperature2 ΒΊC"); 
    } 
dataFile.close(); 
    } 
}
πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/firinmahlaser
πŸ“…︎ Jan 24 2022
🚨︎ report
Assassin's Creed Revelations: Kaos repack, conflicting filenames

I downloaded the Kaos repack for AC:R, and theres 4 rar files and a .nfo. the instructions given on the website tell me to unrar so i select all four and extract them, but the filenames inside all 4 rars are the same. The rar files themselves are labeled part 1 through 4, so i know they contain different stuff. What should i do?

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/Parceval420
πŸ“…︎ Jan 27 2022
🚨︎ report
How to remove filename.html from web url

Hello,

I am working on a couple websites that being served through a reverse proxy. Nginx proxy manager.

How do i remove index.html and other names from the end of the url? Ideally i couldn’t put in a β€œfriendly” name. Index.html = home. Is it settings in the website code? Settings in the reverse proxy?

TIA

πŸ‘︎ 7
πŸ’¬︎
πŸ‘€︎ u/chansharp147
πŸ“…︎ Jan 01 2022
🚨︎ report
new install, ROMs with spaces in filenames won't open.

Hey all,

Is this a known issue? I can't find a single reference to it after spending an hour on google, but maybe I'm looking in the wrong places.

New RetroPie install on a Pi Zero 2 W. Games will not open if there are any spaces in the filenames. I see the "Launching _____" screen after selecting the ROM from the menu, then it takes me right back to the menu.

But if I rename the files to remove all spaces, they open and run fine. That's workable, but since I've never had to do this before it seems like something's wrong.

The issue presents with both 4.7.1 and the weekly build of 4.7.20.

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/GanondalfTheWhite
πŸ“…︎ Jan 18 2022
🚨︎ report
how do i fix Failed to download file. Name: 1.18.json URL: https://launchermeta.mojang.com/v1/packages/6b87c76d1edcb1fb0d933382cbb8bb8483c362c4/1.18.json Error details: HTTP server doesn't seem to support byte ranges. Cannot resume. Filename on disk: 1.18.json Path: C:\Users\damle\AppData\Roaming\.m

https://preview.redd.it/0jgmj8omzna81.png?width=1360&format=png&auto=webp&s=b6ce5e4a9b46eec0a46f2c140b99098817743f67

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/anishplayz
πŸ“…︎ Jan 09 2022
🚨︎ report
Why? To me it's not good aesthetically to have the filename in both places.. I think it should be better to just leave "Kate" above.
πŸ‘︎ 5
πŸ’¬︎
πŸ‘€︎ u/allexj
πŸ“…︎ Jan 09 2022
🚨︎ report
Google sheets lookup file by filename in google drive

is there a way to link to a file on Google drive by the filename?

I am listing data on a google sheet, and in the same folder, I have multiple pdf files corresponding to the data on the sheet. Say, bl: 1234
has a corresponding pdf file 1234.pdf

is there a way to quickly link to the file based on the filename?

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/Friendly-Ad-1372
πŸ“…︎ Jan 11 2022
🚨︎ report
Does {tmdb-id} and {tvdb-id} both work in filenames? What about {anidb}? Any others?
πŸ‘︎ 3
πŸ’¬︎
πŸ‘€︎ u/Fit-Arugula-1592
πŸ“…︎ Jan 11 2022
🚨︎ report
File Import with Specific Format In FileName

I created a specific Registry File, and I appended to the file name in the following manner:

{$env:COMPTERNAME}_$((Get-Date).ToLocalTime().ToString('MM-dd-yyyy_THHmmss'))_FileName.reg

I want to be able to call this specific file back, using maybe another REG IMPORT or using Start-Process -FilePath "reg.exe" -ArgumentList 'import', 'E:\Path2File\FileName.reg

Thing is, the filename will have a unique name due to the timestamp on it. How can I reference that file inside my call without hard coding the name?

πŸ‘︎ 5
πŸ’¬︎
πŸ‘€︎ u/CuriousJazz7th
πŸ“…︎ Jan 03 2022
🚨︎ report
Force Jellyfin to use the filename as the display name of the media

Hi all,

Anyone know how to force Jellyfin to use the filename instead of the folder name when there is just 1 file in a folder?

Thanks!

πŸ‘︎ 5
πŸ’¬︎
πŸ‘€︎ u/bonjerryuk
πŸ“…︎ Jan 24 2022
🚨︎ report
What is the best way you can suggest to have a naming convention for filenames (used mainly for searching for a 'tag' as a letter/character combination which only shows that specific combination and NOT all listings of files with that letter)?

Example:

Random filename (abc-a-e)

Now if I search for '-a' I only want to show a result of filenames that contains -a and NOT also filenames containing a.

I tried this but it doesn't work. Any insights?

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/101az
πŸ“…︎ Jan 20 2022
🚨︎ report
Remove " (1)" from filenames.

I need a simple batch file to remove " (1)" (including leading space) from the end of all filenames in the current directory.

Example: Test (1).mkv to Test.mkv

Any help would be appreciated.

πŸ‘︎ 5
πŸ’¬︎
πŸ‘€︎ u/TarkusLV
πŸ“…︎ Dec 23 2021
🚨︎ report
Noob question: Is there any reason to use "App.js" as the filename for my entry point?

I've done a couple of tutorials and for some reason I think I remember somewhere someone specified that this specific filename was required.

If "index.js" is the entry point to my app, can I just have that contain the top-level main loop of my app, or is there a specific role that "App.js" fills, either technically or as a best practice?

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/Brumbleby
πŸ“…︎ Jan 11 2022
🚨︎ report
Indicating output filenames

I am working on a script currently to take in user inputs of files in, and write data to four output files based on a user-supplied file name. I have this written as such:

from sys import argv
script, windows_in, dsvm_vec, out, dir = argv

A_bg_out = (f'{dir}A_{out}.bedGraph')
C_bg_out = (f'{dir}C_{out}.bedGraph')
G_bg_out = (f'{dir}G_{out}.bedGraph')
T_bg_out = (f'{dir}T_{out}.bedGraph')

where windows_in and dsvm_vec are two input file names used later in the code, "out" is part of the output file names which will be common between all four outputs, and "dir" is the folder in which the files will be written to. Essentially I want to be generating four file names to be used later that would read as /path/to/output/N_OutputName.bedGraph which are used later to write to.

As it is currently written, I get a syntax error:

File "script.py, line 10
 A_bg_out = (f'{dir}A_{out}.bedGraph')
                           ^

SyntaxError: invalid syntax

I've tried writing the f string a few ways, but all give similar invalid syntax errors. Admittedly, I am a very inexperienced python user, and I expect there may be an easier way to do this. What syntax should I be using in order to create these variables?

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/MsCephalopod
πŸ“…︎ Jan 04 2022
🚨︎ report
Issue: Filenames are not displayed

I had this strange problem under Fedora, but it does not occur with all applications, only draw.io and rambox, this occurs when I save a file or try to open one using on of the mentioned apps. The filenames are displayed like in the picture, does anyone know why? My operating system is set to english.

OS: Fedora version 35 (Thirty-five) x86_64

Computer: XPS 13 7390

Kernel: 5.15.13-200.fc35.x86_64

https://preview.redd.it/9bi03hcd03c81.png?width=1071&format=png&auto=webp&s=a315ff25ab63fcd8f25f23b7ac5ba1f244a22a18

πŸ‘︎ 5
πŸ’¬︎
πŸ“…︎ Jan 16 2022
🚨︎ report
Allowing characters like */\":?|<> in filenames (ext4 on both sides)

Hi!

This is a problem I haven't had with my previous phones and I've been suffering it with the last one I got for a year and a half, so I guess it's about time I ask the interwebs:

First of all, some technical information:

  • Phone model: Xiaomi Mi Mix 3 5G (Andromeda).
  • ROM: Pixel Experience with Android 12.
  • /data file system: Ext4.
  • My computer's /home filesystem: Ext4.

So here's what I've been trying to do: I have some files that contain characters that are typically not allowed by Windows machines, but I don't care because I don't use Windows anyway. I can use them on my computer no problem, but copying them to my phone is impossible. Here are some examples of files I can't copy:

  • 2015 - WHY DO YOU LOVE ME SATAN?
  • Screen 2020-10-23 23:15:54.png

Now I'm guessing it won't let me add files with the other characters in the title based on this previos question in this sub and the Wikipedia article on filenames. However, I've checked with TWRP and my /data file system is Ext4, which shouldn't have any problems so long as the filenames don't contain / or \0.

I've tried sending the files with Syncthing, but they fail to sync. ADB tells me that the file could not be created:

adb: error: failed to copy 'Screen 2020-06-16 16:11:03.png' to '/sdcard/Pictures/Screen 2020-06-16 16:11:03.png': remote couldn't create file: Operation not permitted

Also, if I connect the phone with MTP and try to copy them the operation just freezes without any message.

AFAIK I shouldn't be having this issue in the first place because I'm using Ext4 on both ends, right? Am I doing something wrong? Is there something I can tweak in my system or does Android manually reject those characters no matter the file system?

Thank you very much for your help and time :)

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/Groctel
πŸ“…︎ Jan 07 2022
🚨︎ report
Searching files with filenames.

Is it really hard to search files using filename search? I always end up manually the files, it seemed like it is currently not possible to search using only filenames through drives and folders? is it really like this? or are there plans for this to be fixed to make searching to a tons of files be easier.

πŸ‘︎ 7
πŸ’¬︎
πŸ‘€︎ u/nicko11211
πŸ“…︎ Jan 24 2022
🚨︎ report
Request: select files based on list with filenames

Hello everyone. I'm looking for a way to automate this: I have a folder with a couple of thousand files. Regularly I need to interact with a couple of them, not always the same. And non-consecutive files. If I have a list of the files I need to select, can I use an applescript to select those files for me?

Thanks!

πŸ‘︎ 4
πŸ’¬︎
πŸ‘€︎ u/idontgotoparties
πŸ“…︎ Jan 04 2022
🚨︎ report
Using advancedsettings.xml and excludefromscan to exclude a list of exact filenames (not just pieces of a filename/ext)

[SOLVED] Had to dig around in the regex forums for the correct syntax, but I finally figured it out. My advancedsettings.xml file now looks like this...

&lt;advancedsettings&gt;
&lt;video&gt;
  &lt;excludefromscan&gt;
    &lt;regexp&gt;.*The_Hobbit\-An_Unexpected_Journey_\(2012\)\.bluray\.mp4$&lt;/regexp&gt;
    &lt;regexp&gt;.*The_Hobbit\-The_Battle_of_the_Five_Armies_\(2014\)\.bluray\.mp4$&lt;/regexp&gt;
    &lt;regexp&gt;.*The_Hobbit\-The_Desolation_of_Smaug_\(2013\)\.bluray\.mp4$&lt;/regexp&gt;
  &lt;/excludefromscan&gt;
&lt;/video&gt;
&lt;/advancedsettings&gt;

The most recent scan I ran ignored those 3 files perfectly, so I'll just have to add all the files I want to ignore in the same format. Thanks to everyone for the alternative ideas!

ORIGINAL POST: I've been looking for a way to exclude a specific list of filenames from library scans using excludefromscan in the advancedsettings.xml file. I know you can setup regular expressions to match multiple files, but what if I just want to give it a list of just the exact files I want to ignore? Do I just drop a bunch of filenames between the regexp tags? For example <regexp>Name_of_Movie_(2021).bluray.mkv</regexp> <regexp>Name_of_Another_Movie_(2021).bluray.mkv</regexp> Or is there a different tag I should use?

The reason I want to do this, is because I have multiple Kodi systems with different capabilities, and for one system that can do 4K UHD, I want to ignore the lower resolution bluray copy of the films from being scanned over and over again when I add new movies. For my older systems that can't do UHD, I can remove those versions as well... but it's easier for those because I can just ignore all files with "UHD" in the title, but for the system capable of playing UHD, I can't just ignore all files with "bluray" in the title, because I don't have UHD versions of every movie, so I need to ignore them by the full filename. Thanks in advance for any insight you may have!

πŸ‘︎ 7
πŸ’¬︎
πŸ‘€︎ u/PurvisTV
πŸ“…︎ Dec 27 2021
🚨︎ report
Shoutout to all the TV uploaders who include episode names in the filenames

Another shoutout to those who include English subs, as well

πŸ‘︎ 3k
πŸ’¬︎
πŸ‘€︎ u/Rutabaga-
πŸ“…︎ Aug 25 2021
🚨︎ report
Help sorting 3dSteroidPro uploads in Google Photos? Anyone have a keyword that brings up only my 3d photo exports? Or a way to tag filenames on export so they are more sortable? I haven't been able to find a method that works.
πŸ‘︎ 30
πŸ’¬︎
πŸ‘€︎ u/Crowded_Bathroom
πŸ“…︎ Jan 02 2022
🚨︎ report
default note filename?

Just got my Supernote and I'm still digging in but was curious if there is an option somewhere to set the default filename format? If not this would be a nice option. You could have a series of date/time/week options to pick from maybe?

After tinkering with this a bit I think my ideal note names would be something like

  • week1-monday
  • week1-tuesday
  • etc
πŸ‘︎ 5
πŸ’¬︎
πŸ‘€︎ u/thecrumb
πŸ“…︎ Jan 02 2022
🚨︎ report
yt-dlp: How to add the order to the filename of a Youtube video based on when it was uploaded chronologically?

Hi there,

Been trying to integrate yt-dlp into my Plex set up. Currently I have a "TV Show" library set up on Plex, which expects a SXXEXX format in the filename.

I do not want to upload full channels. But I want the episode number to correspond to the order when the video was uploaded. so S01E637 is the 637th video uploaded by the creator.

Currently I am using a combo of ---dateafter 20210101 & --playlist-reverse & playlist_autonumber in the file output.

This works perfectly fine, however it is extremely slow since ```--dateafter 20210101``` does not detect the point in time where the first video was uploaded in Jan 2021 and just sequentially goes up the index. It actually starts from the beginning and checks one by one.

I intend to add this script to a crontab once a day or something to detect new videos with --download-archive. As you can imagine this takes a ridiculous amount of time and will probably cause my bot to get blocked.

Here is the full command:

~/scripts/youtube/yt-dlp -P ~/data/Media/Youtube --dateafter 20210101 --download-archive ~/scripts/youtube/downloaded.txt -i -o "%(uploader)s/%(playlist)s/S01E%(playlist_autonumber)s - %(title)s [%(id)s].%(ext)s" --merge-output-format mp4 --embed-metadata --embed-thumbnail --embed-subs --batch-file=~/scripts/youtube/channel_list.txt -S "+res:720,+vcodec:avc,+acodec:m4a,br" --match-filter "!is_live" --playlist-reverse --sponsorblock-remove sponsor --sponsorblock-mark all

πŸ‘︎ 6
πŸ’¬︎
πŸ‘€︎ u/rtaibah
πŸ“…︎ Dec 23 2021
🚨︎ report
[4K Stogram] Keep original filenames

Thanks for the program! However, I have downloaded Instagram images/videos for years using original filenames provided by Instagram, e.g. 271097455_525109758498076_7309511258650788211_n.jpg

Currently 4K Stogram renames files, e.g. previous one is 2022-01-01 03.34.04 2741236220437163998_315698531.jpg

I don't even know where that "2741236220437163998_315698531" comes from, why not "271097455_525109758498076_7309511258650788211_n" ?

Could you please add feature to keep original filenames? That would help me a lot to get rid of duplicates, and I feel like original filenames look better. Files should have original Modified dates still like they do now, so it's possible to browse files chronologically

πŸ‘︎ 3
πŸ’¬︎
πŸ‘€︎ u/Kallu0607
πŸ“…︎ Jan 04 2022
🚨︎ report
How do I search for photos by exact filename?

I couldn't find a way to search for photos by their exact filename. Neither did I find anything mentioned about this in the documentation nor did I find a way to search using filename. I don't either find an answer from several Google search.

For example, I'm trying to find a photo by this filename 20211204_172629.jpg.

I tried several options but had no luck. Below searches are returning all the photos that were taken on 20211204,

  1. 20211204_172629.jpg
  2. "20211204_172629.jpg"
  3. 20211204_172629
  4. "20211204_172629"
  5. filename:20211204_172629.jpg
  6. filename:"20211204_172629.jpg"

I found Search Photos Using Original File Name thread in Google Photos Help Community but it doesn't search by the exact filename that I'm looking for.

Hope someone would be able to help with this or provide some workaround.

πŸ‘︎ 4
πŸ’¬︎
πŸ‘€︎ u/tgnanakumar
πŸ“…︎ Dec 10 2021
🚨︎ report
"The process cannot access the file 'filename' because it is being used by another process" error for weeks

Hi! After I have waited 8 days for the distribution, it's been 4 days that I've been shown this error for Spotify, Youtube Music, Apple Music and TikTok. Here on Reddit you guys said to not do anything and the problem would resolve itself in 24 hours, it didn't. And Instagram delivery has been stuck since 2 days, too. I contacted the support 3 days ago but I haven't got any response. Is there anything I can do? Almost two weeks have passed in what should have taken "some hours" and it's starting to seriously affect my release.

πŸ‘︎ 3
πŸ’¬︎
πŸ‘€︎ u/Sbrudda
πŸ“…︎ Jan 22 2022
🚨︎ report
Need AHK script to rename filenames into date order (dates already appear at start of filenames in mm.dd.YYYY format) by adding sequential numbers to start of filename (i.e. 00001, 00002 etc)

I have a ton of scanned PDF receipts which have dates in the filename in dd.mm.YYYY format and need to sort them into date order. Since they were not created on the same date as appears in the filename, I cannot sort by date.

They are like "01.01.2020 shop 1 pdf", "10.11.2019 shop 2.pdf" etc, but there are a few thousand of them. The dates are always at the beginning and always in dd.mm.YYYY format.

I envisage eventually creating a single PDF file in PDF Exchange Editor and adding them in date order with bookmarks, so I can find each receipt easily.

What I need is a script which:

  • creates a 2-dimensional array, e.g. names(10000, 2)
  • reads the filenames of every PDF file in the same folder as the script into the first dimension, e.g. names(1, 1), names(2, 1)
  • sorts them into order by YYYY, then by mm, then by dd
  • adds as the second dimension into each entry of the array the sequential number in date order of that filename as a text string with 4 trailing 0s, e.g. "00001" which will be the filename with the earliest date, "00002" which will be the filename with the second earliest date etc
  • renames each filename by adding that number to the start of the filename (must be in string form with trailing 0s)

Unfortunately, I don't really know where to begin or I would have written some code.

Once I have this, I will hopefully be able to examine and adapt it to deal with filenames where the date is in a slightly different format.

πŸ‘︎ 3
πŸ’¬︎
πŸ‘€︎ u/AccordingBad8363
πŸ“…︎ Jan 03 2022
🚨︎ report
[EXCEL] Print both to .pdf and .docx and ask where to save and filename

Basically I need to create a macro that asks for a location and saves an opened word document in both .docx and .pdf and also asks for filename (the same filename for both).

I have searched and searched and can't seem to find if it is possible. Currently I am using this macro I recorded:

Sub grbaarpdfyword() 

' 

' grbaarpdfyword Macro 

' 

' 

    ChangeFileOpenDirectory "C:\Users\user\Desktop\" 

    ActiveDocument.SaveAs2 FileName:="Contrato Grupo Peque ESP.docx", _ 

        FileFormat:=wdFormatXMLDocument, LockComments:=False, Password:="", _ 

        AddToRecentFiles:=True, WritePassword:="", ReadOnlyRecommended:=False, _ 

        EmbedTrueTypeFonts:=False, SaveNativePictureFormat:=False, SaveFormsData _ 

        :=False, SaveAsAOCELetter:=False, CompatibilityMode:=15 

    ActiveDocument.ExportAsFixedFormat OutputFileName:= _ 

        "C:\Users\user\Desktop\Contrato Grupo Peque ESP.pdf", ExportFormat:= _ 

        wdExportFormatPDF, OpenAfterExport:=True, OptimizeFor:= _ 

        wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _ 

        Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _ 

        CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _ 

        BitmapMissingFonts:=True, UseISO19005_1:=False 

End Sub

but it doens't serve as right.

Many thanks!

πŸ‘︎ 7
πŸ’¬︎
πŸ‘€︎ u/PaulMuadDibKa
πŸ“…︎ Jan 12 2022
🚨︎ report

Please note that this site uses cookies to personalise content and adverts, to provide social media features, and to analyse web traffic. Click here for more information.