Ignoring a runtime error

Hi, I have 7 workbooks (all the same template structure). I also have a mapping workbook that acts as a data source for each. So when any of the 7 workbooks are opened, the mapping workbook opens (and remains open) in the background. When the ...

Message posted on the February 3rd, 2013 - 7:31 AM ET

BVR Announces New Functionality to Pratt’s Stats Deal Database with the Innovative Excel-Based Tool, Pratt’s Stats Analyzer

Business Valuation Resources (BVR) is excited to announce the new Pratt’s Stats Analyzer, a revolutionary Excel-based tool now included with a subscription to Pratt’s Stats®, the leading private company merger ...

Press published on the March 15th, 2012 - 9:13 AM ET

Please help! Cannot open pivotTable source file....

I have to change the pivot table source file name in Excel 2003: From: 12 compilation rapports de fruits 2011-2012 .xls etc... To : 12 compilation rapports de fruits 2012-2013 .xls etc... I wrote this code: Sub AllWorkbookPivots() Dim pt As ...

Message posted on the September 27th, 2012 - 10:18 AM ET

Stallman actually shows some level of reason

<http://www.thevarguy.com/?pB022> It was apparently in reaction to these developments that Stallman recently published a short essay titled, "Nonfree DRM'd Games on GNU/Linux: Good or Bad?" Of course, you don't need to read the body ...

Message posted on the August 13th, 2012 - 4:04 PM ET

Get Data set range from closed workbook

hi, happy new yr. in closed workbook/active workbook, we can use usedrange.rows.count or columns.count to determine the size of data set. However, this is not work in closed workbook. Any ideas to determine the number of rows/cols. in this case? ...

Message posted on the January 6th, 2012 - 1:14 AM ET

Out of resources error message - when not...

Folks I’m having a rather annoying issue with some Excel / VBA code of mine. This is Excel 2007 / Windows 2003. My code is a fairly typical “batch processing” procedure where Excel in launched, retrieves some information from a ...

Message posted on the September 30th, 2011 - 7:13 PM ET

get column name by ADOX

Good day Group, Uses the code below to get the worksheet names from a closed workbook, How to modify the code to also get the column name of the first column into the listbox? Grateful for help, Brgds CG Rosen Sub GetSheetNames() Dim cnn As ...

Message posted on the July 30th, 2011 - 7:24 PM ET

Data Form

I can have the built-in data form open with the workbook with: Private sub Workbook_Open() ActiveSheet.ShowDataForm End Sub The data form appears to be modal so I can't do anything else until it is closed. Can I have the event of closing the data ...

Message posted on the February 1st, 2011 - 5:23 AM ET

XL2010 messing up my templates

I have a template created in XL2000. If I use it to create a new file in XL2010, it works as expected until I try to save it. If I opt to save it as an Excel 97-2003 Workbook (*.xls) I get a warning from Compatibilty Checker that there are probelms ...

Message posted on the December 8th, 2010 - 10:18 AM ET

Save data to closed workbook

Hi Excel 2000. I have an xlt-file which i wanna use for logging calls with a short description of the call, ie. time, names etc. This data is entered in a userform containing about 10 textboxes. Now i want to save this data when clicking the ...

Message posted on the November 16th, 2010 - 2:26 PM ET

How to embed INDIRECT.EXT into workbook Excel 2007

Please. I need to pull data from another closed excel file! Thank you for reading this especially if you are able to help me out on this.

Message posted on the November 7th, 2010 - 5:44 AM ET

save worksheet data to alternate closed workbook - next row

Need to save data on sheet "apples" when code is run to workbook in specifc location/directory. Behind the scenes, i need it to open the workbook, find next available row on sheet "archive", paste data, save, close workbook. ...

Message posted on the October 15th, 2010 - 11:15 AM ET

Use VBA to Populate Listbox from Open Spreadsheet

My head is spinning. I have experience using VBA is a Word 2003 Doc to retrieve a recordset from an Excel Spreadsheet and populate a userform Listbox. However, now I want to use the VBA behind a workbook to retrieve records from one of the sheets ...

Message posted on the October 6th, 2010 - 1:22 PM ET

MS Excel VBA Copy and Paste from external workbook data to central worksheet

I have a MASTER sheet which contains a table of records, which I want a marco to essentially open a targeted external 'read only' spreadsheet, copy specific cell data and paste the specific cell data into a FINAL table located in another worksheet. ...

Message posted on the September 24th, 2010 - 9:18 AM ET

data closed workbook