The last couple of days I've been working on some Excel/VBA code.
Considering this is the first time I touched VBA (coming from the C/#/++ camp this is quite disturbing 
), I've learned alot about it, but I'm nowhere near my goal yet.
My situation is as follows:
I've been given a workbook with 12 or so sheets, these sheets are generated by a reporting tool. They come pre-formatted (lines around cells, alot of merged cells 
et cetera) and need to be filled with data. I'm not allowed to make changes in these templates. These raw data are stored on separate sheets in the workbook.
My assignment is to copy the raw data to the formatted report sheets.
I've come up with a reasonably generic solution for this problem. I'ts not very stylish and would be considered ugly to more seasoned VBA-developers, but I does that trick. Or it did.
I just got a mail from my chef telling me I couldn't use Activate (and hence can't use Select et cetera) because the macro(s) is(are) run as/in a background process.
This has left me to conclude that the better part of my old code is ready for the trash bin and I've to start again from scratch. I don't mind, I learned alot in the last couple of days, but I have no idea what to do now.
At the moment I make heavy use of constructions like:
This is to clear the contents of a given column (which later can be resized to fit the data that needs to be copied into it:
The code isn't optimised or whatever, it's more of a conceptual work to get a feel for Excel and VBA.
All this code I can't use anymore and to be honest, I have no idea what to do now.
How do seasoned ExcelVBA developers go out and approach a problem like this? Where should I start? Any tips or pointers are greatly appreciated.
I could whip out a bogus sheet and attach it to the thread to supply you with a better idea of the problem at hand.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks