Hi there,
I am trying to create a macro which uses the workbook open event to run only when 1 specific file (which is always in the same folder and has the same name) opens.
Could someone point me in the right direction at all? or help with just the piece of code that runs on opening by filename?
Thanks
Dustin
Hi Dustin
Can you explain a little more what you are trying to do. Let's call the file X.xlsm
How is file X opened - manually or by macro?
When X is opened what should happen next?
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hi,
If you put the code into the Workbook_Open event of that file, it will only run when that workbook opens.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hi kev,
I use Qlikview to save an extract as CH01.CSV then open the file again via Qlikview (using VB), I then on opening want the vba/macro to run which re-saves the file as CH01.xlsm.
The workbook_open event isnt triggering when i open my file (i also tried manually opening), but when i step into it and trigger it works.
The problem is when i run monthly the previous file gets overwritten so i cant put the macro in the file itself.
Thanks
Dustin
Sorry i just realised it was a rookie mistake, I put my private workbook open in a module and it needed to be in the "thisworkbook" tab.
Thank you for the replies though. I have added the code below just incase it can help anyone else (most of the code i found online, just a few little edits).
Please Login or Register to view this content.
Last edited by aimone111; 05-23-2017 at 06:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks