Hello,
I am a VBA novice so bear with me, please.
Every month, I run about 20 report packets, made of of a variable number of pdf's. Sometimes I need to re-run etc, some months I'll lose a packet or gain one depending on my assignment. Lets say the files for each packet are 1.pdf, 2.pdf, etc and stored in there own folder. But again, it can be variable total number. I'm trying desperately to add automation to my workflow. I have variable-driven server paths in one of my sheets, Data!C2, Data!C3 etc, where each cell represents a different output pdf set (so there are 4 pdf files in the path folder in C2, 5 in the pdf file in C3).
The format is basically: //server/folder1/folder2/folder3/formula1/formula2/formula3
That part was just some basic formulas.
I'm trying to basically run the following formula, which I definitely need to run in vba and am pretty lost:
if
C3<>0
open PDFSam in shell and merge all the files output to //server/folder1/folder2/folder3/
else
repeat but for C4 instead of C3, scan through row 100 for <>0 in case one of the cells has a false-status (not running a report that month, or not ready yet)
Similar to this thread, for reference, which is what made me think this would be the best way to approach the situation.
Thank you for your insight! Here is a screenshot of the sheet with the paths on it: Imgur: The most awesome images on the Internet
I am a VBA novice so bear with me, please.
Every month, I run about 20 report packets, made of of a variable number of pdf's. Sometimes I need to re-run etc, some months I'll lose a packet or gain one depending on my assignment. Lets say the files for each packet are 1.pdf, 2.pdf, etc and stored in there own folder. But again, it can be variable total number. I'm trying desperately to add automation to my workflow. I have variable-driven server paths in one of my sheets, Data!C2, Data!C3 etc, where each cell represents a different output pdf set (so there are 4 pdf files in the path folder in C2, 5 in the pdf file in C3).
The format is basically: //server/folder1/folder2/folder3/formula1/formula2/formula3
That part was just some basic formulas.
I'm trying to basically run the following formula, which I definitely need to run in vba and am pretty lost:
if
C3<>0
open PDFSam in shell and merge all the files output to //server/folder1/folder2/folder3/
else
repeat but for C4 instead of C3, scan through row 100 for <>0 in case one of the cells has a false-status (not running a report that month, or not ready yet)
Similar to this thread, for reference, which is what made me think this would be the best way to approach the situation.
Thank you for your insight! Here is a screenshot of the sheet with the paths on it: Imgur: The most awesome images on the Internet
