workbookname

Hello, Briefly I have a code that creates a separate non-macro version of my workbook and saves it with a different name. Works well when used as a normal Macro. However, now i'm trying to get it to execute when my workbook is saved (to keep from having to press a button to save the non-macro...

Hello, Briefly I created a macro that saves my workbook as two versions--a macro enabled version and a non-macro enabled version. The macro works correctly. HOWEVER, it crashes my excel every time I run it. Also as a background, my code saves the second workbook as the same name but with...

Hello, Briefly I have a macro that saves my current workbook as two different files--one that is macro enabled and one that isn't. Runs well. HOWEVER, I cannot for the life of me get my second file to save based off the name of the first file. For example, if my first file is saved as...

Hi im trying to do a lookup in a list found in other workbook. The workbookname is a variable, in this example "Test3720.xlsm" When i write the function with the workbookname "hardtyped", it work fine, with the searched woorkbook both opened and closed... the code goes like this...

Hi, I wan't to use the vlookup formula that needs to search with a variable workbookname. This variable workbookname is in cell N15 and what I have is this: =VLOOKUP("Diameter_ 244.175";'J:\Kwaliteit Helmond\FINAL INSPECTION...

This is the code I have but it really only works when the user has the L: drive which is not always the case. How do I save a file when I users all have different drive letters? Also why doesn't my error handling work? I feel like I don't fully understand how to structure the error handling. All...

I have an excel workbook with a four sheets. I need to extract them with the proper filename, in a specific folder. Until now, I did it manually but ... ... I have a little knowledge of VBA so why not do it automatically? The filename is: "testIntGold_1708261850.xlsm" The numeric part of the...

Hi all, I am trying to copy a range from a sheet called "Test" of active workbook to existing workbook in which a sheet called "Test" (which already exists) but I am not able to copy. Please help. Application.ScreenUpdating = False Dim parentWorkbook As Excel.Workbook Dim...