Recent content by rehanemis

Okay, so here is the code which working fine but it not working when form is remains opens. Means only work once and to use it again I need re-open the form. Private Sub Update_Acc_Click() 'Update Inventory Costings and Qty Dim db As DAO.Database Dim rsSource As DAO.Recordset Dim...

Hi, I have a form where user can choose products and bills generated. The "Billing" table contains information of individual bill i.e Bill ID 101 contains 3 products. I want when user choose the items and click update , the information from Billing table go to inventory table (i.e billno...

Hi, I downloaded this (attached)from internet and working which allowing to connect to backend but issue is that I have backend file open password. I want that I supply backend file password too using VBA and it connect. password is: "unix" I want where is connect to backend so also supply the...

please give me with some example as I don't know about template.

how to create a template? I do need to process the other sheets using for loop.

Hi Pros, I have already written some sub-routines and in my each sub-routine there are two common piece of code. 1. Checking for curtains sheets from which I don't want to take data. 2. The sheet from which I want to take data should be empty of its its B2 cell. For Each ws In...

Suppose I would like to get number from first line which is 1,225 so how do I change the code? as Number might be of 3 digits or some time 5 digits.

Great! Thank you so much! Can you please write comments so that I can understand what is going on in the function?

Hi, I would like to take out the second date from the excel cell as shown below in bold: 3/10/2022 Listing removed $1,225$1/sqft Source: Zillow Rental Network Premium Reporta problem 2/15/2022 Listed for rent $1,225 (+23.1%)$1/sqft Source: Zillow Rental Network Premium Reporta problem 8/13/2019...

Not works

Thanks KitaYama, But currently I have many images inserted and would like embed the current images which are excel cells. So how to do ?

sorry, I tried but can't attach. So can you please share a method vba to convert already inserted images to imbedded images?

Thanks for your reply. I am attached excel sheet with some rows for your review.

I have excel with images in cells. When send the file to other it shows broken links as I just imbedded the excel sheet. So I have more than 150 pictures as I want any vba solution if images are linked then embed.