VBA code not working for my colleagues
Hi there hope someone can shed some light for me...
I have written some codes for preparing data and it works fine for me when running on my pc, however, when my colleagues run the macro, it gives error message for debug. First i thought it was the add-in but it wasn't...Then I thought it was the workbooks are not in separate windows, but i have chosen that option for them already... The code is running until it hits the code: Windows("GSTT File Preparation").Activate Can someone tell me how I can resolve this please? Thanks a lot :) |
VBA code not working for my colleagues
I suspect your fellows have opted to show file extensions while you have
not. http://www.cpearson.com/excel/FileExtensions.aspx -- Jim "vivi" wrote in message ... | Hi there hope someone can shed some light for me... | | I have written some codes for preparing data and it works fine for me when | running on my pc, however, when my colleagues run the macro, it gives error | message for debug. First i thought it was the add-in but it wasn't...Then I | thought it was the workbooks are not in separate windows, but i have chosen | that option for them already... | | The code is running until it hits the code: | | Windows("GSTT File Preparation").Activate | | Can someone tell me how I can resolve this please? | | Thanks a lot :) | |
VBA code not working for my colleagues
Hi,
this works fine for me but errors without the extension Windows("GSTT File Preparation.xls").Activate Mike "vivi" wrote: Hi there hope someone can shed some light for me... I have written some codes for preparing data and it works fine for me when running on my pc, however, when my colleagues run the macro, it gives error message for debug. First i thought it was the add-in but it wasn't...Then I thought it was the workbooks are not in separate windows, but i have chosen that option for them already... The code is running until it hits the code: Windows("GSTT File Preparation").Activate Can someone tell me how I can resolve this please? Thanks a lot :) |
VBA code not working for my colleagues
Thanks a lot....Mike...I will change them tomorrow and see if my colleagues
can run the macro :) "Mike H" wrote: Hi, this works fine for me but errors without the extension Windows("GSTT File Preparation.xls").Activate Mike "vivi" wrote: Hi there hope someone can shed some light for me... I have written some codes for preparing data and it works fine for me when running on my pc, however, when my colleagues run the macro, it gives error message for debug. First i thought it was the add-in but it wasn't...Then I thought it was the workbooks are not in separate windows, but i have chosen that option for them already... The code is running until it hits the code: Windows("GSTT File Preparation").Activate Can someone tell me how I can resolve this please? Thanks a lot :) |
All times are GMT +1. The time now is 04:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com