workbooks.add

Hi Can I say workbooks.add is the same if you open Excel program -->New ? same thing workbooks.open is the same if you open excel program --> Open Also, workbooks.close is the same thing if you click on [x] to close Excel program? Thank you.

I want to create a macro that will create new sheet and save the same if the value in particular cells are >0 I created one but its only saving one sheet at a time and not moving to second macro if the value in first cell is >0 Please assist Sub if_1()If Range("c2").Value > 0 Then...

Hi all, I was re-writing an old macro, and I needed to create a workbook with 11 sheets. So I set Application.SheetsInNewWorkbook = 11. This worked, but I noticed every computer that macro runs on now creates new workbooks with 11 sheets ... I need to figure out the correct number of...

Hello... I do not understand why this I pasting blank rows - With WsTemplate .Range("A1:E" & LstRow).Copy With Workbooks.Add With .Sheets("Sheet1").Range("A1") .PasteSpecial Paste:=xlPasteColumnWidths End With End With End With Thank You...

Hi Group, Had a question and curious if anyone knows an answer for this: I recently had my company switch from Excel 2013 to Excel 2016 and I noticed several reports with Macros have all recently been crashing and getting Errors that are around lines of code like Workbooks.Add and the solution...

I've used Excel to create a group summary page worksheets in a workbook file that is a combination of data pulled from and calculations based on data from about 5 spreadsheets. The summary page(SP) is heavily formatted and uses merged cells extensively(customer requirement). This SP also...

This is my first post as a new member. I have read a great many previous posts in the past and found the information to be very helpful. However, this time I have not been able to find an answer to solve my problem. My problem is that I get the Run Time Error 9 after adding a new file and...

I have a fairly complex workbook which contains a worksheet I use as a template for a new workbook - I populate this as part of a long script which fires when I click a command button on a form, then copy this sheet to a new workbook which I create and save in the same script. This works fine...

Hi, I have an Excel Sheet with some questions on it and I send this this worksheets with VBA code which works in MS Excel but when you put this file on a webpage the Thisworkbook.SaveCopyAs mypath & myfilename debugs. The code is below. Sub SendMail() Dim Msg, Style, Title, Help...

My objective is to parse out records in a single workbook into multiple workbooks based on certain field values for a particular record. As an example, let's assume I had records where a Line of Business field was equal to A,B,C, or D. The ideal code would take all records where Line of...

I apologize for the long message. I've done a lot of testing and scouring the web to isolate the issue and am only posting here. I am using Excel 2007 on Windows XP (32bit) and Windows Vista (64bit). Background: My process loads up single web pages (.htm), does stuff, puts the data onto...