Posts by Kyle Johnson2

Jonathan Harris9 said:The issue is I can't get p29542954-110901867220
I just keep getting p29542954-1,10902E+11 whenever I split it up

1. Use Text to Columns with the ":" delimiter and you'll have A, B, and C split up perfectly.
2. Format Column C as a Number.
3. In cell D1, just pop in this formula: =CONCATENATE(A1;"-";C1)
4. Delete Column B.
5. Boom. Now Column C shows your result: p29542954-10901867220

it seemed to me like it automatically saves the desired sheet into a new document

Well, it does exactly that, it just names it "backup of FILE_NAME".
1. Open the Workbook you're working in.
2. copy Macro into VBE and save the Workbook.
3. Tomorrow, open that same Workbook, update it, and hit Save.
4. While it's still open, run the Macro and it'll automatically save the active Sheet to C:temp under the name "backup of FILE_NAME".
5. When you open that new copy, it only has one Sheet—the one that was active when you ran the macro.
(don't know what else you need, at least that's how I took it).

I'd be happy to find code that
copies specific Sheets and creates new Workbooks named after the sheets to a specific location
while letting me pick the file type for each Sheet... like... .xls, .pdf, .csv...
though.. pdf.. can't create... or can it?

You've got some pretty big asks here, and honestly, based on the level of expertise you're showing in these posts, it’s gonna take a lot of work and knowledge (no offense). Best bet is to find someone who actually knows VBA programming "well" and have them build a Macro for you.

The thing you're asking about copies ALL Sheets to a location and makes each file named after the Sheet, but naturally with an *.XLS extension.

On THIS link there are plenty of tutorials; check them out and see if any fit, including SaveAsPDF which has visible comments explaining what each line does. You can also find an example of saving and calling the procedure for SaveAsPDF at the link for the INVOICE in Excel.

That's all from me on this topic. Peace.

restlessheron19 said:In the first example... the file copies to the right spot... shows up in C:\Temp..
but when I run that copy... Excel opens but there's no Workbook inside..
why's that happening?.. did I mess something up?

Not sure what you did there, but that Macro just copies the active Sheet into a new Workbook over at C:\Temp.
So basically, you end up with a file called "backup of FILE_NAME.xls" sitting in C:\Temp.
When you open that new workbook (the backup), it'll have the specific Sheet you ran the Macro from.
Bottom line: that Macro only grabs the active Sheet, not the whole Workbook.
BTW: stick that Macro in a VBE Module.

Melissa Chavez8 said:but I'm stuck on how to skip numbering for a few pages and then start it for the rest

Check out these step-by-step tutorials on some US forums

- Page numbering in Word 2003 starting from a specific page
- Page numbering in Word 2007 starting from a specific page

Nathan Johnson4 said:Look, what I'm actually trying to figure out is how to stack two different tables one under the other in the same doc, but give them totally different column widths—like in the example—while still being able to type data into both without everything breaking.

Like I said, just use Merge Cells or merge cells via the button or the menu.

On a blank Sheet, set all your columns narrow first (say, 20 pixels wide), then just get creative and build your table by merging specific cells together. Even if you're typing into a merged cell, Excel will still crunch the numbers in your formulas just fine.

restlessheron19 said:Book2.xls..maybe just toss it on the desktop..
or if we're feeling fancy.. make a folder.. name it.. then dump Book2.xls right in there on the desktop or wherever else on the drive...
that's basically how I'm picturing it

For one part of what you're looking for, check HERE , and for the rest, look HERE and HERE—or just Google 😉

restlessheron19 said:wants to swap out some data..
if cell B2 has a 1.. and I want to change that 1 to a /
yeah... I'll probably need to add an extra cell to get what I actually want..

is it really that hard to swap two characters in two cells?

you're being vague, just mentioning two cells. ???
Are you pulling those two cells into a different spreadsheet later or what.

If there's a ton of these cells with 1s and 2s, just hit Replace All.

You could also just use the formula =IF(B2=1;"/";"//")

ruggedmaker2 said:I could definitely use a hand here too 🙂
...........Is this a printer issue (maybe drivers?) or just how the document is set up?

Could be anything at this point 😉
Check HERE

nimblebadger9 said:How do I clear my history on Google Chrome?

What does that have to do with Microsoft Office?
Check out these links, might help you out
- LINK1
- LINK2

Gregory Rogers20 said:Hey everyone, anyone know how to sum up values from multiple Sheets into one master Sheet?

If you're trying to pull all the values from cell B14 across several Sheets, just grab one of these formulas:
Code:

analogwalker2 said:It’s ridiculous there isn't a dedicated program for this. I've got some software for making wall and desk calendars, but I really need something specifically for small pocket calendars.

Just whip up a calendar in Google Sheets and format it for print.😉

Frank Scott3 said:How do I set up Excel 2007 so it doesn't show a zero when a cell calculates to nothing?

Hit the Office button => Excel Options => Advanced => then just uncheck "Show a zero in cells that have zero value."

driftingangler11 said:I think something weird is going on with it—

First off, you clearly didn't read this post properly:
You copied the Macro into a Module when it was supposed to go into ThisWorkbook (it's clearly stated right there in the post)

Second, that problematic source file you uploaded creates a backup with an *.XLK extension because it was originally made in "Microsoft Office 2008"—specifically using the "Excel 2008 rev. 489" part of the suite—so on top of everything else, it’s spitting out an extra XLK backup file in the same folder as the original.
That's why my file worked fine. Next time, actually read the instructions. 😉
later

driftingangler11 said:I'm guessing you meant to drop a link here and totally blanked on it.

Nah, didn't forget. I was actually waiting for *you* to upload that file to a host—like http://www.dropbox.com/ or whatever—and then just drop the download link right here.

cosmicbison19 said:So... basically, I want to set a path in a Word doc—like pulling images from C:\Users\Documents\BankPhotos\FolderA,
then grabbing images from C:\Users\Documents\BankPhotos\FolderB and dropping each specific photo into its pre-set spot in the document.

You can pull this off using Mail Merge in Word 2007 or even Word 2003.
One big catch though: you’ve gotta use MERGEFIELD and INCLUDEPICTURE by manually punching them in with CTRL+F9.

Quote : Kyle Johnson2

driftingangler11 said:Man, I think I'm just gonna copy those sheets from your example. Way easier than messing around and trying to figure out why the damn bottle won't hold water. 😢

Alright, fine. It’s just a temporary fix, but heads up—if you try running another macro later, things might break again.
Can you just toss that glitchy file—the one that keeps copying itself into the same folder—into the drive? Here's the link to grab it.(Clear out the data.) I only care about the global state within the Workbook. You want me to hit you with some extra code for that?
Can you just hop into the VBA Editor, go to Tools > References, and grab an Alt + PrintScreen of that dialog box? Then just paste it onto a sheet in the Workbook.
Hey.

driftingangler11 said:--------------------------------------------------
Sub myCode()

End Sub

Honestly? This is just extra fluff. Totally unnecessary.

briskeagle52 said:found out Word actually has that option built-in

Don't be stingy, man. Share the wealth with the rest of us. Who knows, maybe someone else is stuck dealing with the same headache

Karen Morales47 said:Is there any way to recover a Word 2010 document I was working on but totally forgot to save????

Nope. Just start a new seminar and hit save immediately. The sooner you get moving, the sooner you're done.

driftingangler11 said:Look, I told you—I tried doing absolutely nothing. Like, zero interference. As if there’s even another Macro out there running before mine does. 😢

I honestly don't even know what to tell you.
That's all I got for ya.
Download it. This is it. Stick the file somewhere on your hard drive. Create a C:\Temp folder on your C: drive, unpack the file there, then run Book1.xls. Update the data and hit that Save button. You should end up with a copy sitting right in C:\temp.
If this doesn't fix it, I'm stumped. Let me know what you ended up doing.

Hey.