Dear Geunther,
I red a few of your posts and it seems that you have quite a experiance in VBA programing.
For a research I need to copy a range of cells from one tab into all the other tabs in the workbook on the same position as the original, this is quite a lot of work and I try to program a macro for it, till now without succes.
Gould you please help me with bthis function?
many thanks in advance....
User Profile
Collapse
-
thanks, I found it after my post, and am investigating using the code posted.... -
Geunther replied to VBA (Excel) to select random records from multiple tabs and paste them in another tabin Visual BasicIf you have not completed your task, reply, and I will assist you with your code. I write quite a bit of VBA, and this shouldn't be too difficult. The following code will step through each sheet in a workbook, deleting all sheets with less than data through column 5. Keeping your data consistent on the user sheets will be the most important part of the task. If the user data starts on row 5 with only one row of data, the sheet will be retained....Leave a comment:
-
Image storage in SQL Server
I have a project that needs to store images from an excel worksheet to a SQL database. I only have VBA as a tool to accomplish this. I have code to identify all the images on the worksheet that are of picture type. I have the connection strings developed, and am able to write data to the database. My road block is the conversion from an image file (jpg, gif, bmp, etc) to the image datatype in the SQL database. I am aware of the issues with image...
No activity results to display
Show More
Leave a comment: