Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PureSlate

    Macro ending without hitting "exit sub" "end sub" or generating an error.

    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 =...
  2. PureSlate

    Macro ending without hitting &quot;exit sub&quot; &quot;end sub&quot; or generating an error.

    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.
  3. PureSlate

    Macro ending without hitting &quot;exit sub&quot; &quot;end sub&quot; or generating an error.

    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...
  4. PureSlate

    Macro ending without hitting &quot;exit sub&quot; &quot;end sub&quot; or generating an error.

    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...
  5. PureSlate

    Group and split into seperate excel workbooks

    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
  6. PureSlate

    Excel VBA Macro to remove document information

    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
  7. PureSlate

    Excel VBA Macro to remove document information

    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?
  8. PureSlate

    Excel VBA Macro to remove document information

    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...
  9. PureSlate

    Excel 2007 Hotkey question.

    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...
  10. PureSlate

    Excel 2007 Hotkey question.

    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.)
  11. PureSlate

    Excel 2007 Hotkey question.

    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.
  12. PureSlate

    Excel 2007 Hotkey question.

    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...
  13. PureSlate

    Excel 2007 - Modifying PivotTable Source Data

    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.
  14. PureSlate

    Excel 2007 - Modifying PivotTable Source Data

    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...
  15. PureSlate

    list one record and only one record for each postcode in a database

    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!
  16. PureSlate

    Sheets or worksheets usage

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

    Sheets or worksheets usage

    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...
  18. PureSlate

    Robo-real to VBA

    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...
  19. PureSlate

    VBA Function issue (Entire Row formatting)

    Haha, business reasons, yes.
  20. PureSlate

    VBA Function issue (Entire Row formatting)

    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.

Part and Inventory Search

Back
Top