The name of the software is price mapping tool .
Here it is what it is intented to do .
Here is the problem
Sheet 1 - file 1 is base datafile thats maps our master product file with
master product file received from our suppliers / merchants listing
supplier product code to our product code,
Hello Paul Schreiner Please look at the attachment and the edited post
below .
On Thursday, February 4, 2016 at 6:08:43 PM UTC+5:30, Paul Schreiner wrote:
>
> What kind of "problem in the code" are we supposed to look for?
> at initial glance, all of the spacing is wrong, all of the syntax is wr
On Thursday, February 4, 2016 at 4:27:07 PM UTC+5:30, Saurabh Karangutkar
wrote:
>
>
>- Here is the problem
>
>
>Sheet 1 - file 1 is base datafile thats maps our master product file
>with master product file received from our suppliers / merchants listing
>supplier pro
I threw this together from some macros I created several years ago.I tested it
and cleaned it up a bit.
To insert it into your VBproject:save it to a folder.change the file extension
from ".b" to ".bas"
you should be able to double-click the file,or go into the vbeditor,
right-click in the "modu
Hi Paul/Mandeep,
Sharing the code which you have shared with me,It opens the google sheet
but issue with sending keys combination. So if there is any possible way
to solve this issue,would be helpful.
Sub Fetch_Data_from_Spreadsheet()
Dim ie As Object
Set ie = CreateObject("InternetExplorer.App
In your macro, you CREATE the new workbook:
Workbooks.Add
ActiveWorkbook.SaveAs Filename:=thisWB.Path & "\filter.xls"
But then you immediately CLOSE it!
ActiveWorkbook.Close savechanges:=False
So, then when you filter the data, copy it to the clipboard and select
Sheet1,it's in the CU
What kind of "problem in the code" are we supposed to look for?at initial
glance, all of the spacing is wrong, all of the syntax is wrong.But that is
because sending this embedded in the email as you have has messed up all of the
spacing and indentation (if there is any)
Next, without having a c
- Here is the problem
Sheet 1 - file 1 is base datafile thats maps our master product file
with master product file received from our suppliers / merchants listing
supplier product code to our product code, and supplier name to our name.
This is prepared basis a one ti
Dear All
Please find attached sheet which contain macro.
Basically there is data in sheet Book "Filter Macro".
I need to filter this data on Date basis and filter data need to paste in
new workbook.
Every time filter data then new wokbook will be created.
Now my problem is that its filterd the data
Tried 15 times every time it works perfectly !!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
>
> Do you have more than 1 macro ? Why don't you paste the code in notepad
> and simply replace Msgbox with 'Msgbox and paste it in vba module.
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Faceb
Hi All,
My Requirement is
When user click on Close button(Top Right) in Excel, one Pop-up message
will appear which asks user "Really want to close workbook ?" If user click
on Ok, it will close the workbook, if user click on "Cancel" it will not
close the workbook. I have written code in "Thiswo
Thank you Paul for quick reply,
Your understanding of my requirement is correct. For easy understand of the
requirement i said msgbox code need to be comment out, where as in my
actual macro their are couple of macro lines to be comment out. If you tell
me the way to comment one line of code, i ca
13 matches
Mail list logo