If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
checkbox that controls macros???
Hello:
My co-workers and I have researched this issue for our client hundreds of times and we cannot seem to get an answer. We have created a macro for a few workstations. The macro is ignited from another application that exports data to Excel. After the data is dumped to Excel, the macro formats the spreadsheet and does a few other things. On that workstation--and just that workstation--two Excel spreadsheets are created. There is only supposed to be one spreadsheet. The data from the other app gets dumped into a named spreadsheet but, on this one workstation, a second spreadsheet called "Book 1" is created. It has to be something at this workstation this is causing this additional spreadsheet (Book 1) and not the macro. We have looked at everything and we have run out of ideas. Is there a setup checkbox or something like that in Excel that creates an additional spreadsheet, when a macro is run? Does anyone out there have any ideas? Thanks! childofthe1980s |
Thread Tools | |
Display Modes | |
|
|