background preloader

Holding

Facebook Twitter

Copy an Excel worksheet into a new workbook file. Copy Active sheet to new workbook. [Archive] - VBA Express Forum. Greetings Ral, Hi again - I didn't look at the code you just posted, but after spotting the .Copy (with no dest or paste), had tested a bit and concluded similar. To see what your current code is doing, bring up the workbook as you did during testing. Then bring up the VBE window.

REduce it to about 1/3 or 1/4 screen height so you can see a decent amount of the workbook behind it. With the code window active, place cursor somewhere in procedure. Here is what I see: If MsgBox("Would you like to finalize & save this specification as a new workbook? " '// We first set a reference to the active sheet, so we have now have control over '// it. '//We then got the user's choice as to a filename. strFullname = Application.GetSaveAsFilename( _ InitialFileName:=wks.Name & ".xls", _ FileFilter:="Excel Workbooks (*.xls),*.xls", _ Title:="Enter or Choose a Name") '// We tested to make sure the user didn't cancel the saveas If Not strFullname = "False" Then '... remainder of code...

Hope this helps, Mark.

Blackberry

PLAYMEDIA | new media specialists - web | 3D | interactive | audio visual | new zealand. Flash Isn’t Dead: 30 Brilliant Flash Websites » Web Design » Design Festival. “Flash is dead” is the refrain we’ve heard thousands of times over the past few years. We’ve had debates on the subject on DesignFestival before. And while it’s certainly been disrupted and is falling out of favor as many designers instead focus on a combination of CSS3 and JavaScript, there are still many modern sites using Flash out there. The simple truth is that many of them look great. Here are 30 fantastic Flash websites that prove whether or not Flash is on its last legs, it’s not dead yet. Ecomagination Twitarium Twigital Toyota Prius We Choose The Moon Scourbits Scruffs Game Play Media Erguvan Platin Plate Interactive Pearljam Ten Game Oasis for Fun Mood Stream Monoface Miki Mottes Lucas Arts Knutsel Wereld Intel Infinity Art Hello Voque Get the Glass Gilson Music ff0000 Youtube – Desperados Coca Cola Christmas Tweets Cheese and Burger Adobe Museum 2Advanced Do you have any awesome Flash sites that you would like to share?

Your Complete Guide to Facebook Timeline CIO. Backups | Backupify. StepShot - Document your steps easily.