Search results for query: *

Skip! You are my hero! This works perfectly. It's kinda a workaround-esque solution, and I would love to *not* have to do it, but it works! Section of code in the end for anyone interested: Set wb = ThisWorkbook WIP = Application.GetOpenFilename If WIP <> "False" Then secAutomation =...

No change. I really suspect this issue is related to the macro within the workbook (system generated workbook, can't change that.) Is there some easy way to strip out the macro before copying the data? (preferably without having to use .close.

Hey Skip, The trust settings pushed out are "disable all macros with notification" and "trust access to VBA project object model" is not checked. Combo - the settings you recommended, when implemented (using the msdn example) didn't change the outcome. I did stumble on a way to make the macro...

Hi all, I have an interesting issue I've run into. I have a macro that is used to import data from a selected file into a specific location. This macro worked fine in Excel 2007, but has an odd glitch where it will just end when run in 2010. I've tried putting break points on each line that...

For what it's worth, I think this is a built-in function of the ASAP utility add-on, so long as there are fewer than 65,536 rows. http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=267&utilities=20&lang=en_us

Hi Andy, I receive an error whenever that line is commented out, hence the reason for the question! [tongue] "Presentation.Open :Invalid Request. The PowerPoint Frame window does not exist

Ah! Beautiful! I really should know better than to not use Option Explicit, but old habits die hard. Curiosity question, is there a way to avoid needing to make powerpoint visible, and is using Word.Application/PowerPoint.Application going to cause issues in Office 2010?

Hi all! I've been working on a macro (in excel) to remove document information/ from all the powerpoint, excel, and word files within a document, but I'm having a difficult time getting the .RemoveDocumentInformation(type) method to run with any non-excel types. The code will run if I replace...

Thanks Bryan! This code worked almost perfectly! This is nitpicking, but I swapped the direction the page up and page down by switching the referenced subs on keypress to match the excel hotkeys. Sorry for the delay, I had to wait until we were working on a new version of the template to...

Ctrl-pageup and ctrl-pagedown selects the previous/next worksheet respectively, out of the box for Excel. (At least 2007, but I think 2010 and 2013 as well.)

Sorry, I am refering to the functionality of the built-in change worksheet up/down hotkeys. The code is designed as an on event cell selection code, and as such I want to limit which cells can be selected. However, when I enable the option, the hotkey (built-in) no longer functions as expected.

Hi, As part of a template I'm making, several "on event" macros I have running prompted me to keep one worksheet in the template locked without the ability to select the locked cells. For some reason, this has the side effect of disabling ctrl-pageup and ctrl-pagedown to switch between...

While I am still interested in figuring out how to do this, I found a workaround for my specific set. I set the existing pivot tables to a named range data source, and set the named range within the VBA code itself. While this is not a desired solution, it appears to work the same in the end.

Hi all, I'm having an issue correctly modifying the source data for a given pivot table. I currently have the following code: ActiveSheet.PivotTables("PivotTable3").ChangePivotCache ActiveWorkbook. _ PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "ETD WIP...

Try using something akin to this: Select tblCustomer.[Post Code], First(Field1), First(Field2) FROM tbl GROUP BY tblCustomer.[Post Code] Don't forget to GROUP BY the value you only want one of when using the FIRST() function!

This is an excellent point. Selecting things as you goes will slow down your code massively.

Sheets is a more all-inclusive command. For example, you need to use Sheets() instead of Worksheets() to reference a non-standard sheet, like a chart. So far as how to update a cell in a different workbook, you should just be able to use the code you posted. For example, the following code...

According to the Wiki page for RoboRealm, you can script in VBScript, Python, and CScript. I have no experience with it, so I can't confirm this. So far as the "GoTo" question, you can use something like this: 'GoTo instructions pointing to Label1 GoTo Label1: ' Actual label you are pointing...

Haha, business reasons, yes.

Two fold: First, I needed the vba for formatting in a longer macro (hence the sub). Second, I wanted it to be manually added via a function (excel add-in.) It would be easier for the end user to use from the function.