Extracting the column index from table name
I have a Table(myTable) With which I am working in VBA and want to extract the column index of a particular column(col_1) so that I can use it in Cells(row,col) for further calculation.
Is it possible? how is it done ?
See also questions close to this topic
xltm file opens when I run a macro
I have a macro enabled template (trainings.xltm file). I create a new Excel workbook from that template (trainings1). That works fine. However, when I run a macro in trainings1, that macro is executed but opens trainings.xltm. If I save trainings1 as 07112017.xlsm and run a macro in that file, the trainings.xltm is opened, too. So there is no difference between the newly created file and a saved file. I don't want trainings.xltm to open automatically every time i run a macro. How can I stop that? I have the macros in the ribbon, I have checked they point to the .xlsm file.
Any ideas are very welcome.
Cut and paste content to next unknown named sheet
I want cut some lines of my activesheet and paste it to the next sheet. But i will never know the name of the next sheet.
How to export / create / map Excel table data to a multilevel xml or group with XPath
I have a excel table of this kind:
Date Time 10-11-2020 7:00 10-11-2020 8:00 10-11-2020 9:00 11-11-2020 5:00 11-11-2020 6:00 11-11-2020 9:00
that i would like to translate/map to an xml file with a structure such as:
<node> <date1> <time1> <time2> <time3> <date2> <time1> <time2> <time3> </node>
what I am currently getting is:
<node> <date1> <time1> <date1> <time2> <date1> <time3> <date2> <time1> <date2> <time2> <date2> <time3> </node>
How can I create such a multilevel structure from excel or alternatively: What would be the Xpath expression to group the date field?
many thanks in advance
Table with a lot of fields for monthly report
In CPA office (acounting) I have a table with basic fields including customer names and ID ....and other details, and beside that in the same table for each customer I have 12 fields (for 12 months), it is yes/no data and it is needed to check if the customer has done the monthly based report or not. another yes/no fields for the annual report .... and others for other purposes. I have a form tracking the monthly reports, and form for the annual reports.... and so on. the problem is that I cannot add more fields i got the error (Property value is too large when I am adding filed in table formatting) all the relations between the customers and the reports is one to one!!!! How to get over this problem, what is the better structure? thanks for helping
Is there a way to download image files from the internet using VBA on Mac?
I’ve tried so many different ways to try and download images from set URLs using VBA on Mac but I keep coming up stumps. I need to download images into a certain folder automatically to be used in a user form. I can download it seems anything but images on Mac! Does anyone have any pointers please?