Ago
04-01-2012, 10:25 AM
I attached the work so far.
It needs to be "installed" in the C:\Users\ <<USER>> \AppData\Roaming\Microsoft\AddIns\
Folder and activated in the excel options "Add-ins" menu.
Once all that is done close excel and open the CSV-file in the zip.
You will get a question if you wish to run a macro, yes.
Now, here comes the problem.
As you could see, changes where made to the sheet/workbook.
In the xlam file there is a module code also, this code is supposed to "undo" the formating.
And it works (if you uncomment the 3 upper rows), but my plan is to make this code easier to run.
Because as of now you have to open the VBA window, open the module and run it.
By creating a new sheet in the workbook, and then rename it to "CSV" without "", the next time you open that sheet it should activate the modulecode.
But the code crashes at wb.Sheets(1).Cells.Select
And thats the big question, why?
The code works as a modulecode but not when it's called from 'ThisWorkbook'.
Or is there a simpler way to activate this code by the user, when the user wants it.
It can not be automated as the rest.
Appreciate any help.
When you "uninstall" this add-in you must delete the folder C:\Flysight\ also which this add-in creates.
It needs to be "installed" in the C:\Users\ <<USER>> \AppData\Roaming\Microsoft\AddIns\
Folder and activated in the excel options "Add-ins" menu.
Once all that is done close excel and open the CSV-file in the zip.
You will get a question if you wish to run a macro, yes.
Now, here comes the problem.
As you could see, changes where made to the sheet/workbook.
In the xlam file there is a module code also, this code is supposed to "undo" the formating.
And it works (if you uncomment the 3 upper rows), but my plan is to make this code easier to run.
Because as of now you have to open the VBA window, open the module and run it.
By creating a new sheet in the workbook, and then rename it to "CSV" without "", the next time you open that sheet it should activate the modulecode.
But the code crashes at wb.Sheets(1).Cells.Select
And thats the big question, why?
The code works as a modulecode but not when it's called from 'ThisWorkbook'.
Or is there a simpler way to activate this code by the user, when the user wants it.
It can not be automated as the rest.
Appreciate any help.
When you "uninstall" this add-in you must delete the folder C:\Flysight\ also which this add-in creates.