Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can my colleagues modify my charts? | Charts and Charting in Excel | |||
Link diverts to c drive when emailed to colleagues | Excel Discussion (Misc queries) | |||
Can I email my colleagues automatically when i update a workbook? | Excel Discussion (Misc queries) | |||
Code not working | Excel Programming | |||
why this code not working | Excel Programming |